专注收集记录技术开发学习笔记、技术难点、解决方案
网站信息搜索 >> 请输入关键词:
您当前的位置: 首页 > DotNet Exception

未将对象引用设置到对象的实例

发布时间:2011-06-26 20:24:08 文章来源:www.iduyao.cn 采编人员:星星草


Public Shared Function getDataTable(ByVal sql As String) As DataTable
Try
Dim sqlAdapter1 As SqlDataAdapter = New SqlDataAdapter(sql, cnn)
Dim dataSet As DataSet = New DataSet

sqlAdapter1.Fill(dataSet)
sqlAdapter1.Dispose()

Return dataSet.Tables(0)
Catch ex As Exception
errors.Log(ex.ToString)
Return New DataTable

End Try
End Function
为什么会出现这样情况 (有时会出现有时不会出现)
...............................................
未将对象引用设置到对象的实例
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at fashions.DBoperate.getDataTable(String sql)


------解决方法--------------------------------------------------------     

友情提示:
信息收集于互联网,如果您发现错误或造成侵权,请及时通知本站更正或删除,具体联系方式见页面底部联系我们,谢谢。

其他相似内容:

热门推荐: