ASP.NET

17-Nov-10 4:22

Hi,

I am using repeater and i am pulling data from the datatable which itself is pulling data from the string arrays. My datatable and the repeater code is like this:

DataTable dt = new DataTable();
                   dt.Columns.Add("ID");
                   dt.Columns.Add("Name");
                   dt.Columns.Add("Year");

and the repeater code is like this:

DataView dv = dt.DefaultView;
                   rpt1.DataSource = dv;
                   rpt1.DataBind();

where rpt1 denotes repeater.
The ascx code for repeater is like this:

<asp:Repeater ID = "rpt1" runat="server" 
    onitemdatabound="rpt1_ItemDataBound" 
    onitemcommand="rpt1_ItemCommand" >
    <ItemTemplate>
        <asp:Label ID = "lbl_Year" runat="server" Text='<%# Eval("Year") %>'/></li>
         <asp:Label ID = "lbl_Name" runat="server" Text='<%# Eval("Name") %>'/>
         <asp:Label ID = "lbl_ID" runat="server" Text='<%# Eval("ID") %>' />
    </ItemTemplate>
    
    </asp:Repeater>

There is no problem in the output. It is showing data. But Now I want these data based on the Year. Like "Year" as a title and under that Name and ID should display. Any ideas??

suchita

Not Active17-Nov-10 5:35

17-Nov-10 5:35

Not exactly sure what you want but if you want to show the name and id labels below the year then use the br tag not li.

If you want year to be an expandable section then you have a bit more work.

I know the language. I've read a book. - _Madmatt

Dhyanga17-Nov-10 5:58

17-Nov-10 5:58

No not that kind. Well there are Year data like "2007", "2008","2009","2010" and the Name and ID are unique. So I want to show some think like this:

My datatable has data like this:

Year Name ID
2007 Architecture arc1
2008 Architecture arc2
2009 Architecture arc3
2010 Architecture arc2
2007 Engineering eng1
2008 Engineering eng2
2008 science sci2
2009 science sci3
2010 Engineering eng4
2010 science sci4

And i wanted to show like the one shown below:

2007
Architecture arc1
Engineering eng1

2008
Architecture arc2
Engineering eng2
science sci2

2009
science sci3

2010
Architecture arc4
Engineering eng4
science sci4

suchita

Not Active17-Nov-10 6:59

A quick guide to using nested repeaters in ASP.NET[^]

17-Nov-10 6:59

I know the language. I've read a book. - _Madmatt

Dhyanga18-Nov-10 9:48

18-Nov-10 9:48

Hi Mark,

I got problems when using nested repeater. Well if i dont use nested repeater, the parent repeater is getting data from the datatable but when i use nested repeater under that parent repeater, data count in parent repeater is showing zero for the same user. i even break point in all the steps and the datacount is zero when i use the nested repeater. I dont know why is that happening .. Frown | :(

suchita

Not Active18-Nov-10 14:31

Re: using nested repeater [modified]

18-Nov-10 14:31

Without seeing what you are doing how can anyone possibly answer? The repeater doesn't change your data.

I know the language. I've read a book. - _Madmatt

Dhyanga19-Nov-10 2:59

19-Nov-10 2:59

Ok. Let me show whatever I did so far.

I am using repeater and i am pulling data from the datatable which itself is pulling data from the string arrays. My datatable and the repeater code is like this:

DataTable dt = new DataTable();
dt.Columns.Add("ID");
dt.Columns.Add("Name");
dt.Columns.Add("Year");

foreach (string se in sec)
                       {
                           DataRow dr = dt.NewRow();
                           Name[] sf = Name.FindByID(se.ID);
                           dr["ID"] = se.ID;
                           dr["Name"] =  se.Name;
                           dr["Year"] = se.Term;
                           dt.Rows.Add(dr);
                       }

and the repeater code is like this:

DataView dv = dt.DefaultView;
rptParent.DataSource = dv;
rptParent.DataBind();

where rptParent denotes repeater.
The ascx code for repeater is like this:

<asp:Repeater ID = "rptParent" runat="server"
   onitemdatabound="rptParent_ItemDataBound"
   onitemcommand="rptParent_ItemCommand" >
       <ItemTemplate>
           <li>
               <asp:Label ID = "lbl_Year" runat="server" Text='<%# Eval("Year") %>'/>
           </li>
           <asp:Repeater ID = "rptChild" runat="server" >
               <ItemTemplate>
                   <ul>
                       <li>
                           <asp:LinkButton ID ="lnk_Name" runat="server" Text='<%# Eval("Name") %>' CommandName = "GoToPage" CommandArgument ='<%# Eval("ID") %>'/>
                       </li>
                   </ul>
               </ItemTemplate>
           </asp:Repeater>

       </ItemTemplate>

   </asp:Repeater>

And corresponding databound code is:

protected void rptParent_ItemDataBound(object sender, RepeaterItemEventArgs e)
        {
            RepeaterItem item = e.Item;
           
                rptChild = (Repeater)item.FindControl("rptChild");
                DataRowView drv = (DataRowView)item.DataItem;
                rptChild.DataSource = drv.CreateChildView("rptParent");
                rptChild.DataBind();
           
        }

Now when i don't use rptChild repeater, all the data is showing . No problem with that. But when I use rptChild repeater as shown in above codes, data is not showing. I tried it using breakpoint too. No error but it is not showing any data count in rptParent repeater.I tried this using

rptParent.Items.Count

.

The count is 4 when i run the program without child repeater but it is 0 when i run the program with the child repeater. Can you tell me why this happens and how can I get out of this error ?

suchita

modified on Friday, November 19, 2010 9:23 AM

Dhyanga19-Nov-10 4:22

19-Nov-10 4:22

Hey,

I found the error.
when i the cursor comes to this code

rptChild.DataSource = drv.CreateChildView("rptParent");

it throws the exception.
It said "The relation is not parented to the table to which the Dataview points" .

But what can be done in this case ? Any ideas ??

suchita

Not Active19-Nov-10 10:42

19-Nov-10 10:42

It helps quite a lot when you learn to use the debugger.

The exception is very obvious, you have not create a relationship. How does the framework know the data in a DataTable has any relationhip unless you tell it. Software development isn't magic.

http://msdn.microsoft.com/en-us/library/0k21zcyx(v=VS.100).aspx[^]

Reading the documentation and understanding the tools you are working will help great deal.

I know the language. I've read a book. - _Madmatt

Dhyanga23-Nov-10 5:19

23-Nov-10 5:19

I got it working now. My problem is solved. Thank you Mark.

suchita

Not Active23-Nov-10 5:28