class DataUse
    {
        static string str = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString.ToString();        static OleDbConnection myConnection = new OleDbConnection(str);
        public DataTable Select(string strCommandText)
        {
          try
            { 
                myConnection.Open();
                OleDbDataAdapter myAdpater = new OleDbDataAdapter(strCommandText, myConnection);
                OleDbCommandBuilder myBuilder = new OleDbCommandBuilder(myAdpater);
                DataSet myDataset = new DataSet();
                myAdpater.Fill(myDataset);
                DataTable mytable = myDataset.Tables[0];               
                return mytable;
            }
            catch(Exception ex)
            {
               throw (ex);
            }
            finally
            {
                myConnection.Close();
            }
        }
        public void ExcSQL(string strCommandText)
        {
            try
            {                
                OleDbCommand myCommand = new OleDbCommand(strCommandText, myConnection); 
                myConnection.Open();
                myCommand.ExecuteNonQuery();
            }            catch (Exception ex)
            {
                ex.ToString();
            }
            finally
            {
                myConnection.Close();
            }
        }    }
上面是我写的类,
 du.ExcSQL("update tblDangYuanInfo set XingMing='林亮亮2' where ShenFenZhengHao='370881820916682'");
这句是后台代码,但是执行之后数据库依然不改变。
我表示去掉try catch之后还是不能update,而且int i=myCommand.ExecuteNonQuery();之后,i=1,就不知道是什么情况了,求高手!