insert a converted date into database

Question

My System date format is customized as dd/MM/yyyy

when i enter date e.g 25/02/2016 than in textbox c# windows form, it gives error System.Data.SqlClient.SqlException

My Code is given below

private void button1_Click(object sender, EventArgs e)

{

SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=Test;User ID=abc; Password=****");

SqlDataAdapter sda = new SqlDataAdapter("insert into dates values('"+textBox1.Text.ToString()+"')",con);

DataTable dt = new DataTable();

sda.Fill(dt);

MessageBox.Show("Data Inserted");

Ranjit Powar · Answer

dt=DateTime.ParseExact(textBox1.Textdd/MM/yyyyCultureInfo.InvariantCulture); SalCommand cmd = new SalCommand (insert into dates values(@Date)con); cmd.Parameters.AddWithValue( @Date dt) con.Open(); cmd.ExecuteNonQuery(); con.Close();

Ranjit Powar · Answer

If your problem solved then select the correct answer.

Mehboob Ali · Answer

Thanks Ranjit Powar. SqlCommand worked

Raja T · Answer

Hi AliPlease send to me your dates structure? which one/method are you tried?

Mehboob Ali · Answer

Not working; same error

Raja T · Answer

Hello Ali Try like private void button1_Click(object sender EventArgs e) { string iString = 26/01/2016; DateTime dt = DateTime.ParseExact(iString dd/MM/yyyy CultureInfo.InvariantCulture); SqlConnection con = new SqlConnection(Data Source=.;Initial Catalog=Test;User ID=abc; Password=****); SqlDataAdapter sda = new SqlDataAdapter(insert into dates values('+ dt +')con); DataTable dt = new DataTable(); sda.Fill(dt); MessageBox.Show(Data Inserted); }

Mehboob Ali · Answer

Error: System.Data.SqlClient.SqlException. Additional information: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

Ranjit Powar · Answer

hey sorry just pass dt SqlDataAdapter sda = new SqlDataAdapter(insert into dates values('+dt.ToString()+')con);

Mehboob Ali · Answer

Thanks Ranjit Powar for reply but it still it gives error Error CS1061 'DateTime' does not contain a definition for 'Value' and no extension method 'Value' accepting a first argument of type 'DateTime' could be found (are you missing a using directive or an assembly reference?)

Ranjit Powar · Answer

Try this DateTime dt=DateTime.ParseExact(textBox1.Textdd/MM/yyyyCultureInfo.InvariantCulture); SqlDataAdapter sda = new SqlDataAdapter(insert into dates values('+dt.Value+')con); DataTable dt = new DataTable();

Amit Singh · Answer

https://msdn.microsoft.com/en-us/library/aa984467(v=vs.71).aspx