母版页如何绑定数据？

Question

master页面
前台
 <asp:contentplaceholder id="head"  runat="server">
   
 <div id="tabsF">
  
   <ul id="nav" style="position:absolute;left:113px;top:0px;border:red 1px sollolida" > 
<asp:Repeater id="Repeater1" runat="server"> 
<ItemTemplate>     <li><a onclick="headTextBG(); "  href="<%#Eval("url")%>" target="left"  title=""><span><%#Eval("span")%></span></a></li>
</ItemTemplate> 
</asp:Repeater> 
</ul>
  <div id="b"  style="position:absolute;left:20px;top:5px;border:black 1px solid">
  <input id="op" onclick="switchSysBar()" type="button" value="隱藏" runat="server">
  <input type="image" src="images/pre.gif" id="pre" width="20px" height="20px" align=absMiddle    onclick="return prepage()">
  <input type="image"  src="images/next.gif" id="next" width="20px" height="20px" align=absMiddle  onclick="return nextpage()" >  </div></div>
<br/><br/>
<script  type="text/javascript"   src="js/header.js"></script> 
        </asp:contentplaceholder>后台master.vb页面
Imports System
Imports System.Data
Imports System.Configuration
Imports System.Collections
Imports System.Web
Imports System.Web.Security
Imports System.Web.UI
Imports System.Web.UI.WebControls
Imports System.Web.UI.WebControls.WebParts
Imports System.Web.UI.HtmlControls
Imports System.Data.SqlClient
Imports System.IOPartial Class MasterPage
    Inherits System.Web.UI.MasterPage    Protected Sub head_Load(ByVal sender As Object, ByVal e As EventArgs) Handles head.Load
         DatabindG()    End Sub
     Private Sub DatabindG()
    head.Repeater1.DataSource = SqlHelper.ExcuteReadApdater("select * from c_MenuHeader", CommandType.Text, Nothing)//这样绑定行不行？    head.Repeater1.DataBind()//这样绑定行不行？
    End Sub
End Class

Answer 1

你在Load里绑定就行了或者在 Page_PreRender(object sender, EventArgs e) {}绑定也行,这个事件需要自己添加,如:
        protected void Page_PreRender(object sender, EventArgs e) {
             Repeater1.DataSoure="":
             Repeater1.DataBind();
        }
我这是C#语言,VB应该有同样的动作

Answer 2

后置文件里写  这是我帮TREE的using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Collections.Generic;
using System.Data.SqlClient;public partial class MasterPage : System.Web.UI.MasterPage
{
static string connectString = @"SERVER=.\SQLEXPRESS;DataBase=TestDB;uid=sa;pwd=ok";
    protected void Page_Load(object sender, EventArgs e)
    {
if (!IsPostBack)
{
List<DeptInfo> list = GetList();
SetTvTest(list);
}
    } private void SetTvTest(List<DeptInfo> list)
{
foreach (DeptInfo model in list)
{
if (model.FatherId == 0)
{
TreeNode node = new TreeNode();
node.Text = model.Name;
node.Value = model.Id.ToString();
node.NavigateUrl = "~/Default" + model.Id.ToString() + ".aspx";
this.tvTest.Nodes.Add(node);
} }
foreach (DeptInfo dept in list)
{
if (dept.FatherId != 0)
{ 
TreeNode node = new TreeNode();
node.Text = dept.Name;
node.Value = dept.Id.ToString();
node.NavigateUrl = "~/Default"+dept.Id.ToString()+".aspx";
SetNodes(dept,node,this.tvTest.Nodes);
}
}
} public void SetNodes(DeptInfo dept,TreeNode node,TreeNodeCollection sumNodes)
{ 
for(int i = 0;i<sumNodes.Count;i++)
{
TreeNode no = sumNodes[i];
if (dept.FatherId.ToString().Equals(no.Value))
{
no.ChildNodes.Add(node);
}
else
{
SetNodes(dept,node,sumNodes[i].ChildNodes);
}
}
} public List<DeptInfo> GetList()
{
string sql = "select * from Department";
List<DeptInfo> list = new List<DeptInfo>();
SqlDataReader dr = ExecuteReader(sql);
if (dr.HasRows)
{
while (dr.Read())
{
DeptInfo model = new DeptInfo();
model.Id = int.Parse(dr[0].ToString());
model.Name = dr[1].ToString();
model.Address = dr[2].ToString();
model.FatherId = int.Parse(dr[3].ToString());
list.Add(model);
}
}
return list;
} public SqlDataReader ExecuteReader(string sql)
{
SqlCommand cmd = new SqlCommand(sql);
cmd.Connection = new SqlConnection(connectString);
cmd.Connection.Open();
SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
return dr;
}
protected void tvTest_SelectedNodeChanged(object sender, EventArgs e)
{
//Session["id"]=tvTest.SelectedNode.Value;
}
}

