private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
SqlConnection ArchSqlConn;
SqlDataAdapter ArchSqlADP;
DataSet FileLinkRS = new DataSet();
ArchSqlConn = new SqlConnection("Server=localhost;UID=;Password=;Database=archsql");
ArchSqlConn.Open();
ArchSqlADP = new SqlDataAdapter("select filename from TBLBOOKSUPLOAD",ArchSqlConn);
ArchSqlADP.Fill(FileLinkRS);
FileLinkList.DataSource=FileLinkRS;
FileLinkList.DataBind();
//
//
ArchSqlConn.Close();
}
上面程序中FileLinkList是datalist控件,可是执行下列程序数据在网页上不显示?请高手指点,谢谢!
{
// 在此处放置用户代码以初始化页面
SqlConnection ArchSqlConn;
SqlDataAdapter ArchSqlADP;
DataSet FileLinkRS = new DataSet();
ArchSqlConn = new SqlConnection("Server=localhost;UID=;Password=;Database=archsql");
ArchSqlConn.Open();
ArchSqlADP = new SqlDataAdapter("select filename from TBLBOOKSUPLOAD",ArchSqlConn);
ArchSqlADP.Fill(FileLinkRS);
FileLinkList.DataSource=FileLinkRS;
FileLinkList.DataBind();
//
//
ArchSqlConn.Close();
}
上面程序中FileLinkList是datalist控件,可是执行下列程序数据在网页上不显示?请高手指点,谢谢!
FileLinkList.DataSource=dv;
FileLinkList.DataBind();
如果没显示出来,查看源文件,看看你的控件在html源代码里有没有
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<FONT face="宋体">
<asp:datalist id="FileLinkList" style="Z-INDEX: 101; LEFT: 216px; POSITION: absolute; TOP: 96px"
runat="server" Width="152px" Height="16px" RepeatColumns="1" ShowFooter="False" ShowHeader="False"
GridLines="Vertical" ForeColor="Lime">
<ItemStyle ForeColor="Lime" VerticalAlign="Middle"></ItemStyle>
</asp:datalist></FONT></form>
</body>
你绑定了数据源,确没告诉它显示什么。你还是看看书吧,或者用datagrid吧
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
SqlConnection ArchSqlConn;
SqlDataAdapter ArchSqlADP;
DataSet FileLinkRS = new DataSet();
ArchSqlConn = new SqlConnection("Server=localhost;UID=;Password=;Database=archsql");
ArchSqlADP = new SqlDataAdapter("select FileName from TBLBOOKSUPLOAD",ArchSqlConn);
ArchSqlConn.Open();
ArchSqlADP.Fill(FileLinkRS);
FileLinkList.DataSource=FileLinkRS.Tables[0].DefaultView;
//DataBind();
//Page.DataBind();
//FileLinkList.DataSource=FileLinkRS.Tables[0];
FileLinkList.DataBind();
} <body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<FONT face="宋体">
<asp:datalist id="FileLinkList" style="Z-INDEX: 101; LEFT: 56px; POSITION: absolute; TOP: 16px"
runat="server" RepeatColumns="1">
<SelectedItemTemplate>
</SelectedItemTemplate>
<ItemTemplate>
<asp:HyperLink id=HyperLink1 runat="server" text='<%# DataBinder.Eval(Container.DataItem,"filename")%>' NavigateUrl="dbfilelink.aspx" ForeColor="Lime">
</asp:HyperLink>
</ItemTemplate>
<AlternatingItemTemplate>
</AlternatingItemTemplate>
<EditItemTemplate>
</EditItemTemplate>
</asp:datalist></FONT></form>
</body>
</AlternatingItemTemplate>
=======d多余
但是整个来讲,没有错误。我试过了,
我只是给数据源改成了
SqlConnection ArchSqlConn;
SqlDataAdapter ArchSqlADP;
DataSet FileLinkRS = new DataSet();
ArchSqlConn = new SqlConnection("Server=localhost;UID=sa;Password=;Database=Northwind");
ArchSqlADP = new SqlDataAdapter("select CategoryName from categories",ArchSqlConn);
ArchSqlConn.Open();
ArchSqlADP.Fill(FileLinkRS);
DataList1.DataSource=FileLinkRS.Tables[0].DefaultView;
//DataBind();
//Page.DataBind();
//FileLinkList.DataSource=FileLinkRS.Tables[0];
DataList1.DataBind();
--界面绑定改成categoryname,完全正常。