How To Import XML File Data Into SQL Table Using Stored Procedure In ASP.NET

I have an XML file (student), which stores the information of the student and want to import its data into SQL table.

Student.xml file looks, as shown below.

Implementation

I have created a Student table.

HTML structure of the page looks, as shown below.

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<fieldset style="width:25%">
<legend></legend>
<table>
<tr>
<td>Upload file :</td>
<td>
<asp:FileUpload ID="FileUpload1" runat="server" />
</td>
</tr>
<tr>
<td></td>
<td>
<asp:Button ID="btnupload" runat="server" Text="Upload" OnClick="btnupload_Click" />
</td>
</tr>
</table>
</fieldset>
</div>
</form>
</body>
</html>

Import the namespace

C# code

Import XML file

On button click, write the code given below.

C# code

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ToString());
protected void btnupload_Click(object sender, EventArgs e) {
try {
string fileName, filepath, contentXml;
fileName = Path.GetFileName(FileUpload1.PostedFile.FileName);
filepath = Server.MapPath("~/upload/") + fileName;
FileUpload1.SaveAs(filepath);
string xmlfile = File.ReadAllText(filepath);
SqlCommand cmd = new SqlCommand("InsertXMLData", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@xmlfile", xmlfile);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
Response.Write("<script type=\"text/javascript\">alert('file uploaded successfully');</script>");
} catch (Exception ex) {}
}