form1.cs

我的一个Ado.Net一个框架设计

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

namespace WindowsManager
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        DataTable dt;
        private void btnBatchUpdate_Click(object sender, EventArgs e)
        {
            dt = new BLL.LibrayTest().GetStudent();
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                dt.Rows[i]["Name"] = "haizi";
            }
            dt.TableName = "Student";
            DataTable change = dt.GetChanges();
            DataTable c = change.GetChanges();
            new BLL.LibrayTest().BatchUpdate(c);

        }

        private void btnBatchInsert_Click(object sender, EventArgs e)
        {
            dt = new BLL.LibrayTest().GetStudent();
            dt.Columns.RemoveAt(0);
            for (int i = 0; i < 10; i++)
            {
                DataRow row = dt.NewRow();
                row[0] = "Name";
                row[1] = DateTime.Now;
                row[2] = "兰考";
                dt.Rows.Add(row);
            }
            dt.TableName = "Student";
            DataTable changeTable = dt.GetChanges(DataRowState.Added);
            new BLL.LibrayTest().BatchInsert(changeTable);
        }

        private void btnBatchDelete_Click(object sender, EventArgs e)
        {
            dt = new BLL.LibrayTest().GetStudent();
            dt.TableName = "Student";
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                dt.Rows[i].Delete();
            }
            DataTable chate = dt.GetChanges();
            new BLL.LibrayTest().BatchDelete(dt);
        }

        private void btnBulkCopy_Click(object sender, EventArgs e)
        {
            string connStr = new DAL.ConnectionSring().SqlConnectionString;
            DAL.BulkCopy.TransCopy(connStr, connStr, "Select * from Student", "Teacher",50);
        }

    }
}