Using a dataset to submit numbers
Ok, related to the user input form in my previous thread, I've changed the form so the user will input the ending number of the range, and the beginning of the range will pull from the Max date of the last number (these are Bill of Lading numbers, if anyone cares) in the SQL database. No problem. I have a dataset, and can show it in a datagrid. What I now need to do is assign the dataset to usable variables, and I'm not sure how to reference the dataset and pull the variables to a usable form that can be re-submitted when the user supplies the ending range and submits the form. So the flow is SQL--->dataset-->user form-->user inputs ending number-->form inserts both beginning number and new ending number into the new row to the same table.
Because I'm new, I built this using Dreamweaver's built in code, which doesn't use inline scripts, it uses MM datatags, and assigns texbox values like:
<Parameter Name="@235_BEGINNING_BOL" Value='<%# Request.Form("B235")+1 %>' Type="Int" />
So my thought was to try request.querystring("Datagrid1")...but there are obviously several values, not just one. Phhhew, sorry this is so complicated.
TIA
Steve
|