C#+Access 员工信息管理--简单的增删改查操作和.ini配置文件的读写操作。

1.本程序的使用的语言是C#，数据库是Access2003。主要是对员工信息进行简单的增删改查操作和对.ini配置文件的读写操作。
2.代码运行效果如下：


功能比较简单。其中在得到查询结果后，在查询结果界面上最上面的一行数字好像是根据数据库的列数自动获取到的，我本想把它删掉来着，但是没成功。
3.代码实现

点击查看代码。clsDbOperate类--主要是数据库连接和员工的增删改查操作。

 System;
 System.Collections.Generic;
 System.Data;
 System.Data.OleDb;
 System.Linq;
 System.Text;
 System.Threading.Tasks;
 System.Windows.Forms;

 
{
       {
          exePath = System.Environment.CurrentDirectory + ;
          Psd = ;

        OleDbConnection conn =  OleDbConnection( + exePath +  +  + Psd);
        OleDbCommand oleCommand =  OleDbCommand();

         OleDbDataReader ole_reader = ;
         DataTable dt = ;

         {
            DataTable dt =  DataTable(); 
             {
                conn.Open();
                OleDbDataAdapter da =  OleDbDataAdapter(sql, conn); 
                da.Fill(dt); 
                conn.Close();
            }  (Exception) {
            }  {
                conn.Close();
            }
             dt;
        }
         {
            DataSet ds =  DataSet(); 
             n = ;
             {
                conn.Open();
                OleDbDataAdapter da =  OleDbDataAdapter(sql, conn); 

                da.Fill(ds); 
                n = ds.Tables[].Rows.Count;
            }  (Exception) {
            }  {
                conn.Close();
            }
             n;
        }
         {
             n = ;
             {
                conn.Open();
                
                
                
                
                
                
                OleDbCommand comm =  OleDbCommand(sql, conn);
                n = comm.ExecuteNonQuery();
            }  (Exception ex) {
                MessageBox.Show(ex.Message);
            }  {
                conn.Close();
            }
            conn.Close();
             n;
        }
        
        
        
        
        
         {
             (exePath == ) {
                 ;
            }
             {
                conn.Open();
                 (conn.State == ConnectionState.Closed) {
                     ;
                }
                oleCommand.CommandText = strSql;
                oleCommand.Connection = conn;
                ole_reader = oleCommand.ExecuteReader(CommandBehavior.Default);
                dt = ConvertOleDbReaderToDataTable( ole_reader);
                ole_reader.Close();
                ole_reader.Dispose();
            }  (System.Exception e) {
                
                MessageBox.Show(e.Message);
            }  {
                 (conn.State != ConnectionState.Closed) {
                    conn.Close();
                }
            }
             dt;
        }
        
        
        
        
        
         {
            DataTable dtTab = ;
            DataRow dr = ;
             dataColumnCount = ;
             i = ;
            dataColumnCount = reader.FieldCount;
            dtTab = BuildAndInitDataTable(dataColumnCount);
            dtTab.Rows.Add(, , , , , );
             (dtTab == ) {
                 ;
            }
             (reader.Read()) {             
                dr = dtTab.NewRow();
                             
                 (i = ; i < dataColumnCount; ++i) {
                    dr[i] = reader[i];
                }
                dtTab.Rows.Add(dr);
            }
             dtTab;
        }
        
        
        
        
        
         {
            DataTable dtTab = ;
            DataColumn dc = ;
             i = ;
             (fieldCount <= ) {
                 ;
            }
            dtTab =  DataTable();
             (i = ; i < fieldCount; ++i) {
                dc =  DataColumn(i.ToString());
                dtTab.Columns.Add(dc);
            }
             dtTab;
        }
    }
}

点击查看代码。FileOperation类--.ini配置文件的操作类。主要是对FileConfig.ini文件进行读写操作

 System;
 System.Collections.Generic;
 System.Text;
 System.Runtime.InteropServices;
 System.Windows.Forms;
 System.IO;
 System.Drawing;
 System.Drawing.Drawing2D;
 System.Drawing.Imaging;

 
{
       {
        
        
        
        
        
        
        
        
        []
        ;
        
        
        
        
        
        
        
        
        
        
        []
        ;
          strSec = ; 

         {
             returnName = ;
             (File.Exists(strFilePath))
            {
                
                strSec = ;
                returnName = ContentValue(strFilePath, strSec, FieldName);
            }  {
                
            }
             returnName;
        }

         {
             ret = ;
             {
                
                
                
                strSec = ;
                WritePrivateProfileString(strSec, FieldName, FieldValue.Trim(), strFilePath);
                ret = ;
                
            }  (Exception) {
            }
             ret;
        }

        
        {
            StringBuilder temp =  StringBuilder();
            GetPrivateProfileString(Section, key, , temp, , strFilePath);
            
             temp.ToString();
        }
    }
}

