Hi,

I'm trying to build an application where the user could enter data in a datagridview and the it should be inserted into an Access Database (or to SQL Server which ever you will advise me to use)

I know who to create a DataSet, I tried creating a new DataTable in the dataset and bind that to the DGV but I couldn’t get it to work.

Could anybody give me a head start as in which Imports to use, are how to build the Insert Query, or maybe Linq is preferable ( I'm using Vb.net 2008)

Thank you,

Joe

Is this really such a hard task?

It looks as if nobody has got an answer.

But thanks for trying anyway.

This is possible my bro.
U just write sql insert query & then use '" & DataGridView1.Item(1, I).Value & "' instead of '"& textbox1.text&"'

Its is my bro I'm using this tirck in my other project

Pankaj sharma
[email protected]

You mean to loop through the data cell by cell?