中国高铁有多快:vb.net下进行WEB编程,如何连SQL2000数据库!

来源:百度文库 编辑:查人人中国名人网 时间:2024/04/28 16:34:49
如题,在vb.net下进行WEB编程,如何连SQL2000数据库!
我按书上连,一直跟我报找不到“data sourse”关键词!
im sqlcon As New SqlConnection
sqlcon.ConnectionString = "Data Sourse=DDFSTT;database=Usertable;User id=sa;pwd="
Dim sqlcmd As New SqlCommand
sqlcmd.Connection = sqlcon
sqlcmd.CommandText = "select Username from Usertable='" + Me.Usertextbox.Text.Trim() + "'"
Dim name As String = String.Empty
Try
sqlcon.Open()
name = CType(sqlcmd.ExecuteScalar(), String).Trim()
Catch ex As Exception
Me.Lbshow.Text = ex.Message
Finally
sqlcon.Close()
End Try
If Not name = String.Empty Then
Response.Redirect("Usermain.aspx")
Else
Me.Lbshow.Text = "用户名不正确!"
End If

连接的源码贴出来啊,要不怎么知道哪里的问题啊