Tuesday, 16 September 2014

Store xml file into sql server table



I have the following XML file



<TEST>
<A>
<B>206942</B>
<nom>TEST</nom>
<prenom>TEST</prenom>
<email>s.TEST@TEST.fr</email>
</A>
<A>
<B>203405</B>
<nom>TEST</nom>
<prenom>TEST</prenom>
<email>g.TESTs@TEST.fr</email>
</A>
</TEST>


I need to store it into sql server .



var Items = doc.Descendants("TEST")
.Select(x=> "TEST" ).ToList();
foreach( var item in Items)
{
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "Insert INTO ITEM * VALUES (@B,@nom,@prenom,@email);";
cmd.Parameters.AddWithValue("@B", );
cmd.Parameters.AddWithValue("@nom", );
cmd.Parameters.AddWithValue("@prenom", );
cmd.Parameters.AddWithValue("@email", );


cmd.ExecuteNonQuery(); } }


Any idea ? thanks


No comments:

Post a Comment