注册 登录
编程论坛 ASP.NET技术论坛

怎么把LABEL的值绑定到GRIDVIEW中

lmyh5201 发布于 2008-10-06 14:21, 2954 次点击
数据库里有一个字段是Member_ID(他是用户的ID),绑定到gridview 里是1,2,3,而我想要的是如果是admin发布的这个消息,则在gridview的发布人列里显示admin,而不是1,2,3,怎么实现这个阿?
16 回复
#2
仰望星空2008-10-06 14:27
那应该是对每行记录进行一个判断,判断的结果显示出来就可以了,代码应该会写吧
#3
lmyh52012008-10-06 14:31
string orderby = " ID desc ";
        try
        {
            int Member_ID = Convert.ToInt32(Data_Member.ReturnMemeber_ID(Page.User.Identity.Name));
            string Member = Data_Member.ReturnMember(Member_ID);//这已经得到了用户的名称
            DataSet ds = Data_SystemNews.SystemNews_ByPage(whereclause, orderby, AspNetPager2.CurrentPageIndex, AspNetPager2.PageSize);
            if (ds.Tables[0].Rows.Count > 0)
            {
                AspNetPager2.RecordCount = int.Parse(ds.Tables[0].Rows[0]["TotalCount"].ToString());
                AspNetPager2.CustomInfoHTML = "共: " + ds.Tables[0].Rows[0]["TotalCount"].ToString() + "条记录!";
            }
            else
            {
                AspNetPager2.RecordCount = 0;

            }

            gv_Ad_News.DataSource = ds.Tables[0];
            gv_Ad_News.DataBind();

        }
        catch (Exception ex)
        {
            JScript.Alert(ex.Message);
        }


html代码

<ItemTemplate>
                                                    <div class="GV_frist_Row" style="width: 10%;">
                                                        <%# Eval("ID") %>
                                                    </div>
                                                    <div class="GV_frist_Row" style="width: 25%;">
                                                        <%# Eval("Ttitle")%>
                                                    </div>
                                                    <div class="GV_frist_Row" style="width: 15%;">
                                                        //在这怎么把得到的名称绑定过来啊?div>
                                                    <div class="GV_frist_Row" style="width: 10%;">
                                                        <asp:LinkButton ID="but_OnTop" runat="server" CommandName="OnTop"><%# ReturnOntop(Eval("OnTop").ToString())%></asp:LinkButton>
                                                    </div>
                                                    <div class="GV_frist_Row" style="width: 10%;">
                                                        <asp:LinkButton ID="but_Commend" runat="server" CommandName="Commend"><%# ReturnCommend(Eval("Commend").ToString()) %></asp:LinkButton>
                                                    </div>
                                                    <div class="GV_frist_Row" style="width: 10%;">
                                                        <asp:LinkButton ID="but_state" runat="server" CommandName="state"><%# Returnstate(Eval("state").ToString()) %></asp:LinkButton>
                                                    </div>
                                                    <div class="GV_frist_Row" style="width: 10%;">
                                                        <asp:ImageButton ID="ImageButton1" runat="server" ImageUrl="~/images/ic_delartc.gif"
                                                            CommandName="Delete" /></div>
                                                    <div class="GV_frist_Row" style="width: 9.8%;">
                                                        <a href="SystemNews_Insert.aspx?ID=<%# Eval("ID")%>">
                                                            <img border="0" src="../images/ic_edit.gif" /></a>
                                                    </div>
                                                </ItemTemplate>
#4
lmyh52012008-10-06 14:41
回复 2# 仰望星空 的帖子
代码怎么写啊?谢谢
#5
zsf20062008-10-06 15:58
这不难啊,2种方案
其一:前台绑定
 <%# GetTitleName(Eval("ID").ToString()) %>
就是在后台里写一个 GetTitleName(string tName)方法来获得发布者
不知道我表达是否清楚

其二:在后台代码实现
在RowDataBound()里实现,这个更好,推荐!
#6
lmyh52012008-10-06 18:10
具体点阿
#7
仰望星空2008-10-06 18:41
绑定之前,总能得到一个dataset之类的东东吧,把这个dataset之类的东东处理一下,再绑定不就好了?
#8
lmyh52012008-10-06 20:34
给点代码侃侃啊
#9
仰望星空2008-10-06 20:40
我说的那个还需要代码吗?很基础了,总不至于连DataSet都不会用吧
#10
lmyh52012008-10-06 20:45
怎么处理dataset里面的东西啊
#11
hebingbing2008-10-06 20:54
说的俗一点你可以将dataset当成一个内存中的数据库,里面可以放很多数据库表,表里可以有列…………
#12
lmyh52012008-10-06 20:56
还是不明白
#13
仰望星空2008-10-06 21:10
诺诺的问一下,你知道DataSet是什么东东吗?
要是不知道,那你还是先补习一下.NET基础知识吧,这些基础不是论坛里一句半句能讲完的
#14
lmyh52012008-10-06 21:12
绑定之前,总能得到一个dataset之类的东东吧,把这个dataset之类的东东处理一下,再绑定不就好了?

怎么处理啊
#15
仰望星空2008-10-06 21:29
请问你是拿什么绑定gridview的?
#16
zsf20062008-10-06 21:38
还没搞定啊,替你急!!!
加Q:(28720733)
#17
yutianyi2008-10-07 10:22
用哈希表做,
   Hashtable hsTable = new Hashtable();

   hsTable .Add("1", "admin1");  //可用循环添加
   hsTable .Add("2", "admin2");

   hsTable ["1"].ToString(); //即可得到"admin1"
1