Retrieve values from XML File
<p>I have Multiple XML Files that look like below</p>

<pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
&lt;schema&gt;
&lt;sp_transaction_id name="sp_transaction_id" value="1" /&gt;
&lt;sp_year name="sp_year" value="2015" /&gt;
&lt;sp_first_name name="sp_first_name" value="James" /&gt;
&lt;sp_gender name="sp_gender" value="Male" /&gt;
&lt;sp_date_of_birth name="sp_date_of_birth" value="06-06-1999" /&gt;
&lt;/schema&gt;
</code></pre>

<p>The XML Format i think is in Key-Value Pairs.
I want to extract these values and store it into a database(SQL Server 2012) table, with the name(eg; sp_year) as Column Name and value(eg; 2015) as the Column value using ASP.NET C#. 
I think i can upload the file and read it like this :</p>

<pre><code>string fileName = Path.GetFileName(FileUpload1.PostedFile.FileName);
string filePath = Server.MapPath("~/Uploads/") + fileName;
FileUpload1.SaveAs(filePath);
string xml = File.ReadAllText(filePath);
</code></pre>

<p>But thats pretty much it  ( Sorry Im a beginner ). Please Guide me. Thanks</p>