Send (Pass) multiple checked ASP.Net GridView row and column values using Session to another page

Hi lingers,

Check this example. Now please take its reference and correct your code.

Database

For this example I have used of Northwind database that you can download using the link given below.

Download Northwind Database

HTML

<asp:GridView ID="gvDetails" runat="server" AutoGenerateColumns="False"
    BackColor="White" BorderColor="#3366CC" BorderStyle="None"
    Font-Names="Century Gothic" Font-Size="x-Small" DataKeyNames="CustomerId"
    Width="100%" Style="margin-bottom: 0px" CssClass="grid">
    <Columns>
        <asp:TemplateField>
            <ItemTemplate>
                <asp:CheckBox ID="chkSelect" runat="server" />
            </ItemTemplate>
        </asp:TemplateField>
        <asp:BoundField DataField="CustomerId" HeaderText="id" />
        <asp:BoundField DataField="ContactName" HeaderText="Name" />
        <asp:BoundField DataField="CompanyName" HeaderText="Company" />
        <asp:BoundField DataField="City" HeaderText="City" />
        <asp:BoundField DataField="Country" HeaderText="Country" />
        <asp:BoundField DataField="Address" HeaderText="Address" />
        <asp:BoundField DataField="PostalCode" HeaderText="Pin" />
        <asp:BoundField DataField="Phone" HeaderText="Phone" />
        <asp:BoundField DataField="Fax" HeaderText="Fax" />
        <asp:TemplateField>
            <ItemTemplate>
                <asp:Button Text="Details" ID="Inkview" runat="server" ForeColor="white" BackColor="#FF6600" />
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField>
            <ItemTemplate>
                <asp:Button Text="Delete" ID="lnkView1" runat="server" ForeColor="white" BackColor="#FF6600" />
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
    <FooterStyle BackColor="White" ForeColor="#000066" />
    <HeaderStyle BackColor="#7EA9D3" Font-Bold="True" ForeColor="White" />
    <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
    <RowStyle ForeColor="#000000" />
    <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="#000000" />
    <SortedAscendingCellStyle BackColor="#F1F1F1" />
    <SortedAscendingHeaderStyle BackColor="#007DBB" />
    <SortedDescendingCellStyle BackColor="#CAC9C9" />
    <SortedDescendingHeaderStyle BackColor="#00547E" />
</asp:GridView>
<asp:ImageButton ImageUrl="" AlternateText="Save" runat="server" OnClick="ImageButton3_Click" />

Namepsaces

using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;

Code

Default

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        BindUserDetails();
    }
}

protected void BindUserDetails()
{
    string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection con = new SqlConnection(constr))
    {
        using (SqlDataAdapter sda = new SqlDataAdapter("Select * from Customers", con))
        {
            using (DataTable dt = new DataTable())
            {
                sda.Fill(dt);
                gvDetails.DataSource = dt;
                gvDetails.DataBind();
            }
        }
    }
}

protected void ImageButton3_Click(object sender, EventArgs e)
{
    List<string> customerId = new List<string>();
    List<string> name = new List<string>();
    List<string> company = new List<string>();
    List<string> country = new List<string>();
    List<string> address = new List<string>();
    foreach (GridViewRow row in gvDetails.Rows)
    {
        CheckBox chkdelete = (CheckBox)row.FindControl("chkSelect");
        if (chkdelete.Checked)
        {
            customerId.Add(row.Cells[1].Text);
            name.Add(row.Cells[2].Text);
            company.Add(row.Cells[5].Text);
            country.Add(row.Cells[6].Text);
            address.Add(row.Cells[8].Text);
        }
    }
    Session["CustomerId"] = customerId;
    Session["Name"] = name;
    Session["Company"] = company;
    Session["Country"] = country;
    Session["Address"] = address;
    Response.Redirect("Details.aspx");
}

Details

protected void Page_Load(object sender, EventArgs e)
{
    List<string> customerId = (List<string>)Session["CustomerId"];
    List<string> name = (List<string>)Session["Name"];
    List<string> company = (List<string>)Session["Company"];
    List<string> country = (List<string>)Session["Country"];
    List<string> address = (List<string>)Session["Address"];
    int added = 0;
    for (int i = 0; i < customerId.Count; i++)
    {
        string insertSQL = "INSERT INTO Test (CustomerId,Name,Company,Country,Address) VALUES (@CustomerId,@Name,@Company,@Country,@Address)";
        String connectionString = "Data Source=NERE\\SQLEXPRESS01; Initial Catalog= kaging;Integrated Security=True";
        SqlConnection con = new SqlConnection(connectionString);
        SqlCommand cmd = new SqlCommand(insertSQL, con);
        cmd.Parameters.AddWithValue("@CustomerId", customerId[i]);
        cmd.Parameters.AddWithValue("@Name", name[i]);
        cmd.Parameters.AddWithValue("@Company", company[i]);
        cmd.Parameters.AddWithValue("@Country", country[i]);
        cmd.Parameters.AddWithValue("@Address", address[i]);
        try
        {
            con.Open();
            added += cmd.ExecuteNonQuery();
        }
        catch (Exception err)
        {
        }
        finally
        {
            con.Close();
        }
    }
}