retrieve data from sql table

[stonehead]

Hi all,
This is a very simple task I guess but since I'm brand new at asp.net I need your help.
I want to set myLabel.text = "update_date" field in mySql table (single row)

My connection string is like this but I have no idea what to do next. Thanks in advance.

Dim myCnn As SqlConnection
Dim MyCmd As SqlCommand


myCnn = New SqlConnection(ConfigurationManager.ConnectionStrings("sqlreports").ConnectionString)
myCnn.Open()

 

[ca8msm]

You'll need to loop through your results. Have a look at some of the examples .


____________________________________________________________
Mark,
[url=http://aspnetlibrary.com][URL unfurl="true"]http://aspnetlibrary.com[/url]

Need help finding an answer? Try the Search Facility or read FAQ222-2244.

 

[stonehead]

Thank you all very much. I was able to get my code work.

http://aspnetlibrary.com

is very helpful.
As for "Search Facility" the tool is not working right now that's why I had to post question before doing just that. Again, thanks.