|
|
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.
|
|
|
|
|
Well spotted Luc.
Luc Pattyn wrote: they possibly would not be understood under a different language;
It's a new thing for me. Thanks
BTW Congrats for the CP MVP
|
|
|
|
|
Thanks Raja. And to you too!
|
|
|
|
|
You are also calling cmd.ExecuteNonQuery(); outside of your loop so only the last values entered will be updated in the database. You were advised of this before.
Further more, as you were advised before, you should be using the using statement. The database connection is not being closed properly because the exception is being thrown before your conn.Close() call. The using statement will prevent this.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Hi All,
I am working on a designer which I wish to use for various task, I have however come to a problem which does not allow me to move forward.
according to this link http://msdn.microsoft.com/en-us/library/ms754193.aspx the XAML writer does not preserve event handling during serialization, however I need to use this feature or something very similar. It would be helpful if someone could please provide me with some resources, or links where I can learn how to do this. I am not necessarily looking for codes or pseudo-codes, just some gearing towards the steps or road to take. Thank you.
Yan
|
|
|
|
|
What exactly do you think that a serialized event handler would represent?
What do you expect it to do when you deserialize an event handler?
|
|
|
|
|
Using Windows Form, you cannot directly serialize Buttons or TextBox and other controls, but in XAML you can do this. however if once I have created the button and attached a "click" event per say, then when serializing the button, the xaml serializer will produce and error because of that click event.
My main goal is able to create a user interface, attach event to different controls, and being able to saved (serialize) them to a file, and the same way the other way around.
I hope I was clear enough.
Yanick
|
|
|
|