insert a converted date into database

Mehboob Ali

10y1.1kVisual Basic .NET

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");

11 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ranjit Powar10y ago
Accepted answer
dt=DateTime.ParseExact(textBox1.Text,"dd/MM/yyyy",CultureInfo.InvariantCulture);

SalCommand cmd = new SalCommand ("insert into dates values(@Date)",con);

cmd.Parameters.AddWithValue("@Date",dt)
con.Open();
cmd.ExecuteNonQuery();
con.Close();
Ranjit Powar10y ago
If your problem solved then select the correct answer.
Mehboob Ali10y ago
Thanks Ranjit Powar. SqlCommand worked
Raja T10y ago
Hi Ali,Please send to me your dates structure? which one/method are you tried?
Mehboob Ali10y ago
Not working; same error
Raja T10y ago
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 Ali10y ago
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 Powar10y ago
hey sorry

just pass dt

SqlDataAdapter sda = new SqlDataAdapter("insert into dates values('"+dt.ToString()+"')",con);
Mehboob Ali10y ago
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 Powar10y ago
Try this

DateTime dt=DateTime.ParseExact(textBox1.Text,"dd/MM/yyyy",CultureInfo.InvariantCulture);

SqlDataAdapter sda = new SqlDataAdapter("insert into dates values('"+dt.Value+"')",con);
DataTable dt = new DataTable();
Amit Kumar Singh10y ago
https://msdn.microsoft.com/en-us/library/aa984467(v=vs.71).aspx