请问，myCommand.ExecuteReader()执行后，我如何返回Select 语句查询结果的记录条数！

[baowang]

myCommand.ExecuteReader()

[hotbuild]

如果你真要这样做的话，你做循环吧，统计I++

[LinyaoLM]

再写一条 select count (*) .... 执行一次不就行了

[暗石绿]

select count(*) from ...

[暗石绿]

也可以：
int i = 0;
while(dr.Read())
{
i ++ ;
}
Response.Write(i);

[baowang]

但是,select count(*) from ....这样的结果我如果放入一个变量中呢？

[LinyaoLM]

不明白你的意思。

select count(*) AAA from ...


Dim MyDataReader As Microsoft.Data.Odbc.OdbcDataReader
Dim var1 as string
MyDataReader = MyCommand.ExecuteReader
MyDataReader.Read()
var1 = MyDataReader("AAA")

[baowang]

?

[aquariusBoy]

myCommand.ExecuteNonQuery();
这个东西返回的是受影响的行数，也就是你要的行数了：）

[baowang]

我的源码是这样的：

Dim myConnectionString As string = System.Configuration.ConfigurationSettings.AppSettings("SQLConnString")
Dim myConnection As New OleDbConnection(myConnectionString)

Dim Query_res As string = " select * from item_repertory_info where item_code='" + item_code_str + "'"

Dim myCommand_update As New OleDbCommand(Query_res)
myCommand_update.Connection = myConnection
myConnection.Open()
response.write ("[" & myCommand_update.ExecuteNonQuery() & "]")
myConnection.Close()
==============================
response.write ("[" & myCommand_update.ExecuteNonQuery() & "]")
的显示结果是：0


请问你们是如何判断SQL语句返回值记录数的?

[暗石绿]

Dim myConnectionString As string = System.Configuration.ConfigurationSettings.AppSettings("SQLConnString")
Dim myConnection As New OleDbConnection(myConnectionString)

Dim Query_res As string = " select Count(*) as iCount from item_repertory_info where item_code='" + item_code_str + "'"

Dim myCommand As New OleDbCommand(Query_res,myConnection)
myConnection.Open()
Dim myReader As OleDbDataReader
myReader = myCommand.ExecuteReader()
myReader.Read()
Dim i As String
i = myReader("iCount").ToString();
myReader.Close()

myConnection.Close()

[lds88]

呵呵
改用dataadapter，不就没有问题了：）