List<object> CategoryIdRaw = new List<object>(); List<string> categoryId = new List<string>(); DataTable dt = ds.Tables[0]; foreach (DataRow row in dt.Rows) { foreach (DataColumn col in dt.Columns) { CategoryIdRaw.Add(row[col]); } } for (int i = 0; i < CategoryIdRaw.Count; i++) { categoryId.Add(Convert.ToString(CategoryIdRaw[i])); i = i + 2; } ///////////////////////////////////////////// DataSet ds2 = new DataSet(); for (int i = 0; i < categoryId.Count; i++) { string Qbanner = "SELECT [BannerId],[BannerName],[Image1],[ExpiryDate],[Discount],[Offer],[BeautyServices],[TermsCondition],[Status],[CityId],[StateId],[Address],[Remarks],[CategoryId],[UserId],[Bdate] FROM [Groupon].[dbo].[Banner] where CategoryId=" + categoryId[i]; ds2 = conn.FillDataSet(CommandType.Text, Qbanner); GridView1.DataSource = ds2; GridView1.DataBind(); } i was trying something like that; ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ <pre><Columns><asp:TemplateField><ItemTemplate> <div class="deal_sec"> <p class="deal_txt1">Valid upto: <span><asp:Literal ID="LexDate" Mode="Transform" Text='<%# Eval("ExpiryDate") %>' runat="server"></asp:Literal></span></p> <p class="deal_txt2"> <asp:Literal ID="Laddress" Text='<%# Eval("Address") %>' Mode="Transform" runat="server"></asp:Literal> </p> <%--<img src="images/spa_img1.jpg" alt="" title="" />--%> <asp:Image CommandArgument='<%# Eval("BannerId") %>' Height="155px" Width="299px" ImageUrl='<%# "~/Handler2.ashx?id="+Eval("BannerId") %>' ID="Image1" runat="server" /> <p class="deal_txt3">rem ipsum dolor</p> <p class="deal_txt4"> <asp:Literal ID="LtAndC" Mode="Transform" Text='<%# Eval("TermsCondition") %>' runat="server"></asp:Literal></p> </div> <div class="deal_sec deal_gap"> <p id="pValidity2" runat="server" title='<%# Eval("ExpiryDate") %>' class="deal_txt1">Valid upto: <span>31-Aug-2013</span></p> <p id="pLocation2" runat="server" title='<%# Eval("Address") %>' class="deal_txt2">Lorem ipsum dolor </p> <%--<img src="images/spa_img2.jpg" alt="" title="" />--%> <asp:Image CommandArgument='<%# Eval("BannerId") %>' Height="155px" Width="299px" ImageUrl='<%# "~/Handler2.ashx?id="+Eval("BannerId") %>' ID="Image2" runat="server" /> <p class="deal_txt3">Lorem ipsum dolor</p> <p id="pDescription2" runat="server" title='<%# Eval("TermsCondition") %>' class="deal_txt4">Lorem ipsum dolor sit amet, consectetur adipis cing elit. Quisque porttitor</p> </div> <div class="deal_sec deal_gap"> <p id="pValidity3" runat="server" title='<%# Eval("ExpiryDate") %>' class="deal_txt1">Valid upto: <span>31-Aug-2013</span></p> <p id="pLocation3" runat="server" title='<%# Eval("Address") %>' class="deal_txt2">Lorem ipsum dolor </p> <%--<img src="images/spa_img3.jpg" alt="" title="" />--%> <asp:Image CommandArgument='<%# Eval("BannerId") %>' Height="155px" Width="299px" ImageUrl='<%# "~/Handler2.ashx?id="+Eval("BannerId") %>' ID="Image3" runat="server" /> <p class="deal_txt3">Lorem ipsum dolor</p> <p id="pDescription3" runat="server" title='<%# Eval("TermsCondition") %>' class="deal_txt4">Lorem ipsum dolor sit amet, consectetur adipis cing elit. Quisque porttitor</p> </div> </ItemTemplate> </asp:TemplateField> </Columns>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)