-----------------------------------------------------------

New Message on BDOTNET

-----------------------------------------------------------
From: Pratap
Message 7 in Discussion

Hi, Hope this will help u   Dim cmd As System.Data.SqlClient.SqlCommand = New 
System.Data.SqlClient.SqlCommand()
            cmd.Connection = cn                ' your ConnectionString which connects 
to Pubs database
            cmd.CommandText = "select * from authors"               Dim dr As 
SqlDataReader
            dr = cmd.ExecuteReader()
            
            ' Loop through the results
            While (dr.Read())
                Label1.Text &= dr("au_id") & " - " & dr("au_lname") & " -  " & 
dr("au_fname") & "<br>"
            End While   All the Best Pratap Bangalore

-----------------------------------------------------------

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the "Remove" link below. On the pre-addressed 
e-mail message that opens, simply click "Send". Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]

Reply via email to