System error while calling fill method for second data

microsoft.public.dotnet.framework

6 May 2007 4:52 AM

Rachana

Hi,
I am having vb2003-net 1.1

Code was working fine yesterday, today getting error
-----------------------------------------------------------
error:
An unhandled exception of type 'System.Data.SqlClient.SqlException'
occurred in system.data.dll
Additional information: System error.
-----------------------------------------------------------
Last line is highlighted. error while calling method for second data
adapter
-----------------------------------------------------------
My Code is :
Dim mDataSet As New DataSet()

       Dim mConn As New SqlConnection()
       mConn.ConnectionString = "Data Source=localhost;initial
catalog=transport;integrated security=XXX"
       mConn.Open()

       Dim mStr1 As String = "select * from mItem"
       Dim mStr2 As String = "select * from mPump"

       Dim mAdapter1 As New SqlDataAdapter(mStr1, mConn)
       mAdapter1.Fill(mDataSet, "mItem")

       Dim mAdapter2 As New SqlDataAdapter(mStr2, mConn)
       mAdapter2.Fill(mDataSet, "mPump")
--------------------------------------------------------------

Need help...

Thanks,
Regards,

Rachana

7 May 2007 3:38 PM

Vijay

can you post more error details. maybe the table doesn't exist any more.