manpreetdhawan
Member
- Joined
- Jan 20, 2006
- Messages
- 6
- Programming Experience
- Beginner
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 like
SELECT * FROM Emp_Information
WHERE (Emp_Id=?)
what I am coding in VB.Net is:-
SqlDataAdapter2.SelectCommand.Parameters("@param2").Value = TextBox1.Text
DataGrid1.DataSource = DataSet81
DataGrid1.DataMember = "Emp_Information"
DataSet81.Clear()
SqlDataAdapter2.Fill(DataSet81)
But What should be the coding in VB.Net to use
SELECT *
FROM Cust_Database
WHERE (FName=?) AND (Date_of_Order=?)
in this case FName & Date_of_Order will be entered in TextBox3 & TextBox6 respectively