Additional information: Cannot find table 0. DataGridView

[ksjoecho]

An unhandled exception of type 'System.IndexOutOfRangeException' occurred in System.Data.dll

Additional information: Cannot find table 0.

   Dim MyDataMiscSource As New DataSet
 
   DBConnMisc = New SqlConnection _
                   ("Data Source=192.168.1.62;Initial Catalog=MyFirstDB;User ID=myuser;Password=mypassword")
 
   ConnectionCMD = New SqlCommand(SQLQueryMisc, DBConnMisc)
 
   DBConnMisc.Open()
        adapterSQLQueryMisc.SelectCommand = ConnectionCMD
 
   MiscDGV.Refresh()
 
   adapterSQLQueryMisc.Fill(MyDataMiscSource)
 
   adapterSQLQueryMisc.Dispose()
 
   ConnectionCMD.Dispose()
 
   DBConnMisc.Close()
 
   MiscDGV.Refresh()
 
   With MiscDGV
      .DataSource = MyDataMiscSource.Tables(0)
      .Columns(0).Width = 170
      .Columns(1).Width = 80
   End With

when I run the application, I am getting an error from the line.

DataSource = MyDataMiscSource.Tables(0)

An unhandled exception of type 'System.IndexOutOfRangeException' occurred in System.Data.dll

Additional information: Cannot find table 0.

How can I solve this error?

[zmbd]

Please attempt to run your compiler and step thru your code first.
Sounds like your connection isn't valid or you have the table index wrong.

[ksjoecho]

I think the table index issue.
How can i fix the index.

Better yet. I think the table is not filled.

Can you help?

[zmbd]

I do not do very much dot-net work so we'll have to wait for one of the other experts to wake-up and take a look at the site.
Meantime it would be a good idea to step thru you code and make sure that the connection opened and that the data actually transferred when you called adapterSQLQueryMisc.Fill(MyDataMiscSource)

[ksjoecho]

It looks like I am getting a different error below:

An unhandled exception of type 'System.ArgumentOutOfRangeException' occurred in mscorlib.dll

Additional information: Index was out of range. Must be non-negative and less than the size of the collection.