Insert selected records to the database using Gridview

In this blog we will know how to display xml file records in a gridview. We can also insert selected records to the database by selecting the checkbox.

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>Untitled Page</title>

</head>

<body>

<div>

<asp:GridView ID="GridView1" runat="server" Width="96%" >

<asp:TemplateField HeaderText="Select">

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

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Remark">

<asp:Label ID="lblremark" runat="server"></asp:Label>

</ItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

</div>

<asp:Button ID="btnview" runat="server" onclick="btnview_Click"

Text="Show Records " />

<asp:FileUpload ID="FileUpload1" runat="server" />

<asp:Button ID="btninsert" runat="server" onclick="btninsert_Click"

Text="Insert Records" /><br />

<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>

</form>

</body>

</html>

using System;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page

{

string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

string filename;

string str;

protected void Page_Load(object sender, EventArgs e)

{

}

protected void btnview_Click(object sender, EventArgs e)

{

SqlConnection con = new SqlConnection(connStr);

con.Open();

GridView1.Visible = true;

DataSet reportData = new DataSet();

filename = System.IO.Path.GetExtension(FileUpload1.FileName.ToString());

if (filename == ".xml")

{

reportData.ReadXml(Server.MapPath(FileUpload1.FileName));

GridView1.DataSource = reportData;

GridView1.DataBind();

con.Close();

}

else

{

GridView1.Visible = false;

Response.Write("Invalid File");

}

con.Close();

}

protected void btninsert_Click(object sender, EventArgs e)

{

SqlConnection con = new SqlConnection(connStr);

for (int i = 0; i < GridView1.Rows.Count; i++)

{

GridViewRow row = GridView1.Rows[i];

CheckBox chkbox = (CheckBox)row.FindControl("chkbox");

if (chkbox.Checked == true)

{

con.Open();

str = "insert into employee (empid,empname,empaddress,empcity,empstate,empzip,emplic,empstatus,empp,empi) values('" + row.Cells[2].Text + "','" + row.Cells[3].Text + "','" + row.Cells[4].Text + "','" + row.Cells[5].Text + "','" + row.Cells[6].Text + "','" + row.Cells[7].Text + "','" + row.Cells[8].Text + "','" + row.Cells[9].Text + "','" + row.Cells[10].Text + "','" + row.Cells[11].Text + "')";

SqlCommand com=new SqlCommand(str,con);

com.ExecuteNonQuery();

con.Close();

}

Label1.Text = "Records inserted";

}