There is no problem. Databases don't store the date in a specific format - Don't know about MySql, but SQL Server and Sybase store it as a number, its up to your code to display it how you want. There will be a default format from the database (usually defined at server level) and its up to you to format it how you want.
Bob Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
Thks for ur reply, but it didn't solved my prob.
Interesting thing is date format dd/MM/yyyy in getting inserted correctly on my PC.
but when i deployed at client location its gets entered as dd-MM-yyyy format
coloum Type is varchar 50.
i search google for Open Source DotNet Based Desktop Sharing apps but did not find anything like that so please if anyone knows that there is such open source dotnet based Desktop Sharing apps then please inform me.....i will be highly obliged.
i search google for Open Source DotNet Based Sql Database Synchronization apps but did not find anything like that so please if anyone knows that there is such open source dotnet based apps then please inform me.....i will be highly obliged.
Well, you could create a BItmap from test2.jpg, and assign it to a picture box ?
Driven to the arms of OSX by Vista.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp
sorry sorry that's not what i want....i want to show display privew of web cam befor i take the photos. that mean once i connceted to device i need to start show webcam video on picture box.that's what i want.
i have a excel document saved with temp.xls name.
i wanted to open this xls file as a new xls doucment,
not with the name temp.xls doc, and if we close the doc,
then documnent should ask the user to save file else
give me suggestion to solve this problem.
thanks in advance.
Your question is very hard to understand. You want to have a file called temp.xls, but don't want to open it as such? Create a copy of it and open it. If you don't want it to be overwritten, make it read-only.
tnanks for reply, actuly i saved an excel file into temp folder,
and if we open this file and then close it from upper left corner 'X'(close) button then excel document do not ask to save
the file, untill i don't do any modification in file.
so what i want, if i launch temp
file and then user try to close the file then document should ask
the user to save the file, if user want to save the file then it should ask for the filepath where he want to save, instead of using temp file path, beacuse i am using it for temprary purpose.
I got a Oracle store procedure which would return dataset using a ref cursor,it's quite easy to get the result set if I use the classes in System.Data.OracleClient because there's a type OracleType.Cursor which matches the procedure parameter's type.
But is it possible to do this via ODBC? There isn't a type likes 'OdbcType.Cursor'.
Again, thanks for your replies.
It's a minor miracle, but at least the system is recognizing the namespace. I'm not sure what has changed since numerous times I tried different combinations of Excel Object refs and Office Object Library refs (earlier/later versions).Nothing seemed to work.
I tried one last time by deleting as many refs as possible and referencing only Excel 11.0 Objects. Suddenly it worked. I'm saving this as-is and will experiment later to see if I can replicate the bug.
Last Visit: 31-Dec-99 19:00 Last Update: 3-Mar-21 11:48