datalist怎样邦定数据啊

Question

datalist怎样邦定数据啊

Answer 1

DataList1.DataSource=（数据源，可以是datatable，也可以是dataset）
DataList1.DataBind()

Answer 2

<asp:DataList ID="DataList1" runat="server">
            <ItemTemplate>
               <%# DataBinder.Eval(Container.DataItem,"要绑定的字段") %>
            </ItemTemplate>
        </asp:DataList>

Answer 3

if(!this.IsPostBack)
{
// string id=Request.QueryString["id"].ToString();
String strConnection=ConfigurationSettings.AppSettings["ConnectionString"];
SqlConnection myConnection=new SqlConnection(strConnection);
myConnection.Open();
SqlCommand cmd=new SqlCommand("select name from login where id=+'"+id+"'",myConnection);
this.Label1.Text=Convert.ToString(cmd.ExecuteScalar());
cmd.CommandText="select * from login where id='"+id+"'";
SqlDataReader sdr=cmd.ExecuteReader();
this.DataList1.DataSource=sdr;
this.DataList1.DataBind();这样写对吗????

Answer 4

<asp:DataList ID="DataList1" runat="server" DataKeyField="id" DataSourceID="SqlDataSource1"
            OnSelectedIndexChanged="DataList1_SelectedIndexChanged">
            <ItemTemplate>
                id:
                <asp:Label ID="idLabel" runat="server" Text='<%# Eval("id") %>'></asp:Label><br />
                name:
                <asp:Label ID="nameLabel" runat="server" Text='<%# Eval("name") %>'></asp:Label><br />
                lianxi:
                <asp:Label ID="lianxiLabel" runat="server" Text='<%# Eval("lianxi") %>'></asp:Label><br />
                dep:
                <asp:Label ID="depLabel" runat="server" Text='<%# Eval("dep") %>'></asp:Label><br />
                wentilist:
                <asp:Label ID="wentilistLabel" runat="server" Text='<%# Eval("wentilist") %>'></asp:Label><br />
                haoma:
                <asp:Label ID="haomaLabel" runat="server" Text='<%# Eval("haoma") %>'></asp:Label><br />
                youxian:
                <asp:Label ID="youxianLabel" runat="server" Text='<%# Eval("youxian") %>'></asp:Label><br />
                ipaddress:
                <asp:Label ID="ipaddressLabel" runat="server" Text='<%# Eval("ipaddress") %>'></asp:Label><br />
                chuli:
                <asp:Label ID="chuliLabel" runat="server" Text='<%# Eval("chuli") %>'></asp:Label><br />
                sysdate:
                <asp:Label ID="sysdateLabel" runat="server" Text='<%# Eval("sysdate") %>'></asp:Label><br />
                wenti:
                <asp:Label ID="wentiLabel" runat="server" Text='<%# Eval("wenti") %>'></asp:Label><br />
                <br />
            </ItemTemplate>
        </asp:DataList>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:detailsconnection %>"
            OnSelecting="SqlDataSource1_Selecting" SelectCommand="SELECT [id], [name], [lianxi], [dep], [wentilist], [haoma], [youxian], [ipaddress], [chuli], [sysdate], [wenti] FROM [login]">
        </asp:SqlDataSource>
是这样的,我用vs.net2005实现了邦定，能显示数据．但是我现在要实现从Gridview  HyperLinkField的链接<asp:HyperLinkField DataTextField="name"
                    HeaderText="姓名" SortExpression="id" Target="_blank" DataNavigateUrlFormatString="showdetails.aspx?id={0}" DataNavigateUrlFields="id" />

Answer 5

public void Page_Load(Object src, EventArgs e)
    {        
        int CurPage = 0;
        double i = 0;
        if (!IsPostBack)
        {
            string strconn = System.Configuration.ConfigurationManager.ConnectionStrings["intranetConnectionString"].ToString();
            SqlConnection objConn = new SqlConnection(strconn);
            string str = "SELECT [ID], [PCname],(select name from tb_employee where pcname=MessageBoard.pcname)as Name, [InsertDate], [Title], [Content],(SELECT 'true' FROM greetingvote          WHERE id = messageboard.id AND pcname LIKE '" + User.Identity.Name + "') AS choose FROM [MessageBoard] Where Team ='Christmas' order by [InsertDate] desc";
            string temp = "SELECT MessageBoard.ID, MessageBoard.PCname, a.Name AS name,    MessageBoard.Title, MessageBoard.Content,  (SELECT 'true'  FROM greetingvote    WHERE id = messageboard.id AND pcname LIKE '" + User.Identity.Name + "')   AS choose,MessageBoard.InsertDate FROM MessageBoard INNER JOIN   tb_Employee a ON a.PcName = MessageBoard.PCname ORDER BY MessageBoard.InsertDate DESC";            SqlDataAdapter objCommand = new SqlDataAdapter(temp, objConn);
            DataSet ds = new DataSet();
            objCommand.Fill(ds);            //对PagedDataSource 对象的相关属性赋值
            PagedDataSource objPds = new PagedDataSource();
            objPds.DataSource = ds.Tables[0].DefaultView;
            objPds.AllowPaging = true;
            objPds.PageSize = 6;
            //当前页面从Page查询参数获取
            if (Request.QueryString["Page"] != null)
                CurPage = Convert.ToInt32(Request.QueryString["Page"]);
            else
                CurPage = 1;
            i = objPds.DataSourceCount / 6.0;
            if (i - (int)i > 0) i = (int)i + 1;
            if (i == 0) i = 1;            objPds.CurrentPageIndex = CurPage - 1;
            lblTotalPage.Text = "Total: " + i;
            lblCurrentPage.Text = "Page: " + CurPage.ToString();            if (!objPds.IsFirstPage)
                lnkPrev.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage - 1);            if (!objPds.IsLastPage)
                lnkNext.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1);
            lnkFirst.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=1";
            lnkLast.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(i);
            //把PagedDataSource 对象赋给Repeater控件
            this.DataList1.DataSource = objPds;
            DataList1.DataBind();           
        }
}