用语句就可以实现啊,就不需要用向导了
OracleDataAdapter MyAdapter = new OracleDataAdapter();
OracleTransaction trans = myCn.BeginTransaction(); MyAdapter.InsertCommand =myCm;
MyAdapter.InsertCommand.CommandText = "C_NAME_INN";
MyAdapter.InsertCommand.CommandType=CommandType.StoredProcedure;
MyAdapter.InsertCommand.Connection = myCn; OracleParameter p2 = new OracleParameter("V_ID", OracleType.VarChar,40);
p2.SourceVersion = DataRowVersion.Current;
p2.SourceColumn = ntable.Columns[0].ColumnName;
MyAdapter.InsertCommand.Parameters.Add(p2); OracleParameter p1 = new OracleParameter("V_CLASSID", OracleType.VarChar, 40);
p1.SourceVersion = DataRowVersion.Current;
p1.SourceColumn = ntable.Columns[1].ColumnName;
MyAdapter.InsertCommand.Parameters.Add(p1); OracleParameter p3 = new OracleParameter("V_MCLASSID", OracleType.VarChar, 40);
p3.SourceVersion = DataRowVersion.Current;
p3.SourceColumn = ntable.Columns[2].ColumnName;
MyAdapter.InsertCommand.Parameters.Add(p3); OracleParameter p4 = new OracleParameter("V_MCLASSNAME", OracleType.VarChar, 40);
p4.SourceVersion = DataRowVersion.Current;
p4.SourceColumn = ntable.Columns[3].ColumnName;
MyAdapter.InsertCommand.Parameters.Add(p4);
MyAdapter.Update(ntable);
OracleDataAdapter MyAdapter = new OracleDataAdapter();
OracleTransaction trans = myCn.BeginTransaction(); MyAdapter.InsertCommand =myCm;
MyAdapter.InsertCommand.CommandText = "C_NAME_INN";
MyAdapter.InsertCommand.CommandType=CommandType.StoredProcedure;
MyAdapter.InsertCommand.Connection = myCn; OracleParameter p2 = new OracleParameter("V_ID", OracleType.VarChar,40);
p2.SourceVersion = DataRowVersion.Current;
p2.SourceColumn = ntable.Columns[0].ColumnName;
MyAdapter.InsertCommand.Parameters.Add(p2); OracleParameter p1 = new OracleParameter("V_CLASSID", OracleType.VarChar, 40);
p1.SourceVersion = DataRowVersion.Current;
p1.SourceColumn = ntable.Columns[1].ColumnName;
MyAdapter.InsertCommand.Parameters.Add(p1); OracleParameter p3 = new OracleParameter("V_MCLASSID", OracleType.VarChar, 40);
p3.SourceVersion = DataRowVersion.Current;
p3.SourceColumn = ntable.Columns[2].ColumnName;
MyAdapter.InsertCommand.Parameters.Add(p3); OracleParameter p4 = new OracleParameter("V_MCLASSNAME", OracleType.VarChar, 40);
p4.SourceVersion = DataRowVersion.Current;
p4.SourceColumn = ntable.Columns[3].ColumnName;
MyAdapter.InsertCommand.Parameters.Add(p4);
MyAdapter.Update(ntable);
如果不行的话,在 .Net 中的“引用”中删除 System.Data.OracleClient, 再重新引用,因为你可能引用了错误的版本