数据显示问题

[artcodeman]

    SqlConnection Conn = new SqlConnection(strconn);
    Conn.Open();
    String sql = "select top 5 * from News order by ID desc" ;
    SqlDataReader Dr = new SqlDataReader(sql,Conn);
    while(Dr.Read())
    {
    List=List+"<li>"+Dr["Title"].ToString()+"</li>";
    }
    NoticeList="<ul>"+List+"</ul>";

提示 编译器错误消息: CS0143: 类型“System.Data.SqlClient.SqlDataReader”未定义构造函数

[满衣兄]

SqlConnection Conn = new SqlConnection(strconn);
Conn.Open();
String sql = "select top 5 * from News order by ID desc" ;
SqlCommand cmd = Conn.CreateCommand();
cmd.CommandText = sql;
SqlDataReader sdr = cmd.ExecuteReader();
while(Dr.Read())
{
    List=List+"<li>"+Dr["Title"].ToString()+"</li>";
}
NoticeList="<ul>"+List+"</ul>";
sdr.Close();
Conn.Close();

[jiang_jiajia10]

SqlConnection Conn = new SqlConnection(strconn);
    Conn.Open();
    String sql = "select top 5 * from News order by ID desc" ;
     SqlCommand cmd = new SqlCommand(sql ,sqlconnetion);
    SqlDataReader Dr = cmd.ExecuteReader();
    while(Dr.Read())
    {
    List=List+"<li>"+Dr["Title"].ToString()+"</li>";
    }
    NoticeList="<ul>"+List+"</ul>";

[满衣兄]

SqlDataReader sdr
修改为
SqlDataReader Dr

[takako_mu]

SqlConnection Conn = new SqlConnection(strconn);
    Conn.Open();
    String sql = "select top 5 * from News order by ID desc" ;
    SqlCommand cmd1 = new SqlCommand(sql, conn);
    SqlDataReader Dr = cmd1.ExecuteReader();
    while(Dr.Read())
    {
    List=List+"<li>"+Dr["Title"].ToString()+"</li>";
    }
    NoticeList="<ul>"+List+"</ul>";

[TimLeaf]

若要创建 SqlDataReader，必须调用 SqlCommand 对象的 ExecuteReader 方法，而不直接使用构造函数。
MSDN上面的话~

[xiaoqiuwyh]

没有SqlCommand呀。

SqlCommand cmd = new SqlCommand(sql ,conn);

[claymore1114]

[Quote=引用 5 楼 TimLeaf 的回复:]
若要创建 SqlDataReader，必须调用 SqlCommand 对象的 ExecuteReader 方法，而不直接使用构造函数。
MSDN上面的话~
[/Quote]
楼主的SqlDataReader定义错误，不能直接，要用command,
SqlCommand cmd1 = new SqlCommand(sql ,conn);
SqlDataReader Dr = cmd1.ExecuteReader();

[qinhl99]

SqlCommand cmd = Conn.CreateCommand();
cmd.CommandText = sql;
SqlDataReader Dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);