＋设为首页 ＋添加到收藏夹
偶准备做一个数据库维护的基类,但根据csdn的方法:
DataSet m_set;
OleDbConnection oleDbConnection1;
OleDbDataAdapter oleDbDataAdapter1;
oleDbConnection1=new OleDbConnection("Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=cepb;Data Source=cepb.oa.com;password=cepb;");
oleDbDataAdapter1=new OleDbDataAdapter("select * from hjjc_rpnt ",oleDbConnection1);
m_set=new DataSet();
oleDbDataAdapter1.Fill(m_set,"test");
OleDbCommandBuilder cmdb=new OleDbCommandBuilder(oleDbDataAdapter1);
m_set.Tables[0].Rows[0][0] = 7687.98;
try
{
oleDbDataAdapter1.Update(m_set,"test");
}
catch(Exception e1)
{
return;
}
弹出异常:对于不返回任何键列信息的 SelectCommand 不支持 UpdateCommand 的动态 SQL 生成。
请问各位大虾是什么意思!怎么解决!还有,怎么结帖???
make sure your table has a primary key, try
OleDbCommandBuilder cb = new OleDbCommandBuilder(oleDbDataAdapter1);
oleDbDataAdapter1.Update(m_set,"test");
补充：这个主键是设置是连接的数据库的要操作的表的主键
