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);
}
}
}
}
}
}