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

 
    try
            {
                    ss = DateTime.Now;
                objSqlConnection.Open();
                SqlCommand objSqlCommand = new  SqlCommand ("insert into test values ( '" + ss + "',125)",objSqlConnection);
                objSqlCommand.ExecuteNonQuery();
                MessageBox.Show("Inserted sucessfully");
                objSqlConnection.Close();
            }
            catch(Exception ex)
            {
                MessageBox.Show(ex.Message);
                objSqlConnection.Close();
            }

[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

string.Format("{0:MM/dd/yyyy}",DateTime.Now);
 
//or
string.Format("{0:yyyy/MM/dd}",DateTime.Now);

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.