62,046
社区成员
发帖
与我相关
我的任务
分享
<?xml version="1.0" encoding="utf-8" ?>
<Data>
<A>1</A>
<B>2</B>
</Data>
string xml = string.Empty;
using (StreamReader sr = new StreamReader(Server.MapPath("XMLFile.xml"), System.Text.Encoding.UTF8))
{
sr.ReadLine(); //去掉XML文件第一行
xml = sr.ReadToEnd();
sr.Close();
}
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("INSERT INTO [Table1] ([ID], [Data]) VALUES (@ID, @Data)", conn))
{
cmd.Parameters.Add("ID", SqlDbType.UniqueIdentifier).Value = Guid.NewGuid();
cmd.Parameters.Add("Data", SqlDbType.Xml).Value = xml;
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
}