我现在的数据源是SqlDataReader(通过执行相应的存储过程返回到此SqlDataReader)中,怎么将其数据源绑定到Repeater上呢??
我知道将SqlDataAdapter绑定到Repeater上的方法,如
SqlDataAdapter myCommand = new SqlDataAdapter("SELECT * FROM info" ,myConnection);
DataSet ds = new DataSet();
myCommand.Fill(ds);
MyRepeater.DataSource = ds;
MyRepeater.DataMember = "info";
MyRepeater.DataBind();
前面用<%# DataBinder.Eval(Container.DataItem, "name") %>调用。
我知道将SqlDataAdapter绑定到Repeater上的方法,如
SqlDataAdapter myCommand = new SqlDataAdapter("SELECT * FROM info" ,myConnection);
DataSet ds = new DataSet();
myCommand.Fill(ds);
MyRepeater.DataSource = ds;
MyRepeater.DataMember = "info";
MyRepeater.DataBind();
前面用<%# DataBinder.Eval(Container.DataItem, "name") %>调用。
<%@Import Namespace="System.Data.SqlClient"%><script runat=server language=c#>void Page_Load()
{
SqlConnection conPubs;
SqlCommand cmdSelect;
SqlDataReader dtrAuthors;conPubs = new SqlConnection( "server=localhost;uid=sa;pwd=;database=Pubs" );
cmdSelect = new SqlCommand( "Select * From Authors",conPubs );
conPubs.Open();
dtrAuthors = cmdSelect.ExecuteReader();rptAuthors.DataSource = dtrAuthors;
rptAuthors.DataBind();dtrAuthors.Close();
conPubs.Close();
}</script><html>
<head><title>Repeater.aspx</title></head>
<body>
<form runat=server><asp:Repeater
ID="rptAuthors"
runat=server><ItemTemplate>
<%#DataBinder.Eval(Container.DataItem, "au_lname")%>
</ItemTemplate></asp:Repeater></form>
</body>
</html>