输出的还是 select num_seq.currval from dual
但你要取得select出来的值
conn1.open();
OleDbCommand cmd = new OleDbCommand(sqltext, conn1);
string strNum = cmd.ExecuteScalar().ToString();
但你要取得select出来的值
conn1.open();
OleDbCommand cmd = new OleDbCommand(sqltext, conn1);
string strNum = cmd.ExecuteScalar().ToString();
Dim conn1 As OleDbconnection = New OleDbconnection(MyConnstring)
dim sqltext as string ="select num_seq.currval from dual"
dim oledbcommand1 as new oledbcommand()
oledbcommand1.commandtext=Sqltext
response.write(oledbcommand1.executescalar().tostring())
還可以
Dim MyConnstring As String = "provider=MSDAORA; data source=陈浩军; user id=test; password=erpjw;"
Dim conn1 As OleDbconnection = New OleDbconnection(MyConnstring)
dim sqltext as string ="select num_seq.currval from dual"
dim oledbcommand1 as new oledbcommand()
dim oledbdatareader1 as oledbdatareader
oledbcommand1.commandtext=Sqltext
oledbdatareader1=oledbcommand1.ExecuteReader
if oledbdatareader1.read then
response.write(oledbdatareader1(0).tostring())
end if
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.InvalidOperationException: ExecuteScalar:Connection 属性尚未初始化。出现这样的错是怎么回事?????