title: how to insert the xml data to sql server using c#?
body: <p>I am beginner to the C#, I need to insert my XML file to SQL table pro-grammatically XML file have five nodes called root, name, subject, sno and queries, I will listed below </p>
  
  <pre><code>&lt;root&gt;
  &lt;name&gt;
  MyName
  &lt;/name&gt;
  &lt;subject&gt;
  newsubject
  &lt;/subject&gt;
  &lt;queries&gt;
  &lt;sno&gt;
  1
  &lt;/sno&gt;
  &lt;query&gt;
  This is the query one
  &lt;/query&gt;
  &lt;/queries&gt;
  &lt;queries&gt;
  &lt;sno&gt;
  2
  &lt;/sno&gt;
  &lt;query&gt;
  This is the query two
  &lt;/query&gt;
  &lt;/queries&gt;
  &lt;queries&gt;
  &lt;sno&gt;
  3
  &lt;/sno&gt;
  &lt;query&gt;
  This is the query three
  &lt;/query&gt;
  &lt;/queries&gt;
  &lt;/root&gt;
  </code></pre>
  
  <p>I need to add this value to sql server table name member_info</p>
  
  <pre><code>my table design is 
  name --&gt; varchar(50)
  subject--&gt;varchar(75)
  sno--&gt;int
  queries--&gt;varchar(150)
  </code></pre>
  
  <p>I tried some basic stuffs for finding the XML file on the specific folder, I don`t have idea how to implement by reading and inserting XML file, Please be gentle I am just beginner.</p>