Exemple #1
0
        /// <summary>
        /// 保存表修改到数据库
        /// </summary>
        /// <returns>保存的行数</returns>
        public int SaveTable()
        {
            int nRet = 0;

            if (mTableChanged || true)
            {
                try
                {
                    mAdapter = new SqlDataAdapter(mSqlCmd, mConn);
                    SqlCommandBuilder cmd = new SqlCommandBuilder(mAdapter);
                    mAdapter.UpdateCommand = cmd.GetUpdateCommand();
                    DataTable tbl = mTable.GetChanges();
                    if (tbl != null && tbl.Rows.Count > 0)
                    {
                        nRet = mAdapter.Update(tbl);
                    }
                    mTable.AcceptChanges();
                    mTableChanged = false;
                }
                catch (Exception ex)
                {
                    throw ex;
                }
            }
            return(nRet);
        }