DBHelper:
/// <summary>
/// 执行查询
/// </summary>
/// <param
name="sql">有效的select语句</param>
///
<returns>返回SqlDataReader</returns>
public static SqlDataReader ExecuteReader(string sql)
{
SqlConnection con = new SqlConnection(constring);
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
return cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
/// <summary>
/// 执行查询带参数
/// </summary>
/// <param
name="sql">有效的select语句</param>
///
<returns>返回SqlDataReader</returns>
public static SqlDataReader ExecuteReader(string sql,SqlParameter
parameter)
{
SqlConnection con = new SqlConnection(constring);
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.Add(parameter);
return cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
/// <summary>
/// 执行查询带参数数组
/// </summary>
/// <param
name="sql">有效的select语句</param>