Exemple #1
0
        /// <summary>
        /// 从数据库里删除表tableName内所有数据
        /// </summary>
        /// <param name="tableName">表名</param>
        private void DeleteData(string tableName)
        {
            SQLTool mysql = new SQLTool();

            try
            {
                mysql.open(CONNECTION);
                mysql.delete(SQLCmdStr.deleteTable(tableName));
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                return;
            }
            finally
            {
                mysql.close();
            }
            MessageBox.Show(tableName + " 删除成功");
        }