Connectivity of asp.net with sqlserver2005 using vb.net

[navneetkhehra]

hi....to all respectable members.i m a beginner in .net.i want ur help.i am not able to make connectivity of asp.net with sqlserver.plz provide me help.m waiting

[junal]

http://www.aquesthosting.com/HowTo/Sql2005/connect.aspx

hope it helps you !

[jaspermca]

<%@ Page Language="VB" Debug="true"%>
<%@ Import Namespace ="system.data"%>
<%@ Import Namespace ="system.data.sqlclient"%>
<%@ Import Namespace ="system.web.UI.webcontrols.datalist"%>
<%@ Import Namespace ="system.data.sqlclient.sqlconnection"%>
<%@ Import Namespace ="system.data.sqlclient.sqldatareader"%>
Public dbconn As New SqlConnection("Data Source=localhost;" & "database=database name;" & "Initial Catalog= database name;User ID=sa")
‘To open the database
dbconn.Open()
‘to close the database
dbconn.close()
‘ to fetch the records from the table
dim sSql as string
sSql = "select * from userlogin”
Dim cmd As New SqlCommand(sSql, dbconn)
Dim reader12 As SqlDataReader = cmd.ExecuteReader()
If (reader12.HasRows) Then
While reader.read()
Username.text = reader("username”)
Password.text=reader(“password”)
End while