Re: Funky Error during select.

[Chris Cline]

Ok, this might have something to do with it. not sure.

Thinking my problem might be related to the Fill() statement I decided to included the table name during the fill even thow I am requesting data from a single table like so...

MySqlDataAdapter da = new MySqlDataAdapter( Query, this.OpenConnection() );

try
{
_DataTable.Clear();
da.Fill( _DataTable,"plant_history" );
}
catch( Exception ex )
{
throw new Exception( ex.Message );
}
finally
{
this.CloseConnection();
da.Dispose();
}

return _DataTable;

If I include the "plant_history" in the fill() statement I get a complie error as follows:

C:\plant\plant32.cs(1048): The best overloaded method match for 'System.Data.Common.DbDataAdapter.Fill(System.Data.DataTable, System.Data.IDataReader)' has some invalid arguments

The error says it can't convert a string to System.Data.IDataReader.

Any ideas?