c xml导入mysql数据库_将xml中的数据导入到数据库

staticvoidparsedict()

{using(var connection=newSqlConnection(SharedMembers.localConnectString))

{using(var cmd=connection.CreateCommand())

{

cmd.CommandText="SELECT [ck] FROM [dict].[dbo].[simplec]";

connection.Open();

var rdr=cmd.ExecuteReader();while(rdr.Read())

{

var ck=(string)rdr["ck"];

var doc=newXmlDocument();

doc.LoadXml(ck);

var Navigator=doc.CreateNavigator();

var dc=Navigator.SelectSingleNode("/CK/DC").Value;

Navigator.MoveToNext();stringjs=Navigator.SelectSingleNode("/CK/JS").OuterXml;using(var connection2=newSqlConnection(SharedMembers.localConnectString))

{using(var inscmd=connection2.CreateCommand())

{

inscmd.CommandType=CommandType.Text;

inscmd.CommandText="INSERT INTO [dict].[dbo].[jmyh2]([dc],[js])VALUES(@DC,@JS)";

var pdc=inscmd.CreateParameter();

pdc.ParameterName="@DC";

pdc.SqlDbType=SqlDbType.NVarChar;

pdc.Value=dc;

inscmd.Parameters.Add(pdc);

var pjs=inscmd.CreateParameter();

pjs.ParameterName="@JS";

pjs.SqlDbType=SqlDbType.Xml ;

pjs.Value=js;

inscmd.Parameters.Add(pjs);

connection2.Open();

inscmd.ExecuteNonQuery();

Console.WriteLine(dc);

}

}

}

}

}

}