SqlConnection myconn = new SqlConnection("Data Source=.;Initial Catalog=pubs;Integrated Security=True");
myconn.Open();
string sql = "select * from authors";
SqlDataAdapter sda = new SqlDataAdapter(sql, myconn);
DataTable dt = new DataTable();
sda.Fill(dt);
DataList1.DataSource = dt;
DataList1.DataMember = "authors";
DataList1.DataBind();
myconn.Close();
我这样写了 为什么我运行不能显示数据
myconn.Open();
string sql = "select * from authors";
SqlDataAdapter sda = new SqlDataAdapter(sql, myconn);
DataTable dt = new DataTable();
sda.Fill(dt);
DataList1.DataSource = dt;
DataList1.DataMember = "authors";
DataList1.DataBind();
myconn.Close();
我这样写了 为什么我运行不能显示数据
<asp:DataList ID="DataList1" runat="server">
<ItemTemplate>
摘要:<%# DataBinder.Eval(Container.DataItem, "摘要")%>
科目:<%# DataBinder.Eval(Container.DataItem, "科目")%>
</ItemTemplate>
</asp:DataList>
<!--绑的是后台数据库dt的列名-->
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection myconn = new SqlConnection("Data Source=.;Initial Catalog=pubs;Integrated Security=True");
myconn.Open();
string sql = "select * from authors";
SqlDataAdapter sda = new SqlDataAdapter(sql, myconn);
DataTable dt = new DataTable();
sda.Fill(dt);
DataList1.DataSource = dt;
DataList1.DataMember = "authors";
DataList1.DataBind();
myconn.Close();
}