datalist控件怎么都显示不出数据,急死!
我写了一个index.aspx页,和一个introduce.ascx页,两者是引用与被引用的关系。已经知道引用控件这个环节上没有出错,我想应该是关于datalist的代码出了问题吧,请帮忙看下:
index.aspx
<%@ Page language="c#" Codebehind="index.aspx.cs" AutoEventWireup="false" Inherits="netsql.index" %>
<%@ Register TagPrefix="introduce" TagName="introduce" Src="introduce.ascx" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<html>
<head>
<title>index</title>
<meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" Content="C#">
<meta name=vs_defaultClientScript content="JavaScript">
<meta name=vs_targetSchema content="http://schemas.microsoft.com/intellisense/ie5">
</head>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<introduce:introduce runat="server" />
</form>
</body>
</html>
introduce.ascx
<%@ Control Language="c#" AutoEventWireup="false" Codebehind="introduce.ascx.cs" Inherits="netsql.introduce" TargetSchema="http://schemas.microsoft.com/intellisense/ie5"%>
<asp:TextBox id="TextBox1" runat="server">1111111</asp:TextBox>
<asp:DataList id="DataList1" runat="server" CellPadding="9" HorizontalAlign="Center" RepeatColumns="4"
RepeatDirection="Horizontal" Width="98%">
<ItemTemplate>
<table>
<td>
<td><%#DataBinder.Eval(Container.DataItem, "id") %></td>
</td>
<td>姓名:</td>
<td>
<%#DataBinder.Eval(Container.DataItem,"name") %>
</td>
</table>
</ItemTemplate>
</asp:DataList>
introduce.ascx.cs
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
/// <summary>
/// introduce 的摘要说明。
/// </summary>
public class introduce : System.Web.UI.UserControl
{
protected System.Web.UI.WebControls.DataList DataList1;
protected System.Web.UI.WebControls.TextBox TextBox1;
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if(!IsPostBack)
{
DataListDataBind();
}
}
private void DataListDataBind()
{
SqlConnection myConnection = new SqlConnection("workstation id=localhost;Integrated Security=SSPI;database=test");
SqlDataAdapter dr = new SqlDataAdapter ("select * from test",myConnection);
DataSet ds = new DataSet ();
dr.Fill(ds,"table");
DataList1.DataSource = ds.Tables["table"].DefaultView;
DataList1.DataBind();
}
-----------------------------------------------
数据库是sql数据库,test数据库-test表-id,name字段。