string strQuery5 = "insert into gelenhaberaciklama(HaberKodu,Aciklama) values (@HaberKodu5,@Aciklama5)";
SqlConnection con5 = new SqlConnection(strConnString5);
con5.Open();
XmlDocument ReadInDocument5 = new XmlDocument();
ReadInDocument5.Load("XML FILE");
String HaberKodu5 = "";
String Aciklama = "";
foreach (XmlNode node5 in ReadInDocument5.SelectNodes(".//Aciklamalar/Aciklamala"))
{
HaberKodu5 = node5.Attributes["HaberKodu"].InnerText;
Aciklama5 = node5.ChildNodes[0].InnerText;
SqlCommand cmd5 = new SqlCommand(strQuery5);
cmd5.CommandType = CommandType.Text;
cmd5.Connection = con5;
cmd5.Parameters.AddWithValue("@HaberKodu5", HaberKodu5.ToString());
cmd5.Parameters.AddWithValue("@Aciklama5", Aciklama5.ToString());
cmd5.ExecuteNonQuery();
}
con5.C ...
Go to the complete details ...