I'm using vb.net and the dataset designer to get data from a mysql database.
In the dataset designer, I've added a query to the datatable, I'd like to know if I can programmatically change the sql query that's stored in this datatable at run time.
Currently to get the data I'm using :
cliTableAdapter2 = New simplyDataSetTableAdapters.DataTable2TableAdapter
cliDataSet2 = New simplyDataSet
Catch ex As Exception
I've tried using a wildcard in the SQL statement to use a parameter at run time but it gives me the following error : No mapping exists from dbType Object to a known OdbcType.
I'd like to know If I can change that sql string at runtime to something else.