Hi to every one in the Forum. I am working on a college Project in which I am using VB.NET 2003 & SQL Server2000. I am facing a very silly error in Running SQL Queries. I am not able to Run SQL Queries in which 'AND' is used . What I want is that when a button is clicked Query should Run & Datagrid should be filled with filtered database. eg: To run simple Querie likeSELECT *
what I am coding in VB.Net is:-
SqlDataAdapter2.SelectCommand.Parameters("@param2").Value = TextBox1.Text
DataGrid1.DataSource = DataSet81
DataGrid1.DataMember = "Emp_Information"
But What should be the coding in VB.Net to use
WHERE (FName=?) AND (Date_of_Order=?)
in this case FName & Date_of_Order will be entered in TextBox3 & TextBox6 respectively