Como guardar el contenido de un GRIDVIEW en vb.net
Necesito guardar toda la información que contiene mi GRIDVIEW en mi base de datos (SLQ Server 2008)
For Each row As GridViewRow In GridView3.Rows
'cmd. Parameters. Clear()
Cmd. Parameters. AddWithValue("@IDTIENDA", (row.Cells("TIENDA_GV"). ToString))
Cmd. Parameters. AddWithValue("@NUMCOT", Convert.ToString(row.Cells("IDCOTIZACION_GV")))
Cmd. Parameters. AddWithValue("@NUMPAR", Convert. ToDecimal(row.Cells("No_GV")))
Cmd. Parameters. AddWithValue("@CVEPRD", Convert.ToString(row.Cells("IDPRODUCTO_GV")))
Cmd. Parameters. AddWithValue("@CVEENV", Convert.ToString(row.Cells("IDENVASE_GV")))
Cmd. Parameters. AddWithValue("@CVEACA", Convert.ToString(row.Cells("IDACABADO_GV")))
Cmd. Parameters. AddWithValue("@CANTID", Convert. ToDecimal(row.Cells("CANTIDAD_GV")))
Cmd. Parameters. AddWithValue("@CARGOACA", Convert. ToDecimal(row.Cells("CARGOACABADO_GV")))
Cmd. Parameters. AddWithValue("@CARGOENV", Convert. ToDecimal(row.Cells("IDENVASE_GV")))
Cmd. Parameters. AddWithValue("@PRECIO", Convert. ToDecimal(row.Cells("PRECIO_GV")))
Cmd. Parameters. AddWithValue("@COSTO", Convert. ToDecimal(row.Cells("COSTO_GV")))
Cmd. Parameters. AddWithValue("@FACDET", Convert. ToDecimal(row.Cells("FACTOR_GV")))
Cmd. Parameters. AddWithValue("@IMPORTE", Convert. ToDecimal(row.Cells("IMPORTE_GV")))
Cmd. Parameters. AddWithValue("@OBSDET", Convert.ToString(row.Cells("OBSERVACIONES_GV")))
Next