XML数据导入数据库

一：将批量 XML 数据导入数据库

    conn = new SqlCeConnection (CommonUse .dbConnectString );
    SqlCeDataAdapter da = new SqlCeDataAdapter ();
    SqlCeCommand command = new SqlCeCommand (InsertIntoLiveStockInfo , conn );
    da .InsertCommand = command ;
    command .Parameters .Add ("@I_cardID" , SqlDbType .NVarChar , 40, "cardID" );
    conn .Open ();
    DataSet ds = new DataSet ();
    DataSet xmlds = new DataSet ();
    xmlds .ReadXml (xmlFilePath , XmlReadMode .InferSchema );
    ds = xmlds .Copy ();
    da .Update (ds , "liveStockList" );

二：

    conn = new SqlCeConnection (CommonUse .dbConnectString );
    SqlCeCommand cmd = new SqlCeCommand (QueryLiveStockInfo , conn );
    conn .Open ();
    SqlCeDataAdapter da = new SqlCeDataAdapter ();
    da .SelectCommand = cmd ;
    DataSet ds = new DataSet ();
    ds .ReadXml (xmlFilePath , XmlReadMode .ReadSchema );
    foreach (DataRow dr in ds .Tables [0].Rows )
    {
        if (dr ["cardID" ].ToString () == "" )
            dr .Delete ();
    }

    da .Update (ds , "T_LiveStockInfo" );

三：

    DataSet xmlds = new DataSet ();
    xmlds .ReadXml (xmlFilePath , XmlReadMode .InferSchema );
    int DSCount = xmlds .Tables ["liveStockList" ].Rows .Count ;
    int index = 0;
    foreach (DataRow dr in xmlds .Tables ["liveStockList" ].Rows )
    {
        index ++;
        if (dr ["cardID" ].ToString ().TrimEnd () != "" )
        {
            if (!InsertDataIntoLiveStockInfo (dr ))
            {
                return false ;
            }
        }
    }