Advertisement
Guest User

Untitled

a guest
Jul 24th, 2017
42
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.52 KB | None | 0 0
  1. <asp:Content ID='Content1' ContentPlaceHolderID='ContentPlaceHolder1' Runat='Server'>
  2.  
  3. <asp:Repeater ID="Repeater1" runat="server" OnItemDataBound="repeater_ItemDataBound" ItemType="brand" SelectMethod="GetBrandData">
  4. <ItemTemplate>
  5. <div class="one-third">
  6. <div>
  7. <asp:LinkButton ID="linkButton" OnClick="Repeater1_OnClick" runat="server" CommandArgument='<%# Item.brandId %>'>
  8. <asp:Image ID="brandImage" runat="server" height="250px" width="300px" />
  9. </asp:LinkButton>
  10. </div>
  11.  
  12. </div>
  13. </ItemTemplate>
  14.  
  15. protected void Page_Load(object sender, EventArgs e)
  16. {
  17.  
  18. }
  19.  
  20. public void repeater_ItemDataBound(object sender, RepeaterItemEventArgs e)
  21. {
  22. Image img = e.Item.FindControl("brandImage") as Image;
  23. img.ImageUrl = "../Images/Brands/" + ((brand)e.Item.DataItem).image;
  24. }
  25.  
  26. public List<brand> GetBrandData()
  27. {
  28. MusicStoreDBEntities obj = new MusicStoreDBEntities();
  29. List<brand> list = new List<brand>();
  30. list = (from g in obj.brands select g).ToList();
  31.  
  32. return list;
  33.  
  34. }
  35.  
  36. public List<brand> GetBrandData()
  37. {
  38. MusicStoreDBEntities obj = new MusicStoreDBEntities();
  39. List<brand> list = new List<brand>();
  40. list = (from g in obj.brands where g.name=="Ibanez"||g.name=="Fender"||g.name=="Musicman" select g).ToList();
  41.  
  42. return list;
  43.  
  44. }
  45.  
  46. Type
  47. ID
  48. name
  49.  
  50. 1 guitar
  51. 2 bass
  52.  
  53. Brand
  54. ID
  55. name
  56. image
  57.  
  58. TypeBrand
  59. IDtype
  60. IDbrand
  61.  
  62. select Brand.Name
  63. from Brand
  64. join TypeBrand
  65. on Brand.ID = TypeBrand.IDbrand
  66. and TypeBrand.IDtype = 2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement