aspx页面中代码段:
<asp:repeater id="Repeater1" runat="server">
<ItemTemplate>
<%# DataBinder.Eval(Container.DataItem,"LastName")%>
<%# DataBinder.Eval(Container.DataItem,"FirstName")%>
</ItemTemplate>
</asp:repeater>CS页面中:
if(!IsPostBack)
{
string myconn="server=.;DataBase=northwind;uid=sa;pwd=;";
string sel="selcet * from employees";
DataSet ds=new DataSet();
SqlConnection con=new SqlConnection(myconn);
con.Open();
SqlDataAdapter sda=new SqlDataAdapter(sel,con);
sda.Fill(ds,"employeeID");
this.Repeater1.DataSource=ds.Tables["employeeID"];
this.Repeater1.DataBind();
}数据库用的是sqlserver自带的northwind,老是提示sda.Fill(ds,"employeeID");
有朋友说数据库连接没打开,怎么打开?最好把这个例子补齐代码,谢谢。
<asp:repeater id="Repeater1" runat="server">
<ItemTemplate>
<%# DataBinder.Eval(Container.DataItem,"LastName")%>
<%# DataBinder.Eval(Container.DataItem,"FirstName")%>
</ItemTemplate>
</asp:repeater>CS页面中:
if(!IsPostBack)
{
string myconn="server=.;DataBase=northwind;uid=sa;pwd=;";
string sel="selcet * from employees";
DataSet ds=new DataSet();
SqlConnection con=new SqlConnection(myconn);
con.Open();
SqlDataAdapter sda=new SqlDataAdapter(sel,con);
sda.Fill(ds,"employeeID");
this.Repeater1.DataSource=ds.Tables["employeeID"];
this.Repeater1.DataBind();
}数据库用的是sqlserver自带的northwind,老是提示sda.Fill(ds,"employeeID");
有朋友说数据库连接没打开,怎么打开?最好把这个例子补齐代码,谢谢。
{
string myconn="server=.;DataBase=northwind;uid=sa;pwd=;";
string sel="selcet * from employees";
DataSet ds=new DataSet();
SqlConnection con=new SqlConnection(myconn);
con.Open();
SqlDataAdapter sda=new SqlDataAdapter(sel,con);
sda.Fill(ds,"employeeID");
this.Repeater1.DataSource=ds.Tables[0];
this.Repeater1.DataBind();
}
--------------------------------------------------------------
程序,犹如人生。
sda.Fill(ds,"employeeID");这句出错;
cangwu_lee(小橙子) 的方法还是行不通
string myconn="server=.;DataBase=northwind;uid=sa;pwd=;";
string sel="select * from employees";
DataSet ds=new DataSet();
SqlConnection con=new SqlConnection(myconn);
//con.Open();
SqlDataAdapter sda=new SqlDataAdapter(sel,con);
sda.Fill(ds,"employeeID");
this.Repeater1.DataSource=ds.Tables["employeeID"];
this.Repeater1.DataBind();