Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <asp:Content ID='Content1' ContentPlaceHolderID='ContentPlaceHolder1' Runat='Server'>
- <asp:Repeater ID="Repeater1" runat="server" OnItemDataBound="repeater_ItemDataBound" ItemType="brand" SelectMethod="GetBrandData">
- <ItemTemplate>
- <div class="one-third">
- <div>
- <asp:LinkButton ID="linkButton" OnClick="Repeater1_OnClick" runat="server" CommandArgument='<%# Item.brandId %>'>
- <asp:Image ID="brandImage" runat="server" height="250px" width="300px" />
- </asp:LinkButton>
- </div>
- </div>
- </ItemTemplate>
- protected void Page_Load(object sender, EventArgs e)
- {
- }
- public void repeater_ItemDataBound(object sender, RepeaterItemEventArgs e)
- {
- Image img = e.Item.FindControl("brandImage") as Image;
- img.ImageUrl = "../Images/Brands/" + ((brand)e.Item.DataItem).image;
- }
- public List<brand> GetBrandData()
- {
- MusicStoreDBEntities obj = new MusicStoreDBEntities();
- List<brand> list = new List<brand>();
- list = (from g in obj.brands select g).ToList();
- return list;
- }
- public List<brand> GetBrandData()
- {
- MusicStoreDBEntities obj = new MusicStoreDBEntities();
- List<brand> list = new List<brand>();
- list = (from g in obj.brands where g.name=="Ibanez"||g.name=="Fender"||g.name=="Musicman" select g).ToList();
- return list;
- }
- Type
- ID
- name
- 1 guitar
- 2 bass
- Brand
- ID
- name
- image
- TypeBrand
- IDtype
- IDbrand
- select Brand.Name
- from Brand
- join TypeBrand
- on Brand.ID = TypeBrand.IDbrand
- and TypeBrand.IDtype = 2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement