Unable to use date through textbox

Hi,
I need to display the gridview depends upon the date. For this , i used 2 Textbox which take date as an input from the user. Everything works good except the date part. When i am passing the value through textbox, sql query is not working. Any suggestion?
I am using following query :
protected void Calendar1_SelectionChanged(object sender, EventArgs e)
{
TextBox1.Text = Calendar1.SelectedDate.ToString();
}
protected void Calendar2_SelectionChanged(object sender, EventArgs e)
{
TextBox2.Text = Calendar2.SelectedDate.ToString();
}
SqlCommand cmd = new SqlCommand("select * where ID.EventStartTime between '" + TextBox1.Text + "' and '" + TextBox2.Text + "' order by ID.EventStartTime desc", con);
con.Open();
SqlDataReader read = cmd.ExecuteReader();
GridView1.DataSource = read;
GridView1.DataBind();
con.Close();

Regards
Tushar Goel

1 Reply

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

Rajesh S15y ago
Hi friend it may be help for you. SqlCommand cmd = new SqlCommand("select * where ID.EventStartTime between '" + Convert.ToDateTime(TextBox1.Text) + "' and '" + Convert.ToDateTime(TextBox2.Text) + "' order by ID.EventStartTime desc", con);