Hi, I have a datagrid in a form that displays information from a access database.
To add data to this database, you have to open a form enter all the details into textboxes and then use a parameterised query.
I've heard that its possible to edit data directly from the datagrid control, how would I go about doing this?
Also when I search for a unique ID (reference number for me) that each record in a table has I want this to be displayed on textboxes.
Eg, I have a textbox on one form and using this I can search for a particular reference number. How do I make it so that the results of this search are displayed on a series of textboxes on the same form.
To add data to this database, you have to open a form enter all the details into textboxes and then use a parameterised query.
I've heard that its possible to edit data directly from the datagrid control, how would I go about doing this?
Also when I search for a unique ID (reference number for me) that each record in a table has I want this to be displayed on textboxes.
Eg, I have a textbox on one form and using this I can search for a particular reference number. How do I make it so that the results of this search are displayed on a series of textboxes on the same form.