求一个存储过程+SQLHeper返回DateReader的例子。

[cnuusw]

基本sql语句：select * from users

求一个使用sqlheper+存错过程返回datareader的简单例子（存错过程的主体是该语句）

[mngzilin]

不用sqlhelper

[cnuusw]

4楼提供的是sqlheper自带的方法吧。这个可以用存储过程返回reader？

[Lovely_baby]

http://zhidao.baidu.com/question/93011803.html

[flyerwing]

学习

[vip__888]

把SqlHelper多看两遍就明白了

[wuyq11]

public static SqlDataReader GetReader(string sql, params SqlParameter[] values)
{
SqlCommand cmd = new SqlCommand(sql, Connection);
cmd.Parameters.AddRange(values);
SqlDataReader reader =cmd.ExecuteReader(CommandBehavior.CloseConnection);
Connection.Close();
Connection.Dispose();
return reader;


}

[zhouzangood]

[Quote=引用 2 楼 wuyq11 的回复:]
public static SqlDataReader GetReader(string sql, params SqlParameter[] values)
        {
            SqlCommand cmd = new SqlCommand(sql, Connection);
            cmd.Parameters.AddRange(values);
            SqlDataReader reader =cmd.ExecuteReader(CommandBehavior.CloseConnection);
            Connection.Close();
            Connection.Dispose();
            return reader;
           
         
        }

[/Quote]


？？？这就是存储过程？？？

[Adechen]

public static SqlDataReader ExecuteReader(string connectionString, CommandType cmdType, string cmdText, params SqlParameter[] commandParameters)
        {
            SqlCommand cmd = new SqlCommand();
            SqlConnection conn = new SqlConnection(connectionString);

            // we use a try/catch here because if the method throws an exception we want to 
            // close the connection throw code, because no datareader will exist, hence the 
            // commandBehaviour.CloseConnection will not work
            try
            {
                PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters);
                SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
                cmd.Parameters.Clear();
                return rdr;
            }
            catch
            {
                conn.Close();
                throw;
            }
        }

private static void PrepareCommand(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, CommandType cmdType, string cmdText, SqlParameter[] cmdParms)
        {
            if (conn.State != ConnectionState.Open)
                conn.Open();

            cmd.Connection = conn;
            cmd.CommandText = cmdText;

            if (trans != null)
                cmd.Transaction = trans;

            cmd.CommandType = cmdType;

            if (cmdParms != null)
            {
                foreach (SqlParameter parm in cmdParms)
                    cmd.Parameters.Add(parm);
            }
        }

存储过程自己写吧

[whb147]

SqlDataReader
你要是忘记关了,还麻烦

[lhz_dxm]

public List<string> strALL(string info)
{
SqlParameter sp = new SqlParameter("参数名称", info);
List<string> Mylist = new List<string>();
using (SqlDataReader rd = SQLHelper.ExecuteReader(SQLHelper.connectionString, CommandType.StoredProcedure, "Curve_Fitting", sp))
{
while (rd.Read())
{
Mylist.Add(rd.GetValue(0));
....................
}
}
return Mylist;
}



Curve_Fitting是存储过程的名称