Insert lines of data from datagridview into sql database

Question

hi there,
I hope you are all alright,

I need help on how to insert various columns and rows of data from my datagridview1 into a table in an sql database.

kindly show me if you know how and show me an example of code that can do what i am trying to do.
thanks again.
 

Answer 1

hi Jitendra, kindly show me an example of code that can insert the datagridview values, i am just learn c sharp and i have no programming education.thanks

Answer 2

Hi,
Then insert values using insert query.......

Answer 3

thanks Sam, unfortunately in not an experienced developer. however i am not using this datagridview to view data from an sql table but i am using it as a shopping cart where insert values from different textboxes till i have above 20 lines of Products, measure, cost, purpose.

now it these lines that i want to insert into the database table. 

Answer 4

Note that that is not the way that experienced developers would do it. Experienced developers would bind the table to the DataGridView so the data is retrieved from and stored to the table. If you want to do it that way or the way you are asking, then just look at the articles in this web site.