|
I see 1 posibility that spring to my mind.
- MySql Connector is not installed on your Vista.
|
|
|
|
|
I am make a report to display info about students but i have a record with each student with declare registration date of each student ,
My Question ? I am Display all info for students in report but i want to display the first value of date of first record and the last date of registered student to know the range (ex. From : 1/1/2010 to 1/2/2011) in the same report to be displayed in the header of the report ?
I want to know the steps ?
|
|
|
|
|
Which part of this are you having problems with?
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
I wouldn't let CG touch my Abacus!
|
|
|
|
|
i WANT TO KNOW HOW I CAN DISPLAY ONLY THE FIRST VALUE OF DATE AND THE LAST VALUE OF DATE WHERE MY SQL COMMAND SELECT ALL ROWS.
report parts
- table to display all student info ( I do this)
- above the table I want to know how i can display date from : ...... to ......) ( I not know how i can do it ?
|
|
|
|
|
You do not state whether your database is Access, SQL Server, MySql, Oracle or whatever.
Still, on the chance that it might help, take a look at this[^] thread, where the OP has a similar problem.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
I wouldn't let CG touch my Abacus!
|
|
|
|
|
|
|
Don't expect to be spoon-fed.
You now have enough information to formulate a suitable search phrase for an internet search.
You know that your database is SQLServer, because it's your database
You know that you are dealing with date data, because it's your data
You know that one way to solve your problem is by use of the Min and Max SQL Functions, because I gave you that information in the link I provided earlier.
All you have to do now is to use your brain and rearrange the emboldened words into a phrase useable with an internet search engine.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
I wouldn't let CG touch my Abacus!
|
|
|
|
|
Did you look at minimum/maximum in the summary totals field?
You should be able to define two summary total fields there (Min and Max) and place them in the header or footer section of the report.
V.
|
|
|
|
|
if any one have information about following point please help me:
architecture of messenger
messenger communication server
messenger email DB server
messenger data flow diagram
create messnger as final project from begin to end project
source code of messenger chatting msn by c#
how the messenger work by programming language
|
|
|
|
|
It is very unlikely that anyone will have this ready to hand you a ready made solution. Try doing some research for yourself (Google is a great tool) and come back when you have a more specific problem to resolve.
I must get a clever new signature for 2011.
|
|
|
|
|
It's you again. From what I can gather, you are attempting to write this for your course work - therefore, the requirement is for you to do the work. You've posted on this several times, and you don't seem to have progressed any in the last two months. What have you been doing with your time?
|
|
|
|
|
He's been trying to find some schmuck to do the work for him. If he put half the effort into actually doing it himself he'd probably be pretty much done by now.
I wasn't, now I am, then I won't be anymore.
|
|
|
|
|
om_metab wrote: create messnger as final project from begin to end project
Yeah, that's not going to happen.
This is where you stand or fall, on your own, demonstrating that you've actually learned something throughout your classes.
|
|
|
|
|
Hi Everybody,
I have developed A Desktop Application in VS 2008. In This One Facility Is Provided To Scan The Document. Firstly It Was Working Fine , But Now A Days I Am Getting The Error a generic error occurred in gdi+ While Saving The File. I Have Set All The Permission To The File Where The Scanned Image Is Saved.
I AM Unable To Resolve The Problem. Please Help Me To Solve My Problem.
Thanks & Regards
Sanket Patil
.
|
|
|
|
|
Without seeing the code where the error occurs, we're just guessing at this.
But, from your vague description, it sounds like you loaded a file using the FromFile method of a Bitmap object and now are trying to save that same file to it's original filename. This doesn't work because the file is locked open for the entire lifetime of the Bitmap object.
To get around this, you open the file using a FileStream object, then pass that stream to the contructor of your bitmap object, then close the file. This prevents the file from being locked and will allow you to dave the new image back to the original filename.
|
|
|
|
|
This[^] might be able to help you.
The funniest thing about this particular signature is that by the time you realise it doesn't say anything it's too late to stop reading it.
My latest tip/trick
|
|
|
|
|
This link[^] refer some such type of problem with solution.
hope it will works for you.
|
|
|
|
|
Hello,
I'm working with windows media player inside a C# winform application.
I couldn't find a good and simple example for working with playlist.
I'll be glad to get some help or an example.
I want to create a playlist from a list of songs name and then give it to the player so it will play them in repet.
(I tried to do it alone with a list of songs and an index but it ddin't work like I thought. The player have to much statuses that he jump between).
Thanks
|
|
|
|
|
Did you find Create a Windows Media Player List[^] here on The Code Project during your searches.
It might help to get you started at least.
There are also other articles covering the subject just search the articles for wmp playlist.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
I wouldn't let CG touch my Abacus!
|
|
|
|
|
This[^] thread may help.
------------------------------------
I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
CCC League Table Link
CCC Link[ ^]
|
|
|
|
|
I have receieved this error , what is the wrong ?
Parameterized Query '(@StartDate nvarchar(6),@EndDate nvarchar(6),@StartTime nvarchar' expects parameter @MarkedListNumber, which was not supplied
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "update VopMessage_tbl set StartDate=@StartDate , EndDate=@EndDate , StartTime=@StartTime , EndTime=@EndTime where MarkedListNumber=@MarkedListNumber";
cmd.Connection = con;
cmd.Parameters.Add("@StartDate", SqlDbType.NVarChar);
cmd.Parameters.Add("@EndDate", SqlDbType.NVarChar);
cmd.Parameters.Add("@StartTime", SqlDbType.NVarChar);
cmd.Parameters.Add("@EndTime", SqlDbType.NVarChar);
cmd.Parameters.Add("@MarkedListNumber", SqlDbType.Int);
con.Open();
for (int t = 0; t < messageSequence.Count; t++)
{
MessageInfo minfo = (MessageInfo)messageSequence[t];
for (int f = 0; f < Set30bytesMessage.Count; f++)
{
VopMessage vms = (VopMessage)Set30bytesMessage[f];
if (minfo.ListNumber == vms.ListNumber)
{
cmd.Parameters["@StartDate"].Value = minfo.StartDate;
cmd.Parameters["@EndDate"].Value = minfo.EndDate;
cmd.Parameters["@StartTime"].Value = minfo.StartTime;
cmd.Parameters["@EndTime"].Value = minfo.EndTime;
}
}
}
cmd.ExecuteNonQuery();
con.Close();
|
|
|
|
|
You're adding a parameter here:
cmd.Parameters.Add("@MarkedListNumber", SqlDbType.Int);
But you're not giving it a value within your for loop.
The error message itself pretty much tells you what is wrong.
The difficult we do right away...
...the impossible takes slightly longer.
|
|
|
|
|
|
Furthermore you seem to be storing dates and times as strings, which is a bad idea for several reasons:
- they don't compare and sort well;
- they are prone to formatting issues;
- they possibly would not be understood under a different language;
- they take up more space.
It is much better to use the actual date, time, or datetime field types your database supports.
|
|
|
|