ASP.NET - import data from aspxgridview to Database

try this

You can loop through the whole GridView, and get data from each row. Then insert these data (each row) into test table row by row. Here is my sample:

protected void SaveButton(object sender, EventArgs e)
    {
    SqlConnection conn = new SqlConnection(@"your_connection_string");
    conn.Open();
    foreach (GridViewRow gvr in GridView1.Rows)
    {
      string data1 = gvr.Cells[0].Text;    //get data from BoundField in each row
      string data2 = ((Label)gvr.FindControl("Label1")).Text;    //get data from control in TemplateField in each row
      SqlCommand cmd = new SqlCommand("insert_sql", conn);   //generate insert sql using above data
      cmd.ExecuteNonQuery();
    }
    conn.Close();
    }

Hope this will help you.

Public Function PutBondInfo(ByVal data As String) As DataSet
      Try
        Dim zh As New ZipHelper
        Dim sz As String
        Dim cn As SqlConnection
        Dim da As SqlDataAdapter
        Dim ds As New DataSet
        Dim xSet As New DataSet
        Dim sSql As String

        Dim mySerializer As XmlSerializer = New
XmlSerializer(ds.GetType())

        cn = New
SqlConnection("server=HLSQL;uid=test;pwd=;database=test")
        cn.Open()
        da = New SqlDataAdapter("SELECT * FROM BondStatus", cn)
        'da.TableMappings.Add("BondStatus", "NewDataSet")

        sz = zh.Decompress(data)
        zh = Nothing

        da.FillSchema(ds, SchemaType.Mapped, "BondStatus")
        'da.MissingSchemaAction = MissingSchemaAction.AddWithKey
        da.Fill(ds, "BondStatus")

        Dim st As New MemoryStream(Encoding.UTF8.GetBytes(sz))
        ' Create the object from the xml file 
        xSet = CType(mySerializer.Deserialize(st), DataSet)
        xSet.Tables(0).TableName = ds.Tables(0).TableName

        ds.Merge(xSet, False, System.Data.MissingSchemaAction.Add)

        'ds.AcceptChanges()

        Dim SqlCB As SqlCommandBuilder = New SqlCommandBuilder(da)
        da.Update(ds, "BondStatus")

        st.Close()
        da.Dispose()
        SqlCB.Dispose()
        cn.Close()

        Return ds
      Catch ex As Exception
        ex.Message().ToString()
      End Try

    End Function