"用户 'LYC-7F8FD013341\ASPNET' 登录失败。 "在线等!!!!
(windows xp,sql 2000个人版,vb.net,asp.net)
代码是:
<%@ Import Namespace="System.data"%>
<%@ Import Namespace="System.data.SqlClient"%>
<html>
<head>
<title>数据绑定实例1</title>
<script language="vb" runat="server">
Sub Page_Load(sender as object,e as eventargs)
Dim myCon As SqlConnection
Dim myCommand As SqlCommand
Dim myReader As SqlDataReader
Dim constr As String
Dim sqlstr As String
constr="integrated security=SSPI;data source=""LYC-7F8FD013341"";persist security info=False;initial catalog=Test"
myCon=new SqlConnection(constr)
myCon.Open()
sqlstr="select * from Tale1"
myCommand=new SqlCommand(sqlstr,myCon)
myReader=myCommand.ExecuteReader()
myReader.Read()
Response.Write(myReader.GetSqlString(0))
Response.Write(myReader.GetSqlString(1))
End Sub
</script>
</head>
<body>
<form runat="server">
<asp:DataGrid Id="DataGrid1" Runat="server"/>
</form>
</body>
</html>