sorry for the miistake sir , after using the namespace that code is working but again there is a error
: Error converting data type nvarchar to datetime.
Source Error:
Line 31: cmd.Parameters.AddWithValue("@due_date",TextBox4.Text);
Line 32: con.Open();
Line 33: cmd.ExecuteNonQuery();
Line 34: con.Close();
|
protected void Button1_Click(object sender, EventArgs e)
{
//DateTime dt1 = Convert.ToDateTime(TextBox3.Text);
DateTime dt2 = Convert.ToDateTime(this.TextBox4.Text, new CultureInfo("en-GB"));
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();