编程中国 | 业界新闻 | 技术文章 | 视频教程 | 下载频道 | 程序源码 | 个人空间 | 编程论坛  
全能 ASP / PHP / ASP.NET 主机,支持月付专业 MSSQL 数据库空间,支持月付专业 MySQL 数据库空间,支持月付学习型 ASP/PHP/ASP.NET 主机 30元/年
 47 12345
发新话题
打印

索引超出范围。必须为非负值并小于集合大小(超紧急,求救!!!)

确切的说就是sql语句有拼写错误,好好检查之后再发帖……

TOP

Response.Write(sdr["UF_CARD_TITLE"]);
如果用输出的方法内容全可以读出来
.NET发烧友交流群  群一:5953354(满)群二:68096127群三:30217249群四:37023079
注:二、三、四群管理员正在招募中,希望大家多多支持!
drl_0602@hotmail.com    为了更好的交流互相加一下

TOP

protected void binddingzhi()
    {
        
        string sqlcomm = "";
        sqlcomm += "SELECT UF_CARD_TITLE,UF_CARD_USERID,UF_CARD_ADDTIME,UF_RECARD_SORT,";
        sqlcomm += "UF_CARD_VISITQUANTITY,UF_RECARD_ADDTIME,UF_RECARD_USERID FROM UF_CARD,UF_RECARD WHERE UF_RECARD_SORT IN";
        sqlcomm += " (SELECT count(*) FROM UF_RECARD WHERE UF_RECARD_CARDID IN (SELECT UF_CARD_ID FROM UF_CARD))";
        sqlcomm += " AND UF_CARD_TOP = 1 ORDER BY UF_CARD_ADDTIME desc";
        SqlConnection myconn = new SqlConnection(publicclass.getconnstr());
        myconn.Open();
        SqlCommand mycommand = new SqlCommand(sqlcomm, myconn);
        SqlDataReader sdr = mycommand.ExecuteReader();
        for (int i = 0; i < 10; i++)
        {
            if (sdr.Read())
            {
                Response.Write(sdr["UF_CARD_TITLE"]);
                Response.Write("<br>");
                Response.Write(sdr["UF_CARD_USERID"]);
                Response.Write("<br>");
                Response.Write(sdr["UF_CARD_ADDTIME"]);
                Response.Write("<br>");
                Response.Write(sdr["UF_RECARD_SORT"]);
                Response.Write("<br>");
                Response.Write(sdr["UF_CARD_VISITQUANTITY"]);
                Response.Write("<br>");
                Response.Write(sdr["UF_RECARD_USERID"]);
                Response.Write("<br>");
                Response.Write(sdr["UF_RECARD_ADDTIME"]);
                Response.Write("<br>");
                //((LinkButton)(GridView1.Rows[0].Cells[1].FindControl("LinkButton1"))).Text = sdr["UF_CARD_TITLE"].ToString();
                //((Label)(GridView1.Rows[0].Cells[2].FindControl("Label2"))).Text = sdr["UF_CARD_USERID"].ToString();
                //((Label)(GridView1.Rows[0].Cells[2].FindControl("Label3"))).Text = sdr["UF_CARD_ADDTIME"].ToString();
                //((Label)(GridView1.Rows[0].Cells[3].FindControl("Label4"))).Text = sdr["UF_RECARD_SORT"].ToString();
                //((Label)(GridView1.Rows[0].Cells[3].FindControl("Label5"))).Text = sdr["UF_CARD_VISITQUANTITY"].ToString();
                //((Label)(GridView1.Rows[0].Cells[4].FindControl("Label6"))).Text = sdr["UF_RECARD_USERID"].ToString();
                //((Label)(GridView1.Rows[0].Cells[4].FindControl("Label7"))).Text = sdr["UF_RECARD_ADDTIME"].ToString();            
            }
            else
            {
                Response.Write("no");
            }
        }
    }
.NET发烧友交流群  群一:5953354(满)群二:68096127群三:30217249群四:37023079
注:二、三、四群管理员正在招募中,希望大家多多支持!
drl_0602@hotmail.com    为了更好的交流互相加一下

TOP

Response.Write(sdr["UF_RECARD_ADDTIME"]);
你这样得到了值 那么证明sdr["UF_RECARD_ADDTIME"]是将值取出来了的

报的是索引超出范围

应该是
((Label)(GridView1.Rows[0].Cells[2].FindControl("Label2"))).Text
这个没有找到Label控件

TOP

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" BorderColor="#8080FF"
        Width="100%">
        <Columns>
            <asp:TemplateField>
                <ItemTemplate>
                    <img src="images/bbs_1_12.jpg" />
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="顶置">
                <ItemTemplate>
                     <asp:LinkButton ID="LinkButton1" runat="server">LinkButton</asp:LinkButton>
                    <img src="images/new.gif" />
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="作者">
                <ItemTemplate>
                    <asp:Label ID="Label2" runat="server" Text="Label"></asp:Label><br />
                    <asp:Label ID="Label3" runat="server" ForeColor="DarkGray" Text="Label"></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="回复/查看">
                <ItemTemplate>
                    <asp:Label ID="Label4" runat="server" ForeColor="DarkGreen" Text="Label"></asp:Label>
                    /<asp:Label ID="Label5" runat="server" Text="Label"></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="最后发表">
                <ItemTemplate>
                    <asp:Label ID="Label6" runat="server" Text="Label"></asp:Label>
                    <br />
                    <span style="color: darkgray">by</span>
                    <asp:Label ID="Label7" runat="server" ForeColor="Silver" Text="Label"></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
        </Columns>
        <HeaderStyle BackColor="MediumTurquoise" Height="30px" />
    </asp:GridView>
.NET发烧友交流群  群一:5953354(满)群二:68096127群三:30217249群四:37023079
注:二、三、四群管理员正在招募中,希望大家多多支持!
drl_0602@hotmail.com    为了更好的交流互相加一下

TOP

怎么可能没有label啊
.NET发烧友交流群  群一:5953354(满)群二:68096127群三:30217249群四:37023079
注:二、三、四群管理员正在招募中,希望大家多多支持!
drl_0602@hotmail.com    为了更好的交流互相加一下

TOP

不是说没有label,而是说label没有找到

你打断点监视一下看看的嘛

这样你可以找到详细的错误位置噻

TOP

 47 12345
发新话题