Sqlconnection conn = new sqlconnection ();
Conn. connectionstring = "Data Source =.; initial catalog = demo; user id = sa; Password = sa ";
Sqlcommand cmd = new sqlcommand ();
Cmd. commandtext = "select * From wz_ksdm ";
Cmd. Connection = conn;
Sqldataadapter da = new sqldataadapter ();
Da. selectcommand = cmd;
Dataset DS = new dataset ();
Da. Fill (DS, "wz_ksdm ");
Dataset ds1 = new dataset ();
Ds1.readxml (application. startuppath. tostring () + "http://www.cnblogs.com/../" + "wzksdm. xml ");
/// Ds. Tables ["wz_da"]. readxml ();
Sqlcommand insertcmd = new sqlcommand ();
// Insertcmd. commandtext = "insert into wz_bz (ID, cyyfl, cyy) values (@ ID, @ cyyfl, @ cyy )";
Insertcmd. commandtext = "insert into wz_ksdm (ksdm, ksmc, srm1, srm2, srm3) values (@ ksdm, @ ksmc, @ srm1, @ srm2, @ srm3 )";
insertcmd. parameters. add ("@ ksdm", sqldbtype. varchar, 10, "ksdm");
insertcmd. parameters. add ("@ ksmc", sqldbtype. varchar, 30, "ksmc");
insertcmd. parameters. add ("@ srm1", sqldbtype. varchar, 6, "srm1");
insertcmd. parameters. add ("@ srm2", sqldbtype. varchar, 6, "srm2");
insertcmd. parameters. add ("@ srm3", sqldbtype. varchar, 6, "srm3");
da. insertcommand = insertcmd;
insertcmd. connection = conn;
MessageBox. show (DA. update (ds1.tables [0]). tostring ();