G
Guest
Hi Al
I have two questions about a datagrid, I need to decide which way to go....
I have a datagrid that will show me all the entries in a table. When I click on any cell(actually I would prefer if It could rather select the whole row, where ever I click), I want the data in that datagrid to populate the corresponding textbaoxes on my form, so that the user can edit the values and save them back to the database, and the update the datagrid. How do I do this
Otherwise, what I would like to do is to cut out the populating of the corresponding textboxes and just have the datagrid here I could edit and add new rows, but there are some columns that are lookup columns eg, I have a Manufaturers table, that holds all the possible manufacturers, and a ManufacturersDetail table that holds all the possible contacts for that Manufacturer, So I want to be able to select the manufacturer, then it must filter the possible contacts, but I don't know first of all how to implement the lookup functionality in the datagrid, or the filtering of one field based on the selection of
another field within a datagrid! I have no idea about how to do this. This would definitly be 1st prize, Please can somebody help me, I'm really stuck on this one.And obviously the data stored for the manufacturer/manufacturerDetails are numbers not the actaul description, so I need to store the number but display the description for the manufacturers and manufaturersdetail
Please I need help on this problem desparatly
Thanks soooo much in advanc
Kevin
I have two questions about a datagrid, I need to decide which way to go....
I have a datagrid that will show me all the entries in a table. When I click on any cell(actually I would prefer if It could rather select the whole row, where ever I click), I want the data in that datagrid to populate the corresponding textbaoxes on my form, so that the user can edit the values and save them back to the database, and the update the datagrid. How do I do this
Otherwise, what I would like to do is to cut out the populating of the corresponding textboxes and just have the datagrid here I could edit and add new rows, but there are some columns that are lookup columns eg, I have a Manufaturers table, that holds all the possible manufacturers, and a ManufacturersDetail table that holds all the possible contacts for that Manufacturer, So I want to be able to select the manufacturer, then it must filter the possible contacts, but I don't know first of all how to implement the lookup functionality in the datagrid, or the filtering of one field based on the selection of
another field within a datagrid! I have no idea about how to do this. This would definitly be 1st prize, Please can somebody help me, I'm really stuck on this one.And obviously the data stored for the manufacturer/manufacturerDetails are numbers not the actaul description, so I need to store the number but display the description for the manufacturers and manufaturersdetail
Please I need help on this problem desparatly
Thanks soooo much in advanc
Kevin