C#

FirstPrevNext

Regional Settings daristos13-Oct-02 22:32 daristos 13-Oct-02 22:32  I am trying to write a program that sends data from a DataTable to an Microsoft Access Database (mdb format) using an OleDBConnection. The regional settings of my computer are set to "Greek". The problem is that the decimal numbers stored in the datatable cannot be transferred correctly to the Access Database. For example, the numer 15.34 (where "." is the decimal point for the US Regional Settings) is stored as 15.340,00 (where "," is the decimal point for the Greek Regional Settings). I have tried to set the regional settings from inside the source code (using the CurrentThread.CultureInfo to "Greek") but that only applies to System.String values, and NOT decimal or floating point. For this reason, the values cannot be stored correctly into the Access DB file. The only way to correct this problem is to manually change the regional settings from the Control Panel, but I would like to avoid this solution. I would appreciate it if you could help me with this issue. Thank you in advance... Dimitris A. Re: Regional Settings Luis Alonso Ramos14-Oct-02 4:04 Luis Alonso Ramos 14-Oct-02 4:04  I had a similar problem some weeks ago using MSDE. I was storing dates using DateTime.ToLongDateString() and DateTime.ToShortTimeString(), but I found out that it generated an exception on systems where Windows was localized to Spanish (dates in Mexico are DD/MM/YYYY as oppossed to MM/DD/YYYY). What I did was to manually construct the date string using DateTime properties (Month, Day and so on) and it worked well on both my English development machine and those in Spanish where it was tested. But I did not find a more elegant way to do this. -- LuisR ──────────────   Luis Alonso Ramos   Chihuahua, Mexico   www.luisalonsoramos.com "Do not worry about your difficulties in mathematics, I assure you that mine are greater." -- Albert Einstein Re: Regional Settings Andrew Lewis16-Oct-02 12:04 Andrew Lewis 16-Oct-02 12:04  You can just format the date using an ANSI standard format (YYYY-MM-DD), I've never found a system/regional setting that doesn't understand that one correctly. Contract Software Developer: andrew_lewis@mail.com Printing Listview contents RK_200013-Oct-02 14:45 RK_2000 13-Oct-02 14:45  Is there any useful articles or classes on printing the contents of a listview in C#? DrawString and tabs Nnamdi Onyeyiri13-Oct-02 5:39 Nnamdi Onyeyiri 13-Oct-02 5:39  IS there a way to set the size of tabs ('\t')? 1001111111011101111100111100101011110011110100101110010011010010 Sonork | 100.21142 | TheEclypse Casting Issues... Nick Parker12-Oct-02 17:28 Nick Parker 12-Oct-02 17:28  I am trying to cast a value from the querystring to an int. For some reason I am getting an error saying: <br /> CS0030: Cannot convert type 'string' to 'int'<br /> My line looks like this, which I am not sure what is wrong with it: int i = (int)Request.QueryString["note_id"]; How do I convert from the string data type represented in the querystring back to an int if what I am doing above does not work. Nick Parker The greatest lesson in life is to know that even fools are right sometimes. - Winston Churchill Re: Casting Issues... James T. Johnson12-Oct-02 17:32 James T. Johnson 12-Oct-02 17:32  Since the QueryString indexer returns a string you can't just cast to get the integer value; instead you need to convert it. You can do this with the Convert class (Convert.ToInt32) or Int32.Parse. James Sig code stolen from David Wulff Re: Casting Issues... Nick Parker13-Oct-02 1:28 Nick Parker 13-Oct-02 1:28  James T. Johnson wrote: You can do this with the Convert class (Convert.ToInt32) or Int32.Parse. Convert.ToInt32(...); worked great James, Thanks James T. Johnson wrote: you can't just cast to get the integer value; instead you need to convert it. Can you explain why, what is the difference between casting it and converting it? Thanks again. Nick Parker The greatest lesson in life is to know that even fools are right sometimes. - Winston Churchill Re: Casting Issues... leppie13-Oct-02 3:47 leppie 13-Oct-02 3:47  Hi Nick Casting is normally between used between inherited types (implicitly) or when a cast has been specified (explicity). Converting (or Parsing) is used between unrelated types and allows one to be converted to the other and/or vica versa. Hope this helps Before you criticize a man, walk a mile in his shoes. That way, when you do criticize him, you'll be a mile away and have his shoes. Where to find .NET compatible languages? Zibar12-Oct-02 5:21 Zibar 12-Oct-02 5:21  Hi, I've tried google but I couldn't find anything useful. Do you know a link to a sites with different .NET compatible languages? I'm particularly interested in Scheme, COBOL, FORTRAN Thank you! Re: Where to find .NET compatible languages? Stephane Rodriguez.12-Oct-02 9:57 Stephane Rodriguez. 12-Oct-02 9:57  Here[^] you go. She's so dirty, she threw a boomerang and it wouldn't even come back. Progress Bar in a status panel... Richard Smith11-Oct-02 13:45 Richard Smith 11-Oct-02 13:45  Does anyone have any hints as how to implement a progress bar for a status panel? I'm not entirely certain how to do it... Any ideas? -- Richard Re: Progress Bar in a status panel... leppie12-Oct-02 10:54 leppie 12-Oct-02 10:54  Richard Smith wrote: Does anyone have any hints as how to implement a progress bar for a status panel? I think you can host controls inside a statusbar panel. But it would probably be better to do a custom statusbar... From MSDN: Typically a StatusBar control consists of StatusBarPanel objects, each of which displays text and/or an icon. You can also provide owner-drawn panels to provide custom panels such as a progress bar or a series of images that displays the state of your application. ... The default StatusBar has no panels. To add panels to a StatusBar you can use the Add method of the StatusBar.StatusBarPanelCollection class that is accessible through the Panels property of the control. You can also use the StatusBar.StatusBarPanelCollection object provided through the Panels property to remove panels from the control and access a specific StatusBarPanel object to manipulate the panel. Now just add the progress bar to the panel Before you criticize a man, walk a mile in his shoes. That way, when you do criticize him, you'll be a mile away and have his shoes. Re: Try this. Masaaki Onishi12-Oct-02 11:32 Masaaki Onishi 12-Oct-02 11:32  Hello, the codegurus around the world.;) Basically, you can put the progressbar control on the status bar on the design tool. But, as you know, this progressbar parent is the Form. So, if we change the size of the form, we also have to change the location of the progress bar. After we get Top and Left of the status bar, we easily update the location of the progress bar. (However, I didn't check the functionality of the progress bar.) Please, don't send me your email about your questions directly. Have a nice day! Sonork - 100.10571:vcdeveloper -Masaaki Onishi- Re: Progress Bar in a status panel... Nick Parker12-Oct-02 17:24 Nick Parker 12-Oct-02 17:24  You might consider what Masaaki has suggested, however I tried something extremely simple which I believe take a lot of the pain out of it. Basically add a status bar to your form, then drag a progress bar onto the status bar placing it in the lower left hand corner of the status bar, you do not need to add a panel to the status bar. With the progress bar item selected go to the Anchor property and click on both the Bottom and Left "bars". The text value inside the Anchor property should read "Bottom, Left". Run your app, the progress bar will stay in sync with you form at all times now. Nick Parker The greatest lesson in life is to know that even fools are right sometimes. - Winston Churchill Re: Progress Bar in a status panel... Cheaters! Richard Smith13-Oct-02 2:53 Richard Smith 13-Oct-02 2:53  Hehehehe, Thanks guys. I think I'll go with the first Idea. It may be a pain in the arse, but once I've done it, I know I'll use it again. Thanks for the cheats... I'll prolly use those if I'm in a rush -- Richard Declaration error. suresh_sathya11-Oct-02 0:43 suresh_sathya 11-Oct-02 0:43  When i run this program,it says Must declare the variable '@Country'. What should i do. string selectSQL = "SELECT CustomerID, CompanyName FROM ustomers WHERE Country = @Country AND City = @City"; OleDbConnection nwindConn = new OleDbConnection("Provider=SQLOLEDB;Data Source=localhost;" + "Integrated Security=SSPI;Initial Catalog=northwind;"); OleDbDataAdapter custDA = new OleDbDataAdapter(); OleDbCommand selectCMD = new OleDbCommand(selectSQL, nwindConn); custDA.SelectCommand = selectCMD; // Add parameters and set values. selectCMD.Parameters.Add("@Country", OleDbType.VarChar, 15).Value = "UK"; selectCMD.Parameters.Add("@City", OleDbType.VarChar, 15).Value = "London"; DataSet custDS = new DataSet(); custDA.Fill(custDS, "Customers"); Re: Declaration error. Paul Riley11-Oct-02 0:50 Paul Riley 11-Oct-02 0:50  Try setting the two parameters before you set the custDA.SelectCommand. Paul Life is just a sexually transmitted desease - Matthew Wright (ex-journalist, TV presenter) 10-Oct-02 I finally have a sig! - Paul Riley (part-time deity) 10-Oct-02 Re: Declaration error. suresh_sathya11-Oct-02 1:18 suresh_sathya 11-Oct-02 1:18  I tried that also,but no use. Re: Declaration error. Paul Riley11-Oct-02 1:23 Paul Riley 11-Oct-02 1:23  Okay... next guess: SELECT CustomerID, CompanyName FROM ustomers... Are you really trying to select from the "ustomers" table? Paul Life is just a sexually transmitted desease - Matthew Wright (ex-journalist, TV presenter) 10-Oct-02 I finally have a sig! - Paul Riley (part-time deity) 10-Oct-02 Re: Declaration error. Paul Riley11-Oct-02 1:34 Paul Riley 11-Oct-02 1:34  Gahhh, I just had a strange flash of inspiration. I'm pretty sure those Parameters.Add("@Variable"... lines shouldn't have the @ symbol in them. @ in the SQL line defines where the parameters are but is not part of the parameter name. Paul Life is just a sexually transmitted desease - Matthew Wright (ex-journalist, TV presenter) 10-Oct-02 I finally have a sig! - Paul Riley (part-time deity) 10-Oct-02 Re: Declaration error. leppie11-Oct-02 9:35 leppie 11-Oct-02 9:35  Paul Riley wrote: @ in the SQL line defines where the parameters are but is not part of the parameter name. All the code I have seen do that (add @), I guess maybe it deals with it internally. Before you criticize a man, walk a mile in his shoes. That way, when you do criticize him, you'll be a mile away and have his shoes. Re: Declaration error. Paul Riley11-Oct-02 10:13 Paul Riley 11-Oct-02 10:13  Really? Shucks! In that case I return to my "ustomers" theory Paul Life is just a sexually transmitted desease - Matthew Wright (ex-journalist, TV presenter) 10-Oct-02 I finally have a sig! - Paul Riley (part-time deity) 10-Oct-02 Re: Declaration error. Daniel Turini11-Oct-02 1:38 Daniel Turini 11-Oct-02 1:38  Try this: selectCMD.Parameters.Add("Country", OleDbType.VarChar, 15).Value = "UK"; selectCMD.Parameters.Add("City", OleDbType.VarChar, 15).Value = "London"; Note there's no '@' on parameter's name, but they are still on the query My latest articles: XOR tricks for RAID data protection Win32 process suspend/resume tool Re: Declaration error. Luis Alonso Ramos11-Oct-02 9:40 Luis Alonso Ramos 11-Oct-02 9:40  Just an idea, but does it matter that the variables are the same name as the fields?? -- LuisR ──────────────   Luis Alonso Ramos   Chihuahua, Mexico   www.luisalonsoramos.com "Do not worry about your difficulties in mathematics, I assure you that mine are greater." -- Albert Einstein

Last Visit: 31-Dec-99 18:00     Last Update: 25-Apr-24 21:30 Refresh ᐊ Prev1...15010150111501215013150141501515016150171501815019 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.