为什么SqlCommandBuilder更新不了数据库内容?

[KJ_Wang]

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 AsyncDemo
{
public partial class Form2 : Form
{
private SqlDataAdapter da = null;
private DataSet ds = null;
public Form2()
{
InitializeComponent();
}

private void cmdSearch_Click(object sender, EventArgs e)
{
DBBase db = new DBBase();
da = new SqlDataAdapter("select * from testa", db.GetVisioTestDBConnection());
ds = new DataSet();
da.Fill(ds, "TestA");
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "TestA";
}

private void cmdUpdate_Click(object sender, EventArgs e)
{
SqlCommandBuilder cb = new SqlCommandBuilder(da);
try
{
int iis = da.Update(ds, "TestA");
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}

private void cmdDelete_Click(object sender, EventArgs e)
{
//dataGridView1.Rows.Remove(dataGridView1.CurrentRow);
ds.Tables["TestA"].Rows.RemoveAt(dataGridView1.CurrentRow.Index);
ds.Tables["TestA"].AcceptChanges();
}
}
}

[xyq1986]

有主键吗?

[KJ_Wang]

肯定有啦,就是删除不掉,其他都OK啦!!!!!

[zxkid]

private void cmdDelete_Click(object sender, EventArgs e)
{
//dataGridView1.Rows.Remove(dataGridView1.CurrentRow);
ds.Tables["TestA"].Rows.RemoveAt(dataGridView1.CurrentRow.Index);
ds.Tables["TestA"].AcceptChanges();
}
========
改成
private void cmdDelete_Click(object sender, EventArgs e)
{
//dataGridView1.Rows.Remove(dataGridView1.CurrentRow);
ds.Tables["TestA"].Rows[dataGridView1.CurrentRow.Index].Delete();
}

//Remove()/RemoveAt()是删除DataRow对象不是数据行.

[zxkid]

ds.Tables["TestA"].AcceptChanges();
===
这句不要加

[KJ_Wang]

大家知道，这样也不行，其他原因，OK？

[lrq0531]

我的是建立在oracle9上的，有主键，单一关系表，就是生成不了更新与删除sqlstr，