form1.cs

很好看的 大家可以学习一下db2 不要sqlserver勒

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

using System.Data.Odbc;
using System.Diagnostics;

namespace TEST
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
            button1.Click += new EventHandler(button1_Click);
            button2.Click += new EventHandler(button2_Click);
        }

        private void button1_Click(object sender, EventArgs e)
        {
            string QuerySQL = textBox2.Text.Trim();
            Stopwatch run = new Stopwatch();
            run.Start();
            DataTable dt = rdtFromDB2(QuerySQL);
            run.Stop();

            string a = Convert.ToString(Convert.ToString(dt.Rows.Count) + "条记录,查询耗时：" + run.ElapsedMilliseconds * 1.000 / 1000);
            a = a + "秒";
            run.Reset();
            run.Start();
            dataGridView1.DataSource = dt;
            run.Stop();
            a = a + ",装载网格耗时：" + Convert.ToString(run.ElapsedMilliseconds * 1.000 / 1000) + "秒";
            textBox1.Text = a.Trim();
        }

        DataTable rdtFromDB2(string s)
        {
            //db2引擎连接
            DataSet ds = new DataSet();
            DataTable dt = new DataTable();
            string cnnString = @"Server=127.0.0.1:50000;Database=accp;UID=db2admin;PWD=123;CurrentSchema=TK;Connection Lifetime=60;Connection Reset=false;Max Pool Size=5;Min Pool Size=3;Pooling=True;Connect Timeout=15";
            DB2Connection cnn = new DB2Connection(cnnString);
            cnn.Open();
            DB2DataAdapter da = new DB2DataAdapter(s, cnn);
            da.Fill(ds, "tab");
            //oledb 连接模式
            //string cnnString = @"driver={IBM DB2 ODBC DRIVER};Database=bl_devp;hostname=192.168.0.127;port=50000; protocol=TCPIP;uid=db2inst1;pwd=db2; CurrentSchema=TK; ";
            ////OleDbConnection cnn = new OleDbConnection(cnnString);
            ////SqlConnection cnn = new SqlConnection(cnnString);
            //OdbcConnection cnn = new OdbcConnection(cnnString);
            //cnn.Open();
            ////OleDbDataAdapter da = new OleDbDataAdapter(s,cnn);
            ////SqlDataAdapter da = new SqlDataAdapter(s, cnn);
            //OdbcDataAdapter da = new OdbcDataAdapter(s, cnn);

            da.Fill(ds, "SysTable");

            cnn.Close();
            cnn.Dispose();
            ds.Dispose();
            da.Dispose();
            return ds.Tables[0];
        }

        private void button2_Click(object sender, EventArgs e)
        {
            dataGridView1.DataSource = null;
        }

        private void button3_Click(object sender, EventArgs e)
        {
            int i = 50;
            int k = 60;

            int j = Convert.ToInt32(Math.Ceiling((double)k / (double)i));
            string a = ",1-45,46-71";
            if (a.StartsWith(","))
            {
                a = a.Substring(1, a.Length - 1);
            }

            string b = "sjgs;sdf;sdfpo";
            string[] arr = b.Split(';');
            //MessageBox.Show(c.ToString());


        }


    }
}