各位好。我用vb.net 编写了如下代码: Public Function dataConn(ByVal selectStr As String) As DataSet '查询字符selectstr
Dim ConnStr As String = System.Configuration.ConfigurationSettings.AppSettings("connstr")
Dim mydataset As New DataSet
Dim myConn As New SqlConnection(ConnStr)
Dim myAdp As New SqlDataAdapter(selectStr, myConn)
myAdp.Fill(mydataset, 0)
mydataset.AcceptChanges()
myConn.Close()
Return mydataset
End Function但是老是提示:“未将对象引用设置到对象的实例。”
这个有的时候能够运行,有的时候又不能运行了,是怎么回事啊。
错误在:行 7: Dim myConn As New SqlConnection(ConnStr)
行 8: Dim myAdp As New SqlDataAdapter(selectStr, myConn)
行 9: myAdp.Fill(mydataset, 0) '************************这里是错误行**********
行 10: mydataset.AcceptChanges()
行 11: myConn.Close()
Dim ConnStr As String = System.Configuration.ConfigurationSettings.AppSettings("connstr")
Dim mydataset As New DataSet
Dim myConn As New SqlConnection(ConnStr)
Dim myAdp As New SqlDataAdapter(selectStr, myConn)
myAdp.Fill(mydataset, 0)
mydataset.AcceptChanges()
myConn.Close()
Return mydataset
End Function但是老是提示:“未将对象引用设置到对象的实例。”
这个有的时候能够运行,有的时候又不能运行了,是怎么回事啊。
错误在:行 7: Dim myConn As New SqlConnection(ConnStr)
行 8: Dim myAdp As New SqlDataAdapter(selectStr, myConn)
行 9: myAdp.Fill(mydataset, 0) '************************这里是错误行**********
行 10: mydataset.AcceptChanges()
行 11: myConn.Close()
改成myAdp.Fill(mydataset) 呢?
改成 myAdp.Fill(mydataset,“0”) 呢?dbadap.Fill (dbset,"对象名称");