ADO  dotnet
  
asp.net hosting DotNet Hosting  eCommerce Hosting  SQL Server Hosting  ADO DotNet  ASP DotNet  DotNet Tutorials 
  
         
 

Your domain available ?
www.

BUY NOW
ASPNET 4
SQL SERVER HOSTING
SQL SERVER 2012 HOSTINGNew
DOTNETNUKE HOSTING
GET LISTED IN GOOGLE
30 DAY MONEY BACK
OUR PARTNERS
ASP NET TUTORIALS
WEB DESIGN TEMPLATES
TERMS
PRESS ROOM
CONTACT US




 

 

Connecting to SqlServer using ADO.Net and ASP.Net

 

Dim myConnection As New SqlConnection("server=ukcwdswst02;database=pubs;uid=userid;pwd=password")
Dim myCommand As New SqlDataAdapter("select * from Authors", myConnection)


Sub Page_Load(sender As Object, e As EventArgs)
Dim ds As New DataSet()
myCommand.Fill(ds, "Authors")

Dim pRow As DataRow
For Each pRow In ds.Tables("Authors").Rows
Response.write (pRow("au_fname") & "&nbsp;" & pRow("au_lname") & "<BR>")
Next

End Sub

 

 

 

 

 

 

 

 

Stacks of web space and bandwidth with all packages

ASP Hosting £6/Month


.net hosting

.NET Hosting £10/Month
400MB


Terms   Privacy

Copyright ©2002-2011 DotNet We Hosting UK, All rights reserved