displaying the records from sql server based on selected date using asp.net with c# is not working

See more:

C#2.0

C#

ASP.NET

SQL-Server

Hi, I am using asp.net 2.0 with C#.

In Asp.net I am using one textbox for input for date based on enter date.

I have to display the records in a gridview but it is giving null result

Can you correct my code which helps me?


I am having the table with fields.

TblDetails
========
Notes nvarchar(50)
ItemKeyName nvarchar(50)
time1 datetime (data is stored in dd/MM/yyyy)

protected void Button1_Click(object sender, EventArgs e)
{
SqlDataAdapter da = new SqlDataAdapter("select * from TblDetails where time1='"+Convert.ToDateTime(TextBox1.Text)+"'",con) ;

DataSet ds = new DataSet();
da.Fill(ds, "t");
GridView2.DataSource = ds.Tables["t"];
GridView2.DataBind();

}