[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