点击查看代码。FrmUserManager类--界面类。主要是对用户的信息进行操作

 System;
 System.Collections.Generic;
 System.ComponentModel;
 System.Data;
 System.Drawing;
 System.Linq;
 System.Text;
 System.Windows.Forms;
 UserInfoManage;
 UserInfoManage.;
 System.Runtime.InteropServices;

  {
        :  {
         clsDbOperate dbOperate;
         FileOperation fileOperation;
          strUserId;
          strUserName;
          strPassword;
          strFilePath = Application.StartupPath + ;

         {
            InitializeComponent();
        }
         {
            dbOperate =  clsDbOperate();
            RefreshUserInfo();
            dgvUserInfo.AllowUserToAddRows = ;
            dgvUserInfo.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
            dgvUserInfo.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.Fill;
            dgvUserInfo.BackgroundColor = Color.White;
            dgvUserInfo.ReadOnly = ;
            dgvUserInfo.Columns[].HeaderText = ;            
            dgvUserInfo.Columns[].HeaderText = ;
            dgvUserInfo.Columns[].HeaderText = ;
            dgvUserInfo.Columns[].HeaderText = ;
            dgvUserInfo.Columns[].HeaderText = ;
            dgvUserInfo.Columns[].HeaderText = ;

            fileOperation =  FileOperation();
        }       
        
        
        
         {
             (txtUserID.Text ==  || txtUserName.Text ==  || txtUserPsd.Text == ) {
                MessageBox.Show(, , MessageBoxButtons.OK);
            }  {
                 sql = .Empty;
                 strIsAdmin = .Empty;
                strIsAdmin = chkIsAdmin.Checked ==  ?  : ;
                 {
                    sql =  + txtUserID.Text + ;
                     (dbOperate.intSelectResultCount(sql) > ) {
                        MessageBox.Show(, , MessageBoxButtons.OK);
                        ;
                    }  {
                        sql = ;
                        sql +=  + txtUserID.Text +  + txtUserName.Text +  + txtUserPsd.Text +  + strIsAdmin + ;
                         (dbOperate.Del_Ins_Upd_Result(sql) > ) {
                            RefreshUserInfo();
                            MessageBox.Show(, , MessageBoxButtons.OK);
                            ClearUserInfo();
                        } 
                            MessageBox.Show(, , MessageBoxButtons.OK);
                    }
                }  (Exception) {
                    MessageBox.Show(, , MessageBoxButtons.OK);
                }
            }
        }
        
        
        
         {
             (txtUserID.Text ==  || txtUserName.Text ==  || txtUserPsd.Text == ) {
                MessageBox.Show(, , MessageBoxButtons.OK);
            }  {
                 sql = .Empty;
                 strIsAdmin = .Empty;
                 {
                    strIsAdmin = chkIsAdmin.Checked ==  ?  : ;
                    sql =  + txtUserID.Text +  + txtUserName.Text +  + txtUserPsd.Text +  + strIsAdmin + ;
                    sql +=  + txtUserID.Text + ;
                     (dbOperate.Del_Ins_Upd_Result(sql) > ) {
                        RefreshUserInfo();
                        MessageBox.Show(, , MessageBoxButtons.OK);
                        ClearUserInfo();
                    } 
                        MessageBox.Show(, , MessageBoxButtons.OK);
                }  (Exception) {
                    MessageBox.Show(, , MessageBoxButtons.OK);
                }
            }
        }
        
        
        
         {
             (txtUserID.Text ==  || txtUserName.Text == ) {
                MessageBox.Show(, , MessageBoxButtons.OK);
            }  {
                 (MessageBox.Show( +  + txtUserID.Text +  +  + txtUserName.Text, , MessageBoxButtons.YesNo) == DialogResult.Yes) {
                     {
                         sql =  + txtUserID.Text +  + txtUserName.Text + ;
                         (dbOperate.intSelectResultCount(sql) > ) {
                            sql =  + txtUserID.Text +  + txtUserName.Text + ;
                            dbOperate.Del_Ins_Upd_Result(sql);
                            RefreshUserInfo();
                            MessageBox.Show(, , MessageBoxButtons.OK);
                            ClearUserInfo();
                        } 
                            MessageBox.Show(, , MessageBoxButtons.OK);
                    }  (Exception) {
                        MessageBox.Show(, , MessageBoxButtons.OK);
                    }
                }
            }
        }
         {
             (!(.IsNumber(e.KeyChar)) && e.KeyChar != ()) {
                e.Handled = ;
            }
        }
        
        
        
         {
             sql = ;
            DataTable dt = dbOperate.dtSelectResult(sql);
            dgvUserInfo.DataSource = dt;
        }
        
        
        
         {
            txtUserID.Text = ;
            txtUserName.Text = ;
            txtUserPsd.Text = ;
            chkIsAdmin.Checked = ;
        }

         {
             (e.ColumnIndex == ) {
                 (e.Value !=  && e.Value.ToString().Length > ) {
                    e.Value =  (, e.Value.ToString().Length);
                }
            }
             (e.ColumnIndex == ) {
                 (e.Value.Equals()) {
                    e.Value = ;
                } 
                    e.Value = ;
            }
        }

         {
             {
                txtUserID.Text = dgvUserInfo.Rows[e.RowIndex].Cells[].Value.ToString();
                txtUserName.Text = dgvUserInfo.Rows[e.RowIndex].Cells[].Value.ToString();
                txtUserPsd.Text = dgvUserInfo.Rows[e.RowIndex].Cells[].Value.ToString();
                chkIsAdmin.Checked = dgvUserInfo.Rows[e.RowIndex].Cells[].Value.ToString() ==  ?  : ;
            }  (Exception) {

            }
        }

         DataTable dt;
         {
            (cboSelectItems.SelectedIndex == ) {
                 (txtSelectContent.Text == ) {
                    MessageBox.Show();
                    ;
                }  {
                    
                     sql =  + txtSelectContent.Text + ;
                     (dbOperate.intSelectResultCount(sql) > ) {
                        dt =  DataTable();
                        dt = dbOperate.GetDataTableFromDB(sql);
                        
                        SelectInfo selectInfo =  SelectInfo(dt);
                        
                        selectInfo.Show();                     
                    }  {
                        MessageBox.Show(, , MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    }
                }
            }  {
                 (txtSelectContent.Text == ) {
                    MessageBox.Show();
                    ;
                }  {
                     sql =  + txtSelectContent.Text + ;
                     (dbOperate.intSelectResultCount(sql) > ) {
                        dt =  DataTable();
                        dt = dbOperate.GetDataTableFromDB(sql);
                        SelectInfo selectInfo =  SelectInfo(dt);
                        
                        selectInfo.Show();
                    }  {
                        MessageBox.Show(, , MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    }
                }
            }
            
        }

        
        
        
         {
             ((txtUserID.Text.Trim() != ) && (txtUserName.Text.Trim() != ) && txtUserPsd.Text.Trim() != ) {
                 ret;
                ret = fileOperation.WriteFile(strFilePath, , txtUserID.Text);
                ret = fileOperation.WriteFile(strFilePath, , txtUserName.Text);
                ret = fileOperation.WriteFile(strFilePath, , txtUserPsd.Text);
                 (ret == ) {
                    MessageBox.Show(, , MessageBoxButtons.OK);
                }  {
                    MessageBox.Show(, , MessageBoxButtons.OK);
                }
            }  {
                MessageBox.Show(, , MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
        }
        
        
        
         {
            strUserId = fileOperation.ReadFile(strFilePath, );
            strUserName = fileOperation.ReadFile(strFilePath, );
            strPassword = fileOperation.ReadFile(strFilePath, );

            txtUserID.Text = strUserId;
            txtUserName.Text = strUserName;
            txtUserPsd.Text = strPassword;
        }
    }
}

点击查看代码。SelectInfo类--查询结果的界面。主要用来显示查询到的用户信息。这里根据个人需要，如果不需要重新新建一个几面来显示查询到的信息，则可以把界面里面的DataGridView放到FrmUserManager类中。

 System;
 System.Collections.Generic;
 System.ComponentModel;
 System.Data;
 System.Drawing;
 System.Linq;
 System.Text;
 System.Threading.Tasks;
 System.Windows.Forms;

  {
        :  {
         DataTable dt;
         {
            InitializeComponent();
            .dt = dt;
        }

         {
            dgvSelectInfo.DataSource = dt;
        }

         {
             (e.ColumnIndex ==  && e.RowIndex != ) {
                 (e.Value !=  && e.Value.ToString().Length > ) {
                    e.Value =  (, e.Value.ToString().Length);
                }
            }
             (e.ColumnIndex == ) {
                 (e.Value.Equals()) {
                    e.Value = ;
                }  {
                    e.Value = ;
                }
            }
        }
    }
}