virlinz
October 6th, 2005, 11:38 PM
Hi,
Can we fill a dataset with a query?
If the query name is ByPosition, can we do like this?
myAdapter.Fill(myDataset, "ByPosition")
I found out if I'm using Ms Access, this code works successfully but if I'm using MySql, this line will throw an OdbcException error.
Say it is possible to do this, what is the correct way to do for MySql?
Thank you in advance
Can we fill a dataset with a query?
If the query name is ByPosition, can we do like this?
myAdapter.Fill(myDataset, "ByPosition")
I found out if I'm using Ms Access, this code works successfully but if I'm using MySql, this line will throw an OdbcException error.
Say it is possible to do this, what is the correct way to do for MySql?
Thank you in advance