Are you sure you're passing SqlDbType.DateTime to the Parameters.Add method, and not SqlDbType.Date? The only place I can see that would throw an ArgumentException with a message of "Date" is if you're passing an unsupported SqlDbType value in: internal static SqlCeType FromSqlDbType(SqlDbType type) { for (int index = 0; index < SqlCeType._AllTypes.Length; ++index) { if (type == SqlCeType._AllTypes[index].SqlDbType) return SqlCeType._AllTypes[index]; } throw new ArgumentException(type.ToString()); } This error message has been improved in v4 of the SqlServerCe library. If that's not the problem, can you post the stack-trace of the exception? "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

Solved: The data types in the data table were off. Jude

SledgeHammer01 wrote: Much better design. Nonsense. SledgeHammer01 wrote: so I usually provide an easy to use GUI for them Which means you must STILL provide documentation. And a GUI. So now you have increased the work and time to deliver. SledgeHammer01 wrote: I know where you're going next... web.configs, web services, etc. don't have GUIs So you create a GUI, and documentation for the GUI that handles multiple versions for a process that Operations/Support only uses once per install. Thus quite a bit of additional time and cost - which is your rationalization for ignoring the fact that it rewrites the file? SledgeHammer01 wrote: Entirely incorrect. Something new for you to learn... http://www.w3schools.com/schema/el_sequence.asp[^] See the first example which says "which must contain the following five elements in order" SledgeHammer01 wrote: which has some awesome performance optimization, Yes the high volume tps servers that I have been delivering for the past 15 years do have measured and proven production performance abilities. SledgeHammer01 wrote: The proper way to do ordering in an XML file is by using a key. The proper way is to understand more about what "XML" means. SledgeHammer01 wrote: What does this have to do with anything? What it has to do with is documentation. Please read what I said. Trivial applications might have config values that are understood without documentation but more complex apps require substantial documentation so someone besides the original developer has any chance of understanding what the values mean, how they should be set, what the relationship between different values, etc. SledgeHammer01 wrote: ...and having a non standard API, but thats just me. Yes it is you, because I didn't say anything like that.

Yowza! That too the 27 minute query to less than 4 seconds! Thank you for all of your direction as I am not extremely fluent in SQL. Jude

continue[^] The continue; statement returns the code to the while() line which calls Read(), and that's how it advances to the next row :) :badger:

I don't quite understand your double while loop scenerio, but regardless, as far as I'm concerned, break is a Goto and they both should be burned at the stake. Why not set a flag and include it in your while conditional? I find it much easier to follow code that tells you outright what the conditions are for continuing the loop: salesTotalLoopFinished=false; while (!salesTotalLoopFinished && dbreader.read()) Perhaps a better route to take, though, is to let the db handle the calculation for you: SELECT SUM(daily_sales) AS total_sales FROM storedata WHERE storeid=25 Then you can avoid all of this looping in the first place. Cheers, Drew.

Thanx for the answer....I didn't repost, but I see it. When I try to access ir I receive this error: XML Parsing Error: not well-formed Location: http://www.codeproject.com/script/Forums/Edit.aspx?fid=1649&select=3274455&floc=/Forums/1649/Csharp.aspx&action=r Line Number 63, Column 34:if (typeof(_gat) != "undefined" && _gat) Jude

I figured it out. The contacted the company who produced the connector. It does not support a DateDiff() function :-/ I also contacted the third party vender and they stated that they have a built in function for it. Hopefully that works. Thanks a lot for your time and help! Jude

Thanx a bunch! Jude

Got It!!! Thanx! Jude

Remember that ReportViewer is the easiest way for PDF exportation of data in C# :)as the support is .NET 2.0 native and no driver/3rd party classes are needed. -Spacix All your skynet questions[^] belong to solved

Is that some type of 2005 or + thing? I am still using VS2003..I don't program any big projects in VS and have kept the staple w/ .net 1.1. I got it working with my non-elegant code :) Thanx for the reply! And thank you to all who have replied to this thread for not being an ass! Jude

FolderBrowserDialog Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

yes, read previous post and forgive my brainfart! Jude

Thank you! Jude

Use Arguments property of ProcessstartInfo class to specify "-o" switch #region signature my articles #endregion

Abit VA-20, AMD Barton 2800+, 2GB Corsair DDR 400, 78 GB Raptor. Runs photoshop pretty good, and that is a horse. Jude

Why not just use localhost? Deja View - the feeling that you've seen this post before. My blog | My articles

TheJudeDude wrote: We looked at the database during testing and noticed that sometimes the date were written in the mm/dd/yyyy and time in the 12-hr format. Other times it was in the dd/mm/yyyy and time in the 24-hr format. This tells me you're storing your date/times in your database as a String, not as a DateTime value. If so, this is a HUGE mistake that will cause you all kinds of headaches like this. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007