datagridview
I am using vb.net and access database. I have a datagridview with 20 rows and 5 columns( filed name in access table as follows: S.no,product_code,product_name,qty.rate).I want to update all datas which I entered in the datagridview to the concernd table.. Can you plz give me the code for updating database. table name: Iteminvtbl button name ( for update): updatebtn I tried in different ways,But I failed.
Software/Hardware used:
Software/Hardware used:
ASKED:
May 7, 2012 9:04 AM
UPDATED:
May 9, 2012 11:53 AM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
Pavel 
45 pts. ,
TomLiotta 107,735 pts.
45 pts. ,
TomLiotta 107,735 pts. To see all answers submitted to the Answer Wiki: View Answer History.
“I want to update all datas which I entered in the datagridview to the concernd table”
Dos that mean that those records already exist in the database but you want to update them with the data from the grid ? Or is it inserting them into the table what you really want to do ?
“I tried in different ways,But I failed. ”
It would be useful to see the ways you have already tried. Can you post them ?
<a href=”http://www.techyv.com/solved”>Here is my code</a>, but its the other way around, it commits changes to the datagridview when the database is updated
As usual, the “techyv” link doesn’t help at all. It’s not clear why such bad information keeps getting linked here except to advertise an almost useless site. — Tom