i m using
str="insert into date values('"+TextBox1.Tex)+ "')"; ad=new SqlDataAdapter (str,CT.connect()); dt = new DataTable(); ad.Fill(dt);