Answer 3

前台:
<asp:GridView runat="server" ID="gv_List" BorderWidth="0px" Width="100%" CellPadding="0" AutoGenerateColumns="False" DataKeyNames="Orde_Id" OnRowDataBound="gv_List_RowDataBound">
    <Columns>
        <asp:BoundField DataField="MerCount" HeaderText="在途数量" />
        <asp:BoundField DataField="DataState" HeaderText="状态" />
        <asp:HyperLinkField DataNavigateUrlFields="Orde_Id,Orde_Code" DataNavigateUrlFormatString="frm_OrderFormView.aspx?id={0}"
            DataTextField="Orde_Code" HeaderText="订号" />
        <asp:BoundField DataField="Prov_Name" HeaderText="工厂" />
        <asp:BoundField DataField="Depo_Name" HeaderText="仓库" />
        <asp:BoundField DataField="Orde_TotalNumber" HeaderText="总量" />
        <asp:BoundField DataField="Orde_TotalMoney" HeaderText="总额" />
        <asp:BoundField DataField="Orde_Re" HeaderText="备注" />
        <asp:BoundField DataField="Orde_PlanInputTime" HeaderText="拟入" DataFormatString="{0:yyyy-MM-dd}" HtmlEncode="False" />
        <asp:TemplateField HeaderText="状态">
            <ItemTemplate>
               <asp:Button ID="imgState" OnClientClick="return false" runat="server" />
            </ItemTemplate>
        </asp:TemplateField>
        <asp:BoundField DataField="JoinDate" HeaderText="日期" DataFormatString="{0:yyyy-MM-dd}" HtmlEncode="False" />
        <asp:BoundField DataField="Orde_LastEditDate" HeaderText="修改" DataFormatString="{0:yyyy-MM-dd}" HtmlEncode="False" />
        <asp:BoundField DataField="Orde_FinishedDate" HeaderText="完成" DataFormatString="{0:yyyy-MM-dd}" HtmlEncode="False" />
        <asp:BoundField DataField="Empl_Name" HeaderText="制单" />
    </Columns>     
</asp:GridView>后台:
        protected void gv_List_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            try
            {
                if (e.Row.RowType == DataControlRowType.DataRow)
                {
                    Button img = e.Row.FindControl("imgState") as Button;
                    if (e.Row.Cells[0].Text != "&nbsp;" && e.Row.Cells[0].Text != "")
                    {
                        img.Visible = true;
                        if (Int32.Parse(e.Row.Cells[0].Text) > 0)
                        {
                            img.CssClass = "button-17over";
                            img.ToolTip = "在途";
                            e.Row.Attributes["available"] = "bnEdit|bnDelete|bnEnd";
                            e.Row.Attributes["disavailable"] = "";
                        }
                        else
                        {
                            if (Int32.Parse(e.Row.Cells[1].Text) == 0 && Int32.Parse(e.Row.Cells[1].Text) != 3)
                            {
                                img.CssClass = "button-17home";
                                img.ToolTip = "完成";
                                e.Row.Attributes["available"] = "bnEdit|bnDelete|bnEnd";
                                e.Row.Attributes["disavailable"] = "";
                            }
                            else if (Int32.Parse(e.Row.Cells[1].Text) == 3)
                            {
                                img.CssClass = "button-25bought";
                                img.ToolTip = "结束";
                                e.Row.Attributes["available"] = "";
                                e.Row.Attributes["disavailable"] = "bnEdit|bnDelete|bnEnd";
                            }
                            else
                            {
                                img.Visible = false;
                            }
                        }
                    }
                    else
                    {
                        img.Visible = false;                    }
                }
            }
            catch (Exception ex)
            {
                SysLog.Add(ex.Message.ToString(), ex.ToString(), SysLogType.Error);
                PageControl.ShowMessageByPage(ERetrunValue.Unknonw, "", "frm_ErrorPage.aspx");
            }
        }

Answer 4

顶一下，其实ＶＢ跟Ｃ＃相差也不是很大。 <asp:contentplaceholder，看楼主，绑定的控件是放在内容页中吧，这个倒不是很清楚了，以前处理类似问题时，要不在内容页中绑定，要么写成一个用户控件……