HOW can i fill texts in labels in a gridview from different rows of same table in db ,

Question

1.00/5 (2 votes)

See more:

SQL-Server-2008

, +

i mean is there any simple way i may do it but sure it will reduce performance drastically, help please;

 List&lt;object> CategoryIdRaw = new List&lt;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:&nbsp;&nbsp;<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:&nbsp;&nbsp;<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:&nbsp;&nbsp;<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>

Posted 8-Sep-13 5:32am

varun150

Updated 8-Sep-13 6:58am

v3

Add a Solution

Comments

[no name] 8-Sep-13 11:38am

How would you expect us to know? I do not see a single label, gridview, row, table or anything else you mentioned in any of the code that you posted that you say you are having some sort of trouble with.

Sergey Alexandrovich Kryukov 8-Sep-13 11:47am

What's the problem? http://whathaveyoutried.com so far?
—SA

varun150 8-Sep-13 12:38pm

lolz i thought u'd give me some general idea , atleast u'd tell it even possible or not but okk i understand you

varun150 8-Sep-13 12:41pm

lolz .....i thought u'd give me some general idea at least whether it was possible or not. but okk i try to put some code here

Sergey Alexandrovich Kryukov 8-Sep-13 15:03pm

Of course it's possible. The general idea? Apply separation of concerns: database is one thing, UI is another one. In many controls, it's the best to use available binding, but as you managed to create several unrelated labels (why, by the way? wouldn't it be better to review your UI design to make it more regular and "bindable"? I don't say you must though, it depends...), you should fetch data separately, and assign values to correspondent Label.Text properties separately.
—SA

varun150 8-Sep-13 23:31pm

thanks but how to load images from different rows(but 3 in number) of same table in same gridview , do i really need image handler ,if yes then what value should i pass to handeller , or can be be done by without image handler .......please i m stuc

varun150 8-Sep-13 13:01pm

i need these three images on gridview from different rows of same table

varun150 10-Sep-13 13:35pm

i found some other way to do it, thank you so much for your try;

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

varun150 · Answer 1 · 2013-09-10T07:36:00

Solution 1

i found some other way to do it, thank you so much for your try;

Posted 10-Sep-13 7:36am

varun150