Insert dynamically created rows into Database using C# and VB.Net in ASP.Net

Hi simflex,

You need to add Button outside gridview in your code. So please refer the below code and modify as per your requirement.

HTML

<asp:Button ID="btnIncone" Text="Save Income" CssClass="btnSuccess" OnClick="OnSaveIncome"
    runat="server" />
<asp:Button ID="btnSpouse" Text="Save Spouse" CssClass="btnSuccess"  OnClick="OnSaveSpouse"
    runat="server" />

C#

protected void OnSaveIncome(object sender, EventArgs e)
{
    SqlConnection con = new SqlConnection(contring);
    foreach (GridViewRow row in gvIncome.Rows)
    {
        string Message = (row.FindControl("txtspouseincome") as TextBox).Text.Trim();
        SqlCommand cmd = new SqlCommand("INSERT INTO TableName VALUES(@Message)", con);
        cmd.Parameters.AddWithValue("@Message", Message);
        con.Open();
        cmd.ExecuteNonQuery();
        con.Close();
    }

    this.SetInitialRow();
}

protected void OnSaveSpouse(object sender, EventArgs e)
{
    SqlConnection con = new SqlConnection(contring);
    foreach (GridViewRow row in gvIncome.Rows)
    {
        string Message = (row.FindControl("txtspouseincome1") as TextBox).Text.Trim();
        SqlCommand cmd = new SqlCommand("INSERT INTO TableName VALUES(@Message)", con);
        cmd.Parameters.AddWithValue("@Message", Message);
        con.Open();
        cmd.ExecuteNonQuery();
        con.Close();
    }

    this.SetInitialRow();
}

Vb.Net

Protected Sub OnSaveIncome(sender As Object, e As EventArgs)
	Dim con As New SqlConnection(contring)
	For Each row As GridViewRow In gvIncome.Rows
		Dim Message As String = TryCast(row.FindControl("txtspouseincome"), TextBox).Text.Trim()
		Dim cmd As New SqlCommand("INSERT INTO TableName VALUES(@Message)", con)
		cmd.Parameters.AddWithValue("@Message", Message)
		con.Open()
		cmd.ExecuteNonQuery()
		con.Close()
	Next

	Me.SetInitialRow()
End Sub

Protected Sub OnSaveSpouse(sender As Object, e As EventArgs)
	Dim con As New SqlConnection(contring)
	For Each row As GridViewRow In gvIncome.Rows
		Dim Message As String = TryCast(row.FindControl("txtspouseincome1"), TextBox).Text.Trim()
		Dim cmd As New SqlCommand("INSERT INTO TableName VALUES(@Message)", con)
		cmd.Parameters.AddWithValue("@Message", Message)
		con.Open()
		cmd.ExecuteNonQuery()
		con.Close()
	Next

	Me.SetInitialRow()
End Sub