一.设置窗口

1.主要包含设置服务器、用户、密码等
image.png
这个是子窗体
即设置服务器连接数据库
构造函数里写(Form form1)
子窗体功能;
1.读取ini文件的数据库设置
2.用户根据自己的需求改变设置
3.保存设置进ini文件
4.改变主窗体的SqlConnection—-此处详见
语雀内容

二、完整的子窗体代码

  1.  public partial class SqlConnector : DevExpress.XtraEditors.XtraForm
  2.     {
  3.         private string filepath = "";
  4.         public SqlConnector()
  5.         {
  6.             InitializeComponent();
  7.             filepath = Form1.GetDirectoryInfo(3) + "Log\\SqlConfig.ini";
  8.             this.txt_Server.Text = INIHelper.Read("SqlConnector", "server", "127.0.0.1", filepath);
  9.             this.txt_UseID.Text = INIHelper.Read("SqlConnector", "userID", "root", filepath);
  10.             this.txt_Port.Text = INIHelper.Read("SqlConnector", "port", "3306", filepath);
  11.         }
  13.         public SqlConnector(Form1 form1)
  14.         {
  15.             InitializeComponent();
  16.             filepath = Form1.GetDirectoryInfo(3) + "Log\\SqlConfig.ini";
  17.             this.txt_Server.Text = INIHelper.Read("SqlConnector", "server", "127.0.0.1", filepath);
  18.             this.txt_UseID.Text = INIHelper.Read("SqlConnector", "userID", "root", filepath);
  19.             this.txt_Port.Text = INIHelper.Read("SqlConnector", "port", "3306", filepath);
  20.             this.txt_Password.Text = INIHelper.Read("SqlConnector", "password", "mypassword", filepath);
  22.         }
  24.         //定义委托、事件
  25.         public delegate void ChangeSqlConnection(string connStr);
  26.         public event ChangeSqlConnection changeSqlConn;
  27.         /// <summary>
  28.         /// 关闭窗体时重写ini文件且设置父窗体的SqlConnector
  29.         /// </summary>
  30.         /// <param name="sender"></param>
  31.         /// <param name="e"></param>
  32.         private void SqlConnector_FormClosed(object sender, FormClosedEventArgs e)
  33.         {
  34.             if (!string.IsNullOrEmpty(filepath))
  35.             {
  36.                 INIHelper.Write("SqlConnector", "server", txt_Server.Text.ToString(), filepath);
  37.                 INIHelper.Write("SqlConnector", "userID", txt_UseID.Text.ToString(), filepath);
  38.                 INIHelper.Write("SqlConnector", "port", txt_Port.Text.ToString(), filepath);
  39.                 INIHelper.Write("SqlConnector", "password", txt_Password.Text.ToString(), filepath);
  40.                 string connStr = String.Format("server={0};user id={1}; password={2}; port={3}; database=mysql; pooling=false; charset=utf8", txt_Server.Text.ToString().Trim(), txt_UseID.Text.ToString().Trim(), txt_Password.Text.ToString(),txt_Port.Text.ToString().Trim());
  41.                 changeSqlConn(connStr);
  42.             }
  43.         }
  44.     }

三、INIHelper—-用来改写ini中某个节点下的key对应的value值

INI文件构造
[section]
key=value

  1.  class INIHelper
  2.     {
  4.         /// <summary>
  5.         /// 为INI文件中指定的节点取得字符串
  6.         /// </summary>
  7.         /// <param name="lpAppName">欲在其中查找关键字的节点名称</param>
  8.         /// <param name="lpKeyName">欲获取的项名</param>
  9.         /// <param name="lpDefault">指定的项没有找到时返回的默认值</param>
  10.         /// <param name="lpReturnedString">指定一个字串缓冲区，长度至少为nSize</param>
  11.         /// <param name="nSize">指定装载到lpReturnedString缓冲区的最大字符数量</param>
  12.         /// <param name="lpFileName">INI文件完整路径</param>
  13.         /// <returns>复制到lpReturnedString缓冲区的字节数量，其中不包括那些NULL中止字符</returns>
  14.         [DllImport("kernel32")]
  15.         private static extern int GetPrivateProfileString(string lpAppName, string lpKeyName, string lpDefault, StringBuilder lpReturnedString, int nSize, string lpFileName);
  17.         /// <summary>
  18.         /// 修改INI文件中内容
  19.         /// </summary>
  20.         /// <param name="lpApplicationName">欲在其中写入的节点名称</param>
  21.         /// <param name="lpKeyName">欲设置的项名</param>
  22.         /// <param name="lpString">要写入的新字符串</param>
  23.         /// <param name="lpFileName">INI文件完整路径</param>
  24.         /// <returns>非零表示成功，零表示失败</returns>
  25.         [DllImport("kernel32")]
  26.         private static extern int WritePrivateProfileString(string lpApplicationName, string lpKeyName, string lpString, string lpFileName);
  28.         /// <summary>
  29.         /// 读取INI文件值
  30.         /// </summary>
  31.         /// <param name="section">节点名</param>
  32.         /// <param name="key">键</param>
  33.         /// <param name="def">未取到值时返回的默认值</param>
  34.         /// <param name="filePath">INI文件完整路径</param>
  35.         /// <returns>读取的值</returns>
  36.         public static string Read(string section, string key, string def, string filePath)
  37.         {
  38.             StringBuilder sb = new StringBuilder(1024);
  39.             GetPrivateProfileString(section, key, def, sb, 1024, filePath);
  40.             return sb.ToString();
  41.         }
  43.         /// <summary>
  44.         /// 写INI文件值
  45.         /// </summary>
  46.         /// <param name="section">欲在其中写入的节点名称</param>
  47.         /// <param name="key">欲设置的项名</param>
  48.         /// <param name="value">要写入的新字符串</param>
  49.         /// <param name="filePath">INI文件完整路径</param>
  50.         /// <returns>非零表示成功，零表示失败</returns>
  51.         public static int Write(string section, string key, string value, string filePath)
  52.         {
  53.             //CheckPath(filePath);
  54.             return WritePrivateProfileString(section, key, value, filePath);
  55.         }
  57.         /// <summary>
  58.         /// 删除节
  59.         /// </summary>
  60.         /// <param name="section">节点名</param>
  61.         /// <param name="filePath">INI文件完整路径</param>
  62.         /// <returns>非零表示成功，零表示失败</returns>
  63.         public static int DeleteSection(string section, string filePath)
  64.         {
  65.             return Write(section, null, null, filePath);
  66.         }
  68.         /// <summary>
  69.         /// 删除键的值
  70.         /// </summary>
  71.         /// <param name="section">节点名</param>
  72.         /// <param name="key">键名</param>
  73.         /// <param name="filePath">INI文件完整路径</param>
  74.         /// <returns>非零表示成功，零表示失败</returns>
  75.         public static int DeleteKey(string section, string key, string filePath)
  76.         {
  77.             return Write(section, key, null, filePath);
  78.         }
  79.         /// <summary>
  80.         /// 检查文件是否存在
  81.         /// </summary>
  82.         /// <param name="filePath"></param>
  83.         /// <returns></returns>
  84.         private static void CheckPath(string filePath)
  85.         {
  86.             if (string.IsNullOrWhiteSpace(filePath) || !File.Exists(filePath))
  87.             {
  88.                 throw new ArgumentNullException("filePath");
  89.             }
  90.         }
  91.     }

四、主窗体中数据库代码

  1.  #region 数据库操作
  3.         public MySqlConnection conn;
  4.         private DataTable data;
  5.         private MySqlDataAdapter da;
  6.         private MySqlCommandBuilder cb;
  7.         private DataGrid dataGrid;
  9.         private void barButtonItem3_ItemClick(object sender, ItemClickEventArgs e)
  10.         {
  11.             SqlConnector sql = new SqlConnector(this);
  12.             sql.changeSqlConn += new SqlConnector.ChangeSqlConnection(SetSqlConnection);
  13.             sql.Show(this);
  14.         }
  17.         /// <summary>
  18.         /// 根据INI文件中的设置改变数据库的连接
  19.         /// </summary>
  20.         private void SetSqlConnection(string connStr)
  21.         {
  22.             if(conn!=null)
  23.             {
  24.                 conn.Close();
  25.             }
  26.             try
  27.             {
  28.                 conn = new MySqlConnection(connStr);
  29.                 conn.Open();
  30.                 XtraMessageBox.Show("连接数据库成功！");
  31.             }
  32.             catch(Exception ex)
  33.             {
  34.                 XtraMessageBox.Show("Error connecting to the server:" + ex.Message);
  35.             }
  36.         }
  38.         #endregion