出错的原因: 用户 'NT AUTHORITY\NETWORK SERVICE' 登录失败。源错误: Sub BindGrid(ByVal strSortField As String) Dim objDataSet As DataSet Dim objDataAdapter As SqlDataAdapter objDataAdapter = New SqlDataAdapter("select au_lname as 'Last Name',au_fname as 'First Name'," & _ " title as 'Book Title',price as 'Retail Price'" & _ " from authors" & _ " join titleauthor on authors.au_id=titleauthor.au_id" & _ " join titles on titleauthor.title_id=titles.title_id" & _ " order by au_lname,au_fname", objConnection) objDataSet = New DataSet '下面这一行是出错的地方 objDataAdapter.Fill(objDataSet, "authors") Dim objdataview As DataView = objDataSet.Tables("authors").DefaultView objdataview.Sort = strSortField grdAuthors.DataSource = objdataview grdAuthors.DataBind() End Sub
但是就那样解决了啊
不会出这种bug吧
对了
可能是connectionString写在web.config里了
要对应着改啊
我解决的办法是,自己重写Connectionstring!
在我自己的机器上.net运行一段时间也会碰到这个问题,把.net重装一下就好了,也不知道是什么原因 在公网服务器上到是没这个问题
mode="InProc"
stateConnectionString="tcpip=127.0.0.1:42424"
sqlConnectionString="data source=127.0.0.1;Trusted_Connection=yes"
cookieless="false"
timeout="20"
/>请问该如何处理?真的急切想知道,还望高人多指点...
用户 'NT AUTHORITY\NETWORK SERVICE' 登录失败。源错误:
Sub BindGrid(ByVal strSortField As String)
Dim objDataSet As DataSet
Dim objDataAdapter As SqlDataAdapter
objDataAdapter = New SqlDataAdapter("select au_lname as 'Last Name',au_fname as 'First Name'," & _
" title as 'Book Title',price as 'Retail Price'" & _
" from authors" & _
" join titleauthor on authors.au_id=titleauthor.au_id" & _
" join titles on titleauthor.title_id=titles.title_id" & _
" order by au_lname,au_fname", objConnection) objDataSet = New DataSet '下面这一行是出错的地方
objDataAdapter.Fill(objDataSet, "authors") Dim objdataview As DataView = objDataSet.Tables("authors").DefaultView
objdataview.Sort = strSortField grdAuthors.DataSource = objdataview
grdAuthors.DataBind()
End Sub