hello sir i am facing error while iinserting date from textbox into database with datatype datetime
protected void Page_Load(object sender, EventArgs e)
{
TextBox3.Text = DateTime.Now.ToString("dd/MM/yyyy");
TextBox4.Text = DateTime.Now.AddDays(10).ToString("dd/MM/yyyy");
}
protected void Button1_Click(object sender, EventArgs e)
{
DateTime dt1 = DateTime.Parse(TextBox3.Text);
DateTime dt2 = DateTime.Parse(TextBox4.Text);
SqlCommand cmd = new SqlCommand("rent_data", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@member_id", TextBox1.Text);
cmd.Parameters.AddWithValue("@isbn", TextBox2.Text);
cmd.Parameters.AddWithValue("@issue_date", TextBox3.Text);
cmd.Parameters.AddWithValue("@due_date", TextBox4.Text);
con.Open();
cmd.ExecuteNonQuery();
con.Close();