Hi,
I'm trying to fill my Repeater control with the contents of a query
performed on an OleDB connected database. I keep getting the error...
"No value given for one or more required parameters." - but I can't work out
what parameters where. Can someone help?
<html>...
<asp:Repeater ID="rptLinks" runat="server">
<ItemTemplate>
<%# DataBinder.Eval(Container.DataItem, "site_url") %>
</ItemTemplate>
</asp:Repeater>
c#...
OleDbConnection dbConn = new
OleDbConnection(ConfigurationSettings.AppSettings. Get("System_ConnectionString"));
dbConn.Open();
OleDbCommand siteCmd = new OleDbCommand("SELECT site_name, site_url FROM
sites WHERE band_id = " + bandid, dbConn);
OleDbDataReader siteDR = siteCmd.ExecuteReader();
rptLinks.DataSource = siteDR;
rptLinks.DataBind();
dbConn.Close();
Thanks for any help!
