c# - get dataItem from asp.net repeater and display on frontend code -
i dont asp.net learning curve me , little stuck know should easy if know how apologies in advance:
below c#:
rptlistingallmandatorycourses.datasource = listingallmandatorycourses(); rptlistingallmandatorycourses.databind(); public dataset listingallmandatorycourses() { dataset dataset = new dataset(); user user = (user)context.items["currentuser"]; sqlconnection selectconnection = new sqlconnection(configurationsettings.appsettings["dbconnectstr"]); sqldataadapter adapter = new sqldataadapter("dbo.proccataloguesgetallcoursesbycategory", selectconnection); adapter.selectcommand.commandtype = commandtype.storedprocedure; // results adapter.selectcommand.parameters.add("@filterbydomain", sqldbtype.bit).value = 0; if (user.domain.guid != guid.empty) { adapter.selectcommand.parameters.add("@domainid", sqldbtype.uniqueidentifier).value = user.domain.guid; } adapter.selectcommand.parameters.add("@limit", sqldbtype.int).value = 5; adapter.selectcommand.parameters.add("@filterbydomain", sqldbtype.bit).value = 0; adapter.selectcommand.parameters.add("@culture", sqldbtype.varchar, 6).value = "en-gb"; adapter.selectcommand.parameters.add("@isenabled", sqldbtype.bit).value = null; adapter.selectcommand.parameters.add("@domainadminid", sqldbtype.uniqueidentifier).value = null; adapter.selectcommand.parameters.add("@category", sqldbtype.uniqueidentifier).value = "carousel"; adapter.selectcommand.parameters.add("@userid", sqldbtype.uniqueidentifier).value = null; try { dataset = new dataset(); adapter.fill(dataset); } catch (exception exception) { dataset.dispose(); dataset = null; lms_db.lms_db.logerrorevent(exception.message, auditentrytype.cataloguecoursesgetcourses); } { if (selectconnection.state == connectionstate.open) { selectconnection.close(); } } return dataset; } protected void rptlistingallmandatorycourses_itemdatabound(object sender, repeateritemeventargs e) { datarowview row = (datarowview)e.item.dataitem; }
frontend part:
<asp:repeater id="rptlistingallmandatorycourses" runat="server" onitemdatabound="rptlistingallmandatorycourses_itemdatabound"> <itemtemplate> <%#databinder.eval(container.dataitem, "coursetitle")%> </itemtemplate> </asp:repeater>
page loads fine no errors cannot see data.... ive checked procedure , can see data coming coursetitle not seem passing aspx template? ideas anyone?
screenshot results when run db query in db
thanks
i changed use listview instead of repeater , worked great!
Comments
Post a Comment