I'll try and make this as clear as mud. I have a Windows form with details
and a DataGridView connected to an Access database. I have just learned how
to control which cells in the DataGridView have been modified so I can
perform an action when the particular cell is modified. What I have is a
DataGridView column with a ComboBox but when that combobox has a selected
value, I want the textbox next to it to display a value from the database
based on my SELECT statement.
My SELECT statement is as follows:
SELECT ProductDescript ion, ProductID
FROM Products
WHERE (ProductIDNumbe r = ?)
I guess what I want to know is how would I assign the ProductDescript ion and
ProductID to variables and not... say a text box. My stupid workaround now
is bind textboxes to the 2 fields, grab the text property then use it in a
variable. The textboxes visible property is set to false on the form.
Is there a better way to code this? I've always been more of a drag and
drop type of person so the more detailed code the better I'll understand.
Thank you,
Tony
and a DataGridView connected to an Access database. I have just learned how
to control which cells in the DataGridView have been modified so I can
perform an action when the particular cell is modified. What I have is a
DataGridView column with a ComboBox but when that combobox has a selected
value, I want the textbox next to it to display a value from the database
based on my SELECT statement.
My SELECT statement is as follows:
SELECT ProductDescript ion, ProductID
FROM Products
WHERE (ProductIDNumbe r = ?)
I guess what I want to know is how would I assign the ProductDescript ion and
ProductID to variables and not... say a text box. My stupid workaround now
is bind textboxes to the 2 fields, grab the text property then use it in a
variable. The textboxes visible property is set to false on the form.
Is there a better way to code this? I've always been more of a drag and
drop type of person so the more detailed code the better I'll understand.
Thank you,
Tony