Bulk Insert data in database

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false">

<Columns>

    <asp:TemplateField>

        <ItemTemplate>

            <asp:CheckBox ID="CheckBox1" runat="server" />

        </ItemTemplate>

    </asp:TemplateField>

    <asp:BoundField DataField="Id" HeaderText="Id" ItemStyle-Width="30" />

    <asp:BoundField DataField="Name" HeaderText="Name" ItemStyle-Width="150" />

    <asp:BoundField DataField="Country" HeaderText="Country" ItemStyle-Width="150" />

</Columns>

</asp:GridView>

<br />

<asp:Button ID="Button1" Text="Bulk Insert" Click="Bulk_Insert" runat="server" />

<?xmlversion="1.0"standalone="yes"?>

<Customers>

 <Customer>

    <Id>1</Id>

    <Name>John Hammond</Name>

    <Country>United States</Country>

 </Customer>

 <Customer>

    <Id>2</Id>

    <Name>Mudassar Khan</Name>

    <Country>India</Country>

 </Customer>

 <Customer>

    <Id>3</Id>

    <Name>Suzanne Mathews</Name>

    <Country>France</Country>

 </Customer>

 <Customer>

    <Id>4</Id>

    <Name>Robert Schidner</Name>

    <Country>Russia</Country>

 </Customer>

</Customers>

protected void Page_Load(object sender, EventArgs e)

{

    if (!this.IsPostBack)

    {

        DataSet ds = new DataSet();

        ds.ReadXml(Server.MapPath("~/Customers.xml"));

        GridView1.DataSource = ds.Tables[0];

        GridView1.DataBind();

    }

}

protected void Bulk_Insert(object sender, EventArgs e)

{

    DataTable dt = new DataTable();

    dt.Columns.AddRange(new DataColumn[3] { new DataColumn("Id", typeof(int)),

                        new DataColumn("Name", typeof(string)),

                        new DataColumn("Country",typeof(string)) });

    foreach (GridViewRow row in GridView1.Rows)

    {

        if ((row.FindControl("CheckBox1") as CheckBox).Checked)

        {

            int id = int.Parse(row.Cells[1].Text);

            string name = row.Cells[2].Text;

            string country = row.Cells[3].Text;

            dt.Rows.Add(id, name, country);

        }

    }

    if (dt.Rows.Count > 0)

    {

        string consString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;

        using (SqlConnection con = new SqlConnection(consString))

        {

            using (SqlBulkCopy sqlBulkCopy = new SqlBulkCopy(con))

            {

                //Set the database table name

                sqlBulkCopy.DestinationTableName = "dbo.Customers";

                //[OPTIONAL]: Map the DataTable columns with that of the database table

                sqlBulkCopy.ColumnMappings.Add("Id", "CustomerId");

                sqlBulkCopy.ColumnMappings.Add("Name", "Name");

                sqlBulkCopy.ColumnMappings.Add("Country", "Country");

                con.Open();

                sqlBulkCopy.WriteToServer(dt);

                con.Close();

            }

        }

    }

}