Updating dataset for SELECT queries

A

Al Wilkerson

Hello,

Is there a way to update a dataset for select queries.

I have a datagrid that when click on it I select from my access database and
fill the dataset, but the number of rows in the dataset results doesn't get
reset each time i click the datagrid.

Each time a click on the grid, i should have new results (i.e. different
number of rows) from dataset results returned.

Sub DataGrid1_MouseUp(.........)
dim mydataadapter as oledb
sql statement
dataadapter.fill(dataset,conn)

introws = dataset.tables("Products").rows.count


end sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,483
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top