旧问题重谈谈，能解决问题的入内！！！

[fa791222]

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"
response.write(sqltext)

大家说这样写输出的结果是什么???

如果我要其输出"select num_seq.currval from dual"的值,比如30；而不是这句话应该怎样写代码???

[panyee]

输出的还是 select num_seq.currval from dual


但你要取得select出来的值
conn1.open();
OleDbCommand cmd = new OleDbCommand(sqltext, conn1);
string strNum = cmd.ExecuteScalar().ToString();

[sneak]

应该写一OleDbCommand，再cmd.ExecuteScale();则返回该值的object类型。

[panyee]

我的回答丢失了??

你要用ExecuteScalar().ToString()取得查询的结果,

直接response.write只不过是打印那个sql语句

[orcale]

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()
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

[fa791222]

ExecuteScalar：Connection 属性尚未初始化。
说明: 执行当前 Web 请求期间，出现未处理的异常。请检查堆栈跟踪信息，以了解有关该错误以及代码中导致错误的出处的详细信息。

异常详细信息: System.InvalidOperationException: ExecuteScalar：Connection 属性尚未初始化。

出现这样的错是怎么回事？？？？？