Then you need to loop through the grid view
please follow this algorithm
decalre rwcount as bitint
For (rwcount <> gridview.rows.count )rwcount
{
"Insert into table1 (col1,col2,col3) Values (' " + gridview.row[rwcount].column[0].value
+ "','" +gridview.row[rwcount].column[0].value + "','" +gridview.row[rwcount].column[0].value + "')"
rwcount=rwcount+1
}