using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;namespace DataSet
{
    public partial class Form1 : Form
    {
        OleDbConnection conn; 
        OleDbDataAdapter da; 
        System.Data.DataSet ds;
        public Form1()
        {
            InitializeComponent();
            OnLoadData();
        }        private void OnLoadData()
        {
            string txtConn =
                "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=G:\\Test\\studentI.mdb";
            conn = new OleDbConnection(txtConn);
            string txtCommand = "SELECT * FROM Student";
            da = new OleDbDataAdapter(txtCommand, conn);
            ds = new System.Data.DataSet("ds");
            da.Fill(ds, "Student");
            dataGrid1.DataSource = ds;
            dataGrid1.DataMember = "Student";
        }        private void bt_del_Click(object sender, EventArgs e)//删除按钮的响应事件
        {
            int x;
            x = dataGrid1.CurrentRowIndex;
            ds.Tables["Student"].Rows[x].Delete();
        }        private void button1_Click(object sender, EventArgs e)//更新源数据库
        {
            if (ds.HasChanges())
                da.Update(ds);//这里出现Update 无法找到 TableMapping['Table'] 或 DataTable“Table”
        }    }
}
数据库StudentI.mdb:学生编号 学生姓名 性别
1         张三          男
2         李四          女
3         王五          男
4         鲁六          女
10         郭叶锋          男