fast replay : regional setting

[hemantpatil]

i am writing following code to insert value in table test which has two fields
id , current_ date but if i change
regional seting English(United Staes ) to french(France) then it hows error

it show error if regionl setting is English(United Staes ) value inserted sucessfully
any one tell how i set regional setting for my project
[code=cpp]

try
{
ss = DateTime.Now;
objSqlConnectio n.Open();
SqlCommand objSqlCommand = new SqlCommand ("insert into test values ( '" + ss + "',125)",objSql Connection);
objSqlCommand.E xecuteNonQuery( );
MessageBox.Show ("Inserted sucessfully");
objSqlConnectio n.Close();
}
catch(Exception ex)
{
MessageBox.Show (ex.Message);
objSqlConnectio n.Close();
}[/code]

[kunal pawar]

Can u tell Error ??
It may be the problem of column name. Whn u changed the Regional setting it will change Column name too, which are not same as SQL Server Table column name

[hemantpatil]

hi
error is conversion char datatype to datatype datetime
&& current date in following forat 01/01/0001 00:00:00

[mzmishra]

You have to specify the proper Date format while inserting the data.

[CyberSoftHari]

You have to insert the date format as

[CODE=cpp]string.Format(" {0:MM/dd/yyyy}",DateTime .Now);

//or
string.Format(" {0:yyyy/MM/dd}",DateTime.N ow);[/CODE]
Otherwise it will consider as string.

[Frinavale]

You should check your Resources that handle your Cultural Regions so that it formats dates as well as other data types (like numbers) correctly.