frmtest.cs

多种数据访问接口实现 支持SQL SERVER 2000/2005,Oracle,DB2,Acce

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

namespace IDbAccess
{
    public partial class FrmTest : Form
    {
        public FrmTest()
        {
            InitializeComponent();
        }

        private void btnOraDbTest_Click(object sender, EventArgs e)
        {
            try
            {
                IDbAccess pDbAccess;
                string strConn = "Password=sa_land;User ID=sa_land;Data Source=SGCDCA";

                pDbAccess = new OracleDbAccess(strConn);
                pDbAccess.Open();
                MessageBox.Show("OracleDB Connection Test Success!");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());

            }
        }

        private void btnSqlDbTest_Click(object sender, EventArgs e)
        {
            try
            {
                IDbAccess pDbAccess;
                string strConn = "User ID =sa;Password=sa;Initial Catalog=FSDB;Data Source =cld-018";
                pDbAccess = new SqlDbAccess(strConn);
                pDbAccess.Open();
                MessageBox.Show("SQLDB Connection Test Success!");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());

            }
        }

        private void btnOleDbTest_Click(object sender, EventArgs e)
        {
            try
            {
                IDbAccess pDbAccess;

                string strConn = "Provider = SQLOLEDB;User ID =sa;Password=sa;Initial Catalog=FSDB;Data Source =cld-018";
                
                pDbAccess = new OleDbAccess(strConn);
                pDbAccess.Open();
                MessageBox.Show("OleDB Connection Test Success!");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());

            }
        }

        private void FrmTest_Load(object sender, EventArgs e)
        {

        }
    }
}