I am creating a ASP. Net application that accesses a MS Access Database.
the main table is houses which has a field named featuresID which references a table Storing boolean values for a set of features. How can i get it to add the features to the feature table then know what the id to reference that set just added is. is there a last record command or a way of knowing what the id for them will be
any help greatly appreciated
frankYes, the first thing that comes to mind is if you are using a dataset you can use rows.count and get the number of rows which is going to tell you how many entries there are and you can just grab the last row out of that and know everything about it... it would have to be the last thing that was added if the id is autonumber and the set is sorted by id.
the main table is houses which has a field named featuresID which references a table Storing boolean values for a set of features. How can i get it to add the features to the feature table then know what the id to reference that set just added is. is there a last record command or a way of knowing what the id for them will be
any help greatly appreciated
frankYes, the first thing that comes to mind is if you are using a dataset you can use rows.count and get the number of rows which is going to tell you how many entries there are and you can just grab the last row out of that and know everything about it... it would have to be the last thing that was added if the id is autonumber and the set is sorted by id.