ok, thanks Micron. I know how to retrieve the full set of records in the first place, yes - using instances of the tools that VB.net gives us for working with the ADO connection. My question is whether I can reuse those same instances of those tools for a new query, or whether I need to create...
Hi there. If I rebuild my table to use autonumber as the PKey, then am I right in saying that I don't have to write a number at all to that field? When I save my dataset to the DB from VB.Net via the ADO connection I just leave that field "null" in the new record???
This is ALMOST exactly what I'm trying to do. I am ignoring the PKEY until the point at which I need to save the new record. Only difference is that I am not using autonumber so I need to find out what number to use.
So the only method is to fully repopulate the entire dataset via the original adapter (SELECT * from Table) which is linked to the datagrid, rather than send an additional SQL query just to return the one piece of data I need? Makes the SQL kind of pointless if I'm going to read everything in...
Yes CJ. I can work out what the SQL needs to be to calculate the nextnumber, but thanks for confirming. What I need to know is how to send that SQL query to the database to retrieve the "current" maximum number. The answer will no doubt include opening the connection and doing something with the...
Not really Micron. I'm asking HOW to get the nextnumber from the database itself- ie how to query it. Ie how does DMax function get its info from the source database rather than from the snapshot we got from the database into the dataset earlier? Perhaps it could be 30 minutes since the dataset...
Hi there. I'm totally new to access programming & ADO, but am already quite a way on from what I was when I started looking into it yesterday.
I am NOT using msaccess, other than to create the accdb tables in the first place. All user interaction is via a VB.Net application.
So I have this...