将winform客户端的数据上传至webservice服务器,用的ACCESS数据库,请问为何"说明"字段中包含特殊字符就会出

悬赏园豆：30 [已解决问题] 解决于 2012-07-06 15:44

winform客户端:

                       string sqlSer = "insert into user_log(类型,用户名,最新登陆时间,说明) values (\'" + dtyuan.Rows[i]["类型"].ToString() + "\',\'" + dtyuan.Rows[i]["用户名"].ToString() + "\',\'" + dtyuan.Rows[i]["最新登陆时间"].ToString() + "\',\'" + dtyuan.Rows[i]["说明"].ToString() + "\') ";
                        DataSet ds = ts.GetDataset(sqlSer);
                        oledb.Fill(ds);

webservice服务端:

Connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+targetFile+";Persist Security Info=False";
        //string ser_sql = "select * from user_log";
        OleDbConnection MyConn = new OleDbConnection(Connstr);
        
        try
        {
            MyConn.Open();          
           // OleDbDataAdapter MyCommand = new OleDbDataAdapter(ser_sql, MyConn);    
            OleDbCommand Mycmd = new OleDbCommand(SQL, MyConn);            
            Mycmd.ExecuteNonQuery();          
            DataSet ds = new DataSet();                   
           // MyCommand.Fill(ds);
            MyConn.Close();
            return ds;           
        }
        catch (Exception ex)
        {
            throw ex;
        }