使用datalist显示数据,为何第一条记录不显示?? 使用datalist显示数据,为何第一条记录不显示?? SQL语句使用查询分析器能查出全部记录,可是为什么第一条记录不显示?? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 看看你的datalist中查询条件是不是很多and组成的··· SQL语句:select sort,count(sort) as sortnum from log group by sort ORDER BY sort DESC 估计用的是DataReader绑定数据前先if(dr.Read()){//去绑定数据}结果过了一条记录 估计楼主是用datareader 绑定的用了 个if 判断 然后又while了一下 if(dr.Read()) {}应该要改为while(dr.Read()) {} 马上试试~~楼上的被你猜中了,我真的用了DataReader!!! 抱歉,还是不行!!adminsort是Datalist控件代码:protected void adminsortnum() { string selectsort = "select sort,count(sort) as sortnum from log group by sort ORDER BY sort DESC"; SqlConnection sqlconn = SQL.sqlconn(); sqlconn.Open(); SqlCommand sort2 = new SqlCommand(selectsort,sqlconn); SqlDataReader sort3 = sort2.ExecuteReader(); if (sort3.Read()) { adminsort.DataSource = sort3; adminsort.DataKeyField = "sort"; adminsort.DataBind(); } }HTML代码:<asp:DataList ID="adminsort" runat="server"> <ItemTemplate> <ul> <li> <asp:Label ID="Label6" runat="server" Text='<%# Eval("sort") %>'></asp:Label>  (<span style=" color:#ff0000"><asp:Label ID="Label7" runat="server" Text='<%# Eval("sortnum") %>'></asp:Label></span>篇)  |   <asp:LinkButton ID="LinkButton1" runat="server" ToolTip='<%# Eval("sort") %>' OnClick="LinkButton1_Click"><img alt="编辑类型" src="./images/Edit.Gif" /></asp:LinkButton>  |   <asp:LinkButton ID="LinkButton2" runat="server" ToolTip='<%# Eval("sort") %>'><img alt="删除类型" src="./images/delete.Gif" /></asp:LinkButton> </li> </ul> </ItemTemplate> </asp:DataList> 去掉if (sort3.Read()) ,改成这样protected void adminsortnum() { string selectsort = "select sort,count(sort) as sortnum from log group by sort ORDER BY sort DESC"; SqlConnection sqlconn = SQL.sqlconn(); sqlconn.Open(); SqlCommand sort2 = new SqlCommand(selectsort,sqlconn); SqlDataReader sort3 = sort2.ExecuteReader(); adminsort.DataSource = sort3; adminsort.DataKeyField = "sort"; adminsort.DataBind(); } 8楼的前辈,能否解析一下为什么去掉if (sort3.Read()) 就能显示全部? 我的vs2008 应该下载哪个版本的DirectShow sdk?在哪里下? [馨郁星愿] Gmap2未定义? asp.net在报表中显示多个表的字段(通过表关联) 一点心得,修改fckeditor源代码控制附件上传 初学asp.net,准备下去中关村海淀图书城购书.不知买什么书好. 如何手动编译default.aspx.cs文件? 求助:数据批量录入,一次保存,请高手指教 [求助]上传后网页的部分按钮不响应点击事件 如何将值传给弹出的小窗口? ASP.NET(c#)实现中英文域名查询 问个和ajax相关的问题 问一下三层的简单问题!
if(dr.Read())
{
//去绑定数据
}结果过了一条记录
{}
应该要改为
while(dr.Read())
{}
adminsort是Datalist控件
代码:
protected void adminsortnum()
{
string selectsort = "select sort,count(sort) as sortnum from log group by sort ORDER BY sort DESC";
SqlConnection sqlconn = SQL.sqlconn();
sqlconn.Open();
SqlCommand sort2 = new SqlCommand(selectsort,sqlconn);
SqlDataReader sort3 = sort2.ExecuteReader();
if (sort3.Read())
{
adminsort.DataSource = sort3;
adminsort.DataKeyField = "sort";
adminsort.DataBind();
}
}HTML代码:
<asp:DataList ID="adminsort" runat="server">
<ItemTemplate>
<ul>
<li>
<asp:Label ID="Label6" runat="server" Text='<%# Eval("sort") %>'></asp:Label> 
(<span style=" color:#ff0000"><asp:Label ID="Label7" runat="server" Text='<%# Eval("sortnum") %>'></asp:Label></span>篇)  |  
<asp:LinkButton ID="LinkButton1" runat="server" ToolTip='<%# Eval("sort") %>' OnClick="LinkButton1_Click"><img alt="编辑类型" src="./images/Edit.Gif" /></asp:LinkButton>  |  
<asp:LinkButton ID="LinkButton2" runat="server" ToolTip='<%# Eval("sort") %>'><img alt="删除类型" src="./images/delete.Gif" /></asp:LinkButton>
</li>
</ul>
</ItemTemplate>
</asp:DataList>
{
string selectsort = "select sort,count(sort) as sortnum from log group by sort ORDER BY sort DESC";
SqlConnection sqlconn = SQL.sqlconn();
sqlconn.Open();
SqlCommand sort2 = new SqlCommand(selectsort,sqlconn);
SqlDataReader sort3 = sort2.ExecuteReader();
adminsort.DataSource = sort3;
adminsort.DataKeyField = "sort";
adminsort.DataBind();
}