Need Help With MySQLDriverCS

[Greg Nohalty]

When I try to fill a DataAdapter I Get the following error " wrong querry. No database selected" Can anyone give me an idea of what I am doing wrong?

here is what I am trying to do:

// Generate a Connection and open it
myConnection = new MySQLConnection(ConnStr);
myConnection.Open();


// fill the data set
myDataSet = new DataSet();
MyDataSet.Tables.Add("tblcompany");

string sqlstr = "SELECT * FROM tblcompany";
myDataAdapter = new MySQLDataAdapter();
myDataAdapter.SelectCommand = new MySQLCommand(sqlstr, myConnection);
myDataAdapter.FillSchema(myDataSet, SchemaType.Mapped);
myDataAdapter.Fill(myDataSet);