gridview等控件可以这样绑定字段

 /// <summary>
    /// 删除
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void btnDelete_Click(object sender, EventArgs e)
    {
        for (int i = 0; i <= gvProducts.Rows.Count - 1; i++)
        {

            CheckBox cbox = (CheckBox)gvProducts.Rows[i].FindControl("CheckBox1");
            if (cbox.Checked == true)
            {
                int ID = Convert.ToInt32(gvProducts.DataKeys[i].Value);
                clsIProduct Rpro = new clsRProduct();
                int m = Rpro.Delete(ID);
            }
        }
        Bind();
    }
    protected void lbtnUpdateRecommend_Command(object sender, CommandEventArgs e)
    {
      
    }

    /// <summary>
    /// 搜索
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    
   
    protected void gvProducts_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType==DataControlRowType.DataRow)
        {
            e.Row.Attributes.Add("onMouseOver","SetNewColor(this);");
            e.Row.Attributes.Add("onMouseOut", "SetOldColor(this);");
        }
    }

 

 <asp:GridView ID="gvProducts" runat="server" AutoGenerateColumns="False" DataKeyNames="ID"
                GridLines="None" CellPadding="0" CssClass="talbe_list" OnRowDataBound="gvProducts_RowDataBound">
                <Columns>
                    <asp:TemplateField>
                        <ItemTemplate>
                            <asp:CheckBox ID="CheckBox1" runat="server" />
                        </ItemTemplate>
                        <HeaderStyle CssClass="th20 tou" />
                        <ItemStyle CssClass="nolet" />
                    </asp:TemplateField>
                     <asp:TemplateField HeaderText="留言公司">
                        <EditItemTemplate>
                            <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Name") %>'></asp:TextBox>
                        </EditItemTemplate>
                        <ItemStyle CssClass="left2" />
                        <ItemTemplate>
                            <%# PB_Dailiinfo(Convert.ToInt32(Eval("ID").ToString()))%>
                            <%# GetNewTitle(DataBinder.Eval(Container.DataItem, "RequestContent").ToString(), Eval("ID").ToString())%>
                        </ItemTemplate>
                    </asp:TemplateField>

                    <asp:TemplateField HeaderText="留言内容">
                        <EditItemTemplate>
                            <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Name") %>'></asp:TextBox>
                        </EditItemTemplate>
                        <ItemStyle CssClass="left2" />
                        <ItemTemplate>
                            <%# GetNewTitle(DataBinder.Eval(Container.DataItem, "RequestContent").ToString(), Eval("ID").ToString())%>
                        </ItemTemplate>
                    </asp:TemplateField>
                    <asp:BoundField DataField="Phone" HeaderText="联系方式">
                        <HeaderStyle CssClass="th80" />
                    </asp:BoundField>
                    <asp:BoundField DataField="AddDate" HeaderText="日期">
                        <HeaderStyle CssClass="th80" />
                    </asp:BoundField>
                    <asp:BoundField DataField="UserName" HeaderText="留言人">
                        <HeaderStyle CssClass="th80" />
                    </asp:BoundField>
                    <asp:TemplateField HeaderText="操作选项">
                        <ItemTemplate>
                            <!-- <a href='ProductEdit.aspx?ID=<%# Eval("ID") %>'>编辑</a> |-->
                            <asp:LinkButton CommandName="delete" ID="lnkdelete" CommandArgument='<%# DataBinder.Eval(Container.DataItem, "ID") %>'
                                OnCommand="lnkdelete_Command" runat="server" Text="删除" OnClientClick="return confirm('你确定要删除吗?')"></asp:LinkButton>
                        </ItemTemplate>
                        <HeaderStyle CssClass="th80" />
                    </asp:TemplateField>
                </Columns>
                <HeaderStyle CssClass="header" />
            </asp:GridView>
  public string PB_Dailiinfo(int id)
    {

        int msgid = 0;
        string gongsi = "";
        int chanpin = 0;
        string result = "";
        try
        {
            msgid = Convert.ToInt32(id);
            if (msgid > 0)
            {
                string sqlstr = "select [ProductId],[CompanyName] from W_VisitorRequest where ID='" + msgid + "'";
                DataTable dt = SqlOperate.SqlHelper.ExecuteSqlQuery(sqlstr);
                if (dt.Rows.Count > 0)
                {
                    try { gongsi = dt.Rows[0]["CompanyName"].ToString(); }
                    catch (Exception) { }
                    try { chanpin = Convert.ToInt32(dt.Rows[0]["ProductId"].ToString()); }
                    catch (Exception) { }
                    if (gongsi != "")
                    {
                        result = gongsi;
                    }
                    else if (chanpin != 0)
                    {
                        string sqlstr1 = "select * from C_Supply where ID='" + chanpin + "'";
                        DataTable dt1 = SqlOperate.SqlHelper.ExecuteSqlQuery(sqlstr1);

                        string gongsiname = "";


                        try { gongsiname = SqlOperate.SqlHelper.ExecuteScalar("select CompanyName from U_UserInfo where UserID='" + dt1.Rows[0]["UserID"] + "'").ToString(); }
                        catch (Exception) { }
                        result = gongsiname;
                    }
                }
                return result;
            }
            else
            {
                return null;
            }
        }
        catch (Exception) { return "没有此信息!"; }

    }

 

 private void Bind()
    {
        btnDelete.Attributes.Add("onclick", "javascript:return confirm('你确认要删除吗?')");
        string strURl = Request.RawUrl;
        strURl = strURl.Substring(0, strURl.IndexOf(".aspx")) + ".aspx";
        PageNo1.Strurl = strURl;
        string strWhere = "";
        PageNo1.Table = "W_VisitorRequest";
        PageNo1.FldName = "AddDate";
        PageNo1.StrGetFields = "W_VisitorRequest.*";
        PageNo1.PageSize = 12;
        if (Request.QueryString["page"] != null && Request.QueryString["page"] != "")
        {
            PageNo1.Pageindex = Convert.ToInt32(Request.QueryString["page"].ToString());
            if (Session["strWhere"] != null)
                strWhere = Session["strWhere"].ToString();
            PageNo1.Where = strWhere;
            DataTable dt = PageNo1.BindViewDesc();
            if (dt.DefaultView.Count == 0)
            {
                lblMessage.Visible = true;
                lblMessage.Text = "暂无数据信息";
            }
            else
                lblMessage.Visible = false; 
            gvProducts.DataSource = dt.DefaultView;
            gvProducts.DataBind();
        }
        else {
            PageNo1.Where = "";
            Session["strWhere"] = "";
            PageNo1.Pageindex = 1;
            DataTable dt = PageNo1.BindViewDesc();
            if (dt.DefaultView.Count == 0)
            {
                lblMessage.Visible = true;
                lblMessage.Text = "暂无数据信息";
            }
            else
                lblMessage.Visible = false;
            gvProducts.DataSource = dt.DefaultView;
            gvProducts.DataBind();
        }
    }

 

posted @ 2011-11-18 14:25  ElaineHappy  阅读(288)  评论(0编辑  收藏  举报