Anisha Hosting
£10.00 per month
>> Discover more ...
eCommerce Hosting
£14.00 per month
>> Discover more ...
SQL Server Hosting
£22.00 per month
>> Discover more ...
Anisha Tutorials
Your domain available:

Articles

Windows 2003 - IIS6 Hosting Provider

Dot Net Hosting


MySQL

php


free webmail

FREE WebMail as standard
with all hosting account

 


dotnet hosting visual studio.net

Hosting with a difference ...

 

Tutorial - ADO - Connecting to SQL Server 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

All Rights Reserved Anisha.co.uk