Parameterized query

wasim_frhat

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...

4 Replies

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

ashug21y ago
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.
sacresp21y ago
Mike, yes I guess the COMmercial one didn't help him ;)
miker21y ago
Sami, Do you really think that Finnish Google gives better answers? :)))
sacresp21y ago
http://www.google.fi/search?q=ado.net+%22Parameterized+query%22+c%23