Error from OdbcDataAdapter.Fill

Question

I sometimes get two different of error when executing OdbcDataAdapter.Fill(DataTable). Here is the code example:

string odbc = "select item, upcno from table";
OdbcCommand cmd = new OdbcCommand(odbc, fconn);
OdbcDataAdapter oda = new OdbcDataAdapter(cmd);
oda.Fill(dt);

System.NullReferenceException: Object reference not set to an instance of an object.
System.InvalidOperationException: No data exists for the row/column.

Does anyone have clue to resolve this problem?

Is that the real SQL or a demo? Because those names are questionable. `Table` is a reserved word, for instance. — DonBoitnott, Jun 06 '13 at 17:18
Are you instantiating `dt` first, such as: `DataTable dt = new DataTable();`? — DonBoitnott, Jun 06 '13 at 17:23
@user2460647 have you try my answer, are you still get above exceptions? — Damith, Jun 06 '13 at 17:30

score 0 · Answer 1 · answered Jun 06 '13 at 17:21

Not sure where you get connection object from your question but you can do as below. don't create class level connections, you can create it when you want and properly dispose it at the end.

public DataTable GetDataTableFromAdapter(string queryString)
{
    DataTable dt = new DataTable();
    using (OdbcConnection connection =
                new OdbcConnection(ConnectionString))
    {
        using (OdbcDataAdapter adapter =
                new OdbcDataAdapter(queryString, connection))
        {
            connection.Open();
            adapter.Fill(dt);
        }
    }
    return dt;
}

Call it as

DataTable dt = GetDataTableFromAdapter("select [item], [upcno] from [table]");

I'm testing your suggestions, and it looks better now. let see how it goes — user2460647, Jun 06 '13 at 18:28

Error from OdbcDataAdapter.Fill

1 Answers1

Linked