Parameterized query

Question

Hi I prepared DataAdapter with SQL query with two parameters. The Query is: Select * from tblX where (XDate between ? And ?); I built a date grid to bind it with the dataset of the dataAdapter. The two parameters come from two dateTimePickers controles. My problem is how to set to the adapter command the two perameters. I want something like: Select * from tblX where (XDate between dateTimePicker1.Value And dateTimePicker2.Value ); Please help. Regards...

ashug · Answer

Create a select statement for adapter. this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1; this.sqlSelectCommand1.CommandText = SELECT * FROM +  tblx WHERE (XDate BETWEEN @Param3 AND @Param4); this.sqlSelectCommand1.Connection = this.sqlConnection1; this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Param3 System.Data.SqlDbType.DateTime 8 XDate)); this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Param4 System.Data.SqlDbType.DateTime 8 XDate)); this.sqlSelectCommand1.Parameters[0].Value=datepicker1.value; this.sqlSelectCommand1.Parameters[1].Value=datepicker2.value; DataSet ds=new DataSet(); this.sqlDataAdapter1.Fill(ds); DataGrid1.DataSource=ds; DataGrid1.DataMember=tblx; DataGrid1.DataBind(); try this. Hope it will solve your problem.

sacresp · Answer

Mike yes I guess the COMmercial one didn't help him ;)

miker · Answer

Sami Do you really think that Finnish Google gives better answers? :)))

sacresp · Answer

http://www.google.fi/search?q=ado.net+%22Parameterized+query%22+c%23