帮忙给讲讲!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
private void Button1_Click(object sender, System.EventArgs e)
{
OleDbConnection myConnection = new OleDbConnection("Provider=MSDAORA;User id=test;password=tz;DataSource=test");
string SelectStr="SELECT hc_id.nextval from dual";
OleDbCommand myCommand = new OleDbCommand(SelectStr,myConnection);
}
请问这个时候SELECT 取出的hc_id.nextval存放在哪里了?
问题点数：20、回复次数：2Top
1 楼50277（柳影随风）回复于 2005-05-17 11:18:32 得分 20
OleDbDataAdapter dataA=new OleDbDataAdapter()
......
command.CommandType =CommandType.Text;
dataA.SelectCommand =command;
dataA.Fill(data);Top
2 楼cleaner77（想知道）回复于 2005-05-17 15:22:40 得分 0
private void Button1_Click(object sender, System.EventArgs e)
{
OleDbConnection myConnection = new OleDbConnection("Provider=MSDAORA;User ID=test;Password=test;DataSource=test");
string SelectStr="SELECT id.nextval from dual";
OleDbCommand myCommand = new OleDbCommand(SelectStr,myConnection);
this.oleDbInsertCommand1.CommandText = "INSERT INTO TESTHC(MC, ID) VALUES (?, id.nextval)";
this.oleDbInsertCommand1.Connection = this.oleDbConnection1;
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("MC", System.Data.OleDb.OleDbType.VarChar, 20, "MC"));
this.oleDbDataAdapter1.InsertCommand.Parameters["mc"].Value=this.TextBox1.Text;
this.oleDbDataAdapter1.InsertCommand.Connection.Open();
this.oleDbDataAdapter1.InsertCommand.ExecuteNonQuery();
this.oleDbDataAdapter1.InsertCommand.Connection.Close();
}
为什么我没有myCommand.ExecuteNonQuery()语句，也没有放到datareader中，也能得到id.nextval的值，并且插入testhc表呢？Top
相关问题
关键词
得分解答快速导航
相关链接
广告也精彩
反馈
