The easiest way might be putting them both into DataValueField. Modify your select statememnt so it concatenates stvsbgi_code and stvsbgi_term_code_eff into one column and then bind DataValueField to it. Later you can get the Value and split it up again.
Sergey > -----Original Message----- > From: Michael Gerholdt [mailto:[EMAIL PROTECTED]] > Sent: Saturday, September 21, 2002 3:25 PM > To: dotnet > Subject: data binding question > > > I'm doing this to bind for a dropdownlist, but also in the > same SQL query for a third value I'd like to place in a > global variable to be used by a later query. > > I'm selecting > stvsbgi_desc > stvsbgi_code > stvsbgi_term_code_eff > > Schools.DataTextField = "stvsbgi_desc" > Schools.DataValueField = "stvsbgi_code" > Schools.DataSource= dsTemp.Tables("stvsbgi,shbtatc").DefaultView > Schools.DataBind() > > How can I also put the value for stvsbti_term_code_eff into > another variable for later reference? > > I'm hitting on an Oracle database using the MS .NET provider > for Oracle. > > Thanks, > Mike > > > --- > You are currently subscribed to dotnet as: > [EMAIL PROTECTED] To unsubscribe send a blank email to > %%email.unsub%% > > --------- > Administrated by 15 Seconds : http://www.15Seconds.com > List Archives/Search : http://local.15Seconds.com/search > Subscription Information : http://www.15seconds.com/listserv.htm > Advertising Information: http://www.internet.com/mediakit/ > > > --- You are currently subscribed to dotnet as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] --------- Administrated by 15 Seconds : http://www.15Seconds.com List Archives/Search : http://local.15Seconds.com/search Subscription Information : http://www.15seconds.com/listserv.htm Advertising Information: http://www.internet.com/mediakit/
