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

enter image description here

thanks

i changed use listview instead of repeater , worked great!


Comments

Popular posts from this blog

windows - Single EXE to Install Python Standalone Executable for Easy Distribution -

c# - Access objects in UserControl from MainWindow in WPF -

javascript - How to name a jQuery function to make a browser's back button work? -