HI,

I am trying to connect to a database using Visual Studio .NET. I have created the SQlconnection string and when I am trying to create the DataAdapter using SQLDATAADAPTER tool it aks me to specify the query now my question is If I want to specify a condition in that like " suppose I want to select details from a table where the id of the table is given in a textbox". The query wud be like 'select * from table where tblID = txtId.Text' It doesn;t work if I specify like this.....Can anyone tell me how to specify this.....ur help will be appreciated.