I have successful imported data from excel to a datagrid using vb.net.
Now,could anybody help me with a code to insert all the data from the datagrid into a table.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Sam HobbsPosted Jul 26, 2010, 11:49 PM
Hiren SoniPosted Jul 26, 2010, 8:16 AM
you have to make for loop which iterate through all the rows and columns,
you have to get its value and you have to insert one by one row in table.
if you are inserting all the data in the table.
while importing in datagrid , at the same time you can also insert in the table.
it will be easier than doing this !!
---------
don't 4get to accept answer, if it helps you!!!
Raghavendra UPosted Jul 26, 2010, 8:02 AM