Groups | Blog | Home
all groups > visual studio .net general > september 2005 >

visual studio .net general : Help please: VS2k3 parameters with SQL Server 2k



kvr901
9/14/2005 12:10:02 AM
Hello,

I'm very new to both SQL Server and VS.NET 2003. I am learning, but have a
long way to go.

Creating a webform with a SqlConnection, SqlDataAdapter, and a Dataset I can
have a DataGrid fill in, but have thus far been unable to figure out how to
have the DataGrid fill in one selected record using a parameter that the user
types into a text control on the webform.

The part I am having difficulty with is parameters. Can a webform text
control be referenced in a query like can be done in Access, or is this not
possible?

TIA
kvr901
9/14/2005 12:34:32 PM
Perhaps my question is not clear. I will try another way...

Using a webform, SqlAdapter, a DataSet, and a DataGrid I can click a button
and fill the grid. Thus far I have been unable to find a simple way to
select a single record without hard-coding a parameter. What I want to be
able to do is have the user type a value into a Textbox, push a button, and
have the datagrid display that one record. In Access it was a simple matter
to type something like this =Forms!formname!controlname into a criteria box
of a query. Is there a similar way to do this in VS.NET with SQL Server?

Please tell me if I should direct my question to a different news group.

AddThis Social Bookmark Button