DATAGRID QUESTION

[Rick]

I'm trying to build a datagrid by taking a parameter in the query
string and using that in my select or better yet using that to call a
stored proc. I'm using VB.NET.

Please help!

 

[Scott M.]

Dim x as string = request.querystring("queryStringName")

then just just the variable "x" in your select statement or use it in a
Select...Case statement to determine what stored proc. to call.

 

[Rick Azoy]

What if I have data that is being returned through a business class that
calls a stored proc. The fields are being used to populate the page
(e.g. labels, images, etc) Can I use on the fields that are being
returned in my select?

 

[Scott M.]

Can you use *what* on the fields that are being returned (you skipped a word
in your post).?

 

[Rick Azoy]

Sorry! Can I use one of the parameters being returned by the stored proc
(e.g ModelNumber) to run my select and populate the datagrid. In other
words, I would like to do a select on all records containing that
modelnumber. Which would be three, a small, medium and large.

 

[Scott M.]

Sure!

 

[Rick Azoy]

Can you provide a code snippet for that?