add parameter to dataadapter on load

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a very simple page that has a dataadapter which in turn loads a
recordset.
This has been created using drag and drop (VS.NET). I am passing a URL
parameter to the page. This is retreaved with Request.QueryString("hedordID").
How do i pass this to the dataadapter when the page is loaded. I'm really
trying to do this the visual studio way.
1. in Visual Studio i can set the value to a number, say 545 and it works.
2. i tried to set it using the Request.QueryString("hedordID") and i get a
run time error.

Is there an example of this some place or does anyone have a quick answer
for me?
 
ok, Here's what i did.
In the Page load sub i added this after setting the parameter (of type
Proposed) in the code designer.
OleDbDataAdapter1.SelectCommand.Parameters.Item(0).Value =
Request.QueryString("hedOrdID")
Hey, If this helps anyone please mark it so. I have about 140 postings and
no "He's actually helped someone's"
 
Back
Top