[thelist] ASP.NET displaying data on a page

Casey aspnet at thecrookstons.com
Wed Aug 10 21:05:12 CDT 2005


Oops.  Sent this just to Ken the first time.  Try again...

----- Original Message ----- 
From: "Ken Schaefer" <Ken at adOpenStatic.com>

> When you want to display this stuff, you can assign data from the dataset
(or
> a datatable in the dataset) to label controls, or literal controls, or
> whatever you want

Okay.  That makes lots of sense.  Here's what I've got so far:

Sub Page_Load(Src As Object, E As EventArgs)

dim getDoc as string=request.querystring("id")

dim dsDocs as Dataset = New DataSet()

Dim conDocs as SqlConnection = New SqlConnection( "server='123.abc.com';
user id='xyz'; password='xxx'; database='zzz'" )

Dim daDocs as SqlDataAdapter = New SqlDataAdapter( "SELECT fname FROM
doctors WHERE doc_id= '" & getDoc & "'", conDocs )

daDocs.fill(dsDocs)

lblDocfname.Text=?????

end sub

Am I even headed in the right direction?  I'm getting this from ASP.NET
Unleashed, just FYI.  What would I put in place of the ??? to populate the
label with the contents of fname?

TIA




More information about the thelist mailing list