C#迁移之callXBFLibrary - ADO.net

        我们经常需要与ADO.net的连接串打交道。根据键/值来设置连接数据库。

        在我们使用数据库中，在平常C/S架构中使用最多是MySQL！针对ADO.net连接串，MySQL有一些固定的键/值供我们选择，详细请参见附录。

        在标准连接中，我们只需要：

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

        比如增加禁止连接池：

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
Pooling=False;

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
ConvertZeroDateTime=True;

      Form1.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.IO;
using xbfLibsLib;

namespace callXBFLibrary
{
    public partial class frmCall_XBF : Form
    {
        private Cwin32API ini;
        private string strConn;
        private string currDir;

        public frmCall_XBF()
        {
            InitializeComponent();

            currDir = Directory.GetCurrentDirectory();

            ini = new Cwin32API(currDir + "/xbfConfig.ini");
        }

        private void btnWriteXBF_Click(object sender, EventArgs e)
        {
            Boolean flagSQL = false;
            Boolean flagMSSQL = false;
            Boolean flagSecu = false;
            string sectionName = ini.readIniFileVal("config", "type");
            string strSrv = ini.readIniFileVal(sectionName, "Server");
            if (!Equals(strSrv, ""))
                flagSQL = true;
            if (flagSQL)
            {
                if (Equals(sectionName, "MSSQL"))
                    flagMSSQL = true;

                if (flagMSSQL)
                    strConn =
                        "dbType=0;"
                        + "Password=" + ini.readIniFileVal(sectionName, "Pwd") + ";"
                        + "Persist Security Info=True;"
                        + "User ID=" + ini.readIniFileVal(sectionName, "User") + ";"
                        + "Initial Catalog=" + ini.readIniFileVal(sectionName, "DB") + ";"
                        + "Data Source=" + ini.readIniFileVal(sectionName, "Server");
                else
                    strConn = "dbType=2;" 
                        + "Data Source=" + ini.readIniFileVal(sectionName, "Server") + ";"
                        + "User Id=" + ini.readIniFileVal(sectionName, "User") + ";"
                        + "Password=" + ini.readIniFileVal(sectionName, "Pwd") + ";"
                        + "Database=" + ini.readIniFileVal(sectionName, "DB") + ";"
                        + "Convert Zero Datetime=True";

            }
            else // MS Access
            {
                string strPWD = ini.readIniFileVal(sectionName, "Pwd");
                if (!Equals(strPWD, ""))
                    flagSecu = true;
                if (flagSecu)
                {
                    strConn =
                        "dbType=1;"
                        + "Data Source=" + ini.readIniFileVal(sectionName, "DB") + ";"
                        + "Persist Security Info=False;"
                        + "Jet OLEDB:Database Password=" + ini.readIniFileVal(sectionName, "Pwd");
                }
                else
                {
                    strConn =
                         "dbType=1;"
                        + "Data Source=" + ini.readIniFileVal(sectionName, "DB") + ";"
                        + "Persist Security Info=True";
                }
            }

            MessageBox.Show(strConn);

            xbfLibsLib.genXBFileClass xbf = new genXBFileClass();
            xbf.WriteXBFile(strConn);
        }

        private void btnReadXBF_Click(object sender, EventArgs e)
        {
            genXBFileClass xbf = new genXBFileClass();

            string filePath = currDir + "/" + edtFileName.Text;
            string strRet = xbf.ReadXBFile(filePath);
            MessageBox.Show(strRet);
        }
    }
}

[config]
type = MSSQL

[MS-Access]
DB = d:\composite.mdb
Pwd = 

[MSSQL]
Server = test
DB     = pubs
User   = sa
Pwd    = 123456

[MySQL]
Server = 192.168.1.107
DB     = mysql
User   = admin
Pwd    = admin

参考文章：

    I.    C#迁移之callXBFLibrary - 1(Windows Application)

    II.   C#迁移之callXBFLibrary - 2(调用非托管DLL)

    III.  C#迁移之callXBFLibrary - 3(调用COM)

    IV. Connector/Net Connection String Options Reference

    V.  MySQL Connector/Net connection strings

附录：

Table 7.1 ADO.net for MySQL 连接串选项 - 通用

C#迁移之callXBFLibrary - ADO.net,古老的榕树,5-wow.com