mainrotor
asked on
I need help inserting records from a bound datagridview control in vb.net
Hi Experts,
I have a DataGrieView control in my VB.Net application which I load bind to a tableadapter programmatically.
I am able to update existing records from the datagridview control to the underlying database, but I am not able to insert\add records from the datagridview control to the database.
What am I doing wrong? How can I fix this?
Below, I have added my code, and also the error message I get when I try to add the record to the datagridview:
Code
Error Message
Is there a way to programmatically add the ProviderMasterID, when I click on the Drop Down combobox?
Thank you very much in advance,
mrotor
I have a DataGrieView control in my VB.Net application which I load bind to a tableadapter programmatically.
I am able to update existing records from the datagridview control to the underlying database, but I am not able to insert\add records from the datagridview control to the database.
What am I doing wrong? How can I fix this?
Below, I have added my code, and also the error message I get when I try to add the record to the datagridview:
Code
Error Message
Is there a way to programmatically add the ProviderMasterID, when I click on the Drop Down combobox?
Thank you very much in advance,
mrotor
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
You were close, but I kept getting the error below:
Error:
I fixed it by adding a line of code and modifying your procedure a little (see code below):
Reference to were I got the additional line of code from:
Link to where I got the additional line of code from.
Open in new window
Thank you very much. You will still get the full credit. I really appreciate your help. I had been struggling with this issue for quite a bit.
Thanks,
mrotor