Setting a value from a dataset as a variable in asp.net

[rix1505]

My page loads and creates a dataset, and also collects data from the url I
want to compare the data from the url with value from the recordset (i have an
SQL statement that sorts the data to one record, being the lowest in the list
of records) REM Retrieve parameters from the query string Dim m_from
as string = Request('Originator') Dim m_to as string =
Request('Destination') Dim m_body as string = Request('Body') Dim
m_rbid as string = Request('RBID') Dim m_date as string = Request('Date')
Dim m_time as string = Request('Time') REM Just testing by
outputting to page Response.Write('from: ' + m_from + ' ')
Response.Write('to: ' + m_to + ' ') Response.Write('body: ' + m_body + '
') Response.Write('rbid: ' + m_rbid + ' ') Response.Write('date: ' +
m_date + ' ') Response.Write('time: ' + m_time + ' ') REM
Apply logic here REM Compare the incoming bid with the lowest
current bid from the database Dim varLobid = I want to put the
dataset value here, but using DataSet1.FieldValue('Body', container) just
gives an error, saying expected ')' and various other odd error's depending how
i try and write it If m_body < varLobid then Any help greatly appreciated!

[Cirwon]

Originally posted by: rix1505
My page loads and creates a dataset, and also collects data from the url I
want to compare the data from the url with value from the recordset (i have an
SQL statement that sorts the data to one record, being the lowest in the list
of records) REM Retrieve parameters from the query string Dim m_from
as string = Request("Originator") Dim m_to as string =
Request("Destination") Dim m_body as string = Request("Body") Dim
m_rbid as string = Request("RBID") Dim m_date as string = Request("Date")
Dim m_time as string = Request("Time") REM Just testing by
outputting to page Response.Write("from: " + m_from + " ")
Response.Write("to: " + m_to + " ") Response.Write("body: " + m_body + "
") Response.Write("rbid: " + m_rbid + " ") Response.Write("date: " +
m_date + " ") Response.Write("time: " + m_time + " ") REM
Apply logic here REM Compare the incoming bid with the lowest
current bid from the database Dim varLobid = I want to put the
dataset value here, but using DataSet1.FieldValue("Body", container) just
gives an error, saying expected ')' and various other odd error's depending how
i try and write it If m_body < varLobid then Any help greatly appreciated!

[Cirwon]

Well, I have found a partial answer through trial and error.

You can assign the value to a hidden asp text box and use the on click event
to process your code.

<asp:TextBox ID="txtYEMAIL" Visible="false" runat="server" Text=<%#
dsGETEMAIL.FieldValue("EMAIL", Container) %> />

Unfortunatly I haven't found a way to do this in the page on load event.