conditions in a repeater

[college_amy]

I am using a repeater and a dataset to retrieve / display data from a database.

 

The data consists of a few fields one of which being a Type field that contains either a 0 or a 1 depending on the type of data in the record.

 

I want, with only the one trip to the db, to extract all the records. Which I did. But after the records are retrieved, I want to sort them based on type and only certain rows be displayed in a certain format with the repeater.

 

For example:

 

<asp:repeater>

 

<itemtemplate>

 

<tr <%databinder stuff �type� == 1%>>

 

<td>Type 1 Name:<%databinder stuff �name�%> *only those names with type=1 display here </td>

 

</tr>

 

<tr <%databinder stuff �type� == 0%>>

 

<td>Type 0 Name: <%databinder stuff �name� %> *only those names with type=0 display here </td>

 

</tr>

 

</itemtemplate>

 

</asp:repeater>

 

 

 

The condition is where I am having the problem. Because the data is arranged in such a way, I am having difficulty displaying the data with conditions. I only want the names of a certain person to show in the first row if their type == 1. Like wise for the second row I only want them to show the names of the people who�s types are 0.

 

I know there is a bunch of stuff missing from the above example � but I do have it all there in the code. I hope you understand and know a solution for this without making numerous trips to the db and without having multiple repeaters.

 

Any help is appreciated.

[college_amy]

Found my own answer - so if anyone else needs it... here it is:

<asp:TableRow runat=server Visible='<%#(DataBinder.Eval(Container.DataItem, "Conditional_field_if_int").ToString()=="1")%>' >

<asp:TableCell Runat="server">Name:

</asp:TableCell>

<asp:TableCell Runat="server"><%# DataBinder.Eval(Container.DataItem, "Name") %></asp:TableCell>

<asp:TableCell Runat="server">Email:</asp:TableCell>

<asp:TableCell Runat="server"><%# DataBinder.Eval(Container.DataItem, "Email") %></asp:TableCell>

<asp:TableCell Runat="server">Phone:</asp:TableCell>

<asp:TableCell Runat="server"><%# DataBinder.Eval(Container.DataItem, "Phone") %></asp:TableCell>

</asp:TableRow>

 

The conditional field that i am checking in dataset is of type int. So it must be converted to a string before I can check to see if the two match.

Hope that helps someone else.