You have to use the control like TextBox to enter the Date and use the Using keyword.
public int EventInsert()
{
DateTime dateFrom = DateTime.Now;
DateTime dateTo = DateTime.Now;
string constr = ConfigurationManager.ConnectionStrings["consrt"].ConnectionString;
using (SqlConnection conn = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("INSERT INTO Car(CarName, DateFrom, DateTo,TimeFrom, TimeTo) Values(@CarName,@dateFrom,@dateTo,@TimeFrom,@TimeTo)", conn))
{
conn.Open();
cmd.Parameters.AddWithValue("@CarName", this.txtCarName.Text);
cmd.Parameters.AddWithValue("@dateFrom", DateTime.Now);
cmd.Parameters.AddWithValue("@dateTo", this.txtDateTo.Text);
cmd.Parameters.AddWithValue("@TimeFrom", this.txtTimeFrom.Text);
cmd.Parameters.AddWithValue("@TimeTo", this.txtTimeTo.Text);
cmd.ExecuteNonQuery();
conn.Close();
}
}
}
Thank You.