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 郭叶锋 男
{
OleDbCommandBuilder=new OleDbCommandBuilder(da);
da.Update(ds);
}