Question

ado.net初学问题

代码如下：
OracleConnection oracleConn = new OracleConnection("Data Source=orcl;Persist Security Info=True;User ID=scott;Password=tiger;Unicode=True");
DataSet dataSet2 = new DataSet();
OracleCommand cmd = null;
cmd = new OracleCommand("select *from emp", oracleConn);
OracleDataAdapter adapter = new OracleDataAdapter(cmd);

adapter.Fill(dataSet2,"emp");

cmd = new OracleCommand("select * from emp1116", oracleConn);
adapter.SelectCommand = cmd;
adapter.Fill(dataSet2,"z");

DataRow rows=dataSet2.Tables["emp"].NewRow();
rows["empno"] = 77777;
dataSet2.Tables["emp"].Rows.Add(rows);

dataSet2.Tables["emp"].Rows.Add(dataSet2.Tables["emp"].NewRow()["empno"]=2222);

adapter.Update(dataSet2);

执行最后一句时有错误：Update 无法找到 TableMapping['Table'] 或 DataTable“Table”怎么解决？什么原理？

Answer 1

DataSet可以包含多个DataTable

MSDN上有详细讲解和说明，梳理思路，代码开发规范并重写一遍

个人意见，谢谢