怎么样在vs2005调用存储过程并用Datareader读出？
前些日一位兄弟问我vs2003下如何用sql2000的存储过程，并用DataReader读出苦于一时没有2003只好用2005写了一下，没想到改了一下还真是好使，而且进行了一下数据库的负载测试，效果还是不错的
DimconnAsNewSqlConnection()conn.ConnectionString=ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionStringconn.Open()DimcmdAsNewSqlCommand()cmd.Connection=conncmd.CommandType=CommandType.StoredProcedurecmd.CommandText="User"Dimc1AsNewSqlParameter("@id",SqlDbType.BigInt)c1.Value=Val(session)cmd.Parameters.Add(c1)DimreaderAsSqlDataReaderDimpreviousConnectionStateAsConnectionState=conn.StateTryIfconn.State=ConnectionState.ClosedThenconn.Open()EndIfreader=cmd.ExecuteReader()UsingreaderWhilereader.Readplovelike=reader.Item("lovelike").ToStringEndWhileEndUsingFinallyIfpreviousConnectionState=ConnectionState.ClosedThenconn.Close()EndIfEndTryconn.Close()本文地址：http://www.45fan.com/dnjc/70354.html