How do I bind multiple records in div tag using ASP.NET C#

Question

0.00/5 (No votes)

See more:

i also tried OrderByDescending().ToList() method to fetch all the records, but the problem is when i fetch all the records im not able to bind all the records in div tag so that the div tag get incremented according the records.

Also i want to know how to hide some text of blog description with read more link

Please Help me!

Thanks !

What I have tried:

public string author="";
public string blogTitile = "";
public string blogDescription = "";

using(database db = new database())
          {
              var query = (from c in db.table

                           select new
                           {
                               c.id,
                               c.Author,
                               c.BlogTitle,
                               c.BlogDescription
                           }).OrderByDescending(d => d.id).FirstOrDefault();



              author = query.Author;
              blogTitle = query.BlogTitle;
              blogDescription = query.BlogDescription;


                  divImage ="<div class='col-md-6 nopadding hidden-xs'><img src='../images/blog/1.jpg' alt='News Image'><span class='img-overflow'></span><div class='arrow-left'></div></div>";
                  divDetails ="<p class='date'>"+ author+ "</p>"+
                              "<h2>"+ blogTitle+"</h2>"+
                                "<p> "+blogDescription+"</p>"+
                                 "<a href='artikel' class='btn btn-primary btn-xs'>Read More</a>"+
                                "<span class='comments'>0 "></span>";

this is aspx page:

 <div class="row ">
     <div class="col-xs-12">
          <div class="item item-left">
                    <%= divImage %>

         <div class="col-xs-6 ">
              <div class="content">
                        <%=divDetails %>
              </div>
        </div>
    </div>
  </div>
</div>
</div>

Posted 4-Oct-17 2:50am

Umair Nafis

Updated 4-Oct-17 21:22pm

v2

Add a Solution

2 solutions

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)

sachin.vishwa90 · Accepted Answer · 2017-10-04T03:58:00

Solution 1

for read more logic you can search on google. however i am posting answer for this question where you want to loop through records and form the HTML.
Basically in c# code on page_Load method, you will fire query the linq which you have written.
after taking the record you will form the HTML and bind this HTML to a placeholder which is on aspx.
so your aspx code will be

<div id="blogData" runat="server"></div>

and in your pageload you will write below code

var query = (from c in db.table
                            
                            select new
                            {
                                c.id,
                                c.Author,
                                c.BlogTitle,
                                c.BlogDescription
                            }).OrderByDescending(d => d.id)
// got the records. loop through it
System.Text.StringBuilder sb = new System.Text.StringBuilder();
                query.ForEach(x => { sb.Append(string.Format("<div class='row '><div class='col-xs-12'><div class='item item-left'><div class='col-md-6 nopadding hidden-xs'><img src='../images/blog/1.jpg' alt='News Image'><span class='img-overflow'></span><div class='arrow-left'></div></div><div class='col-xs-6 '><div class='content'><p class='date'>{0}</p>'+'<h2>{1}</h2>'+'<p>{2}</p>'+'<a href='artikel' class='btn btn-primary btn-xs'>Read More</a>'+'<span class='comments'>0 '></span></div></div></div></div></div>", x.Author, x.BlogTitle,x.BlogDescription)); });

//sb will have your formed HTML.
// now you will put this html to placeholder div
blogData.InnerHtml = sb.ToString();

note: this is not a tested code you may need to alter it. Best of luck

Posted 4-Oct-17 3:58am

sachin.vishwa90

Comments

Umair Nafis 4-Oct-17 13:58pm

Thanx for the reply sir,
I tried your code but im getting error in ForEach()..are you missing a using directive or assembly reference.

Umair Nafis 4-Oct-17 14:14pm

Thank You so much sir, it works I just used
query.ToList().ForEach(...),,...
Thanks Alott sir.

sachin.vishwa90 4-Oct-17 14:18pm

lol, i was about to reply the same, but do you know why you have to use .ToList there?

Umair Nafis 4-Oct-17 16:27pm

Actually i really dnt knw why i used ToList() here as i dnt what should be the best option to retrieve all the data from database. please correct me if i have better option than ToList(). I just want bind all the data..

Also sir i want to know if have any option to display only limited text in blog description with a read more link..hope u understand.

sachin.vishwa90 5-Oct-17 2:38am

you have used linq statement to select the records from database. so how this linq works is it, whatever you write here in c# code it internally creates a sql statement and when you write .ToList() then it actually fires the sql statement. in earlier case this statement was created but not executed. as soon as you wrote .ToList() it executed the query and brought you data.
for readmore i will post soon.

Umair Nafis 5-Oct-17 13:48pm

Thank You so much sir, you are awesome.
Sir but this method is not working for image binding as u can see here i directly displaying a single image in all blogs but if i use asp image control in this for dynamically bind images, imageId is not detected by the compiler.

Umair Nafis 9-Oct-17 12:02pm

How to bind image of that particular blog in this tag : "" ie The image path is saved in the sqlserver and image in project folder, is it possible to bind those images in this tag? plz tell me i will be very grateful to u sir.

sachin.vishwa90 10-Oct-17 3:13am

hi, that can easily be done too. all you have to do is select the path of those images as well in your select statement as below.
select new
{
c.id,
c.Author,
c.BlogTitle,
c.BlogDescription,
c.ImagePath
}).OrderByDescending(d => d.id)
and then bind this path to the src tag in the string.
sb.Append(string.Format("....<img src='{3}' .....",x.Author, x.BlogTitle,x.BlogDescription,x.ImagePath));
hope that helps. may be you have to check the path of image, whether it is relative or absolute path.

Umair Nafis 10-Oct-17 7:45am

hello sir, thats fine i tried and it works but i want to add multiple images, from the above code I can only bind a signle image, suppose if a blog contains more than one image then how could i bind it?
Thanks alott

sachin.vishwa90 10-Oct-17 8:02am

well, in that case you will have to first form the ImageList HTML and inject the formed HTML in the string.format code. hope you understand it

Umair Nafis 10-Oct-17 16:42pm

Sorry, I didnt get u. It will be very helpful if you provide some code or link.

sachin.vishwa90 · Accepted Answer · 2017-10-04T21:22:00

there is a jquery plugin available for it. http://www.jqueryscript.net/text/jQuery-Plugin-For-Truncating-Text-with-Read-More-Links-jReadMore.html
you have to alter your html text as mentioned in the blog.
the key part is activate your plugin code. for this you will have to write javascript in you aspx page.

JavaScript

<script type='text/javascript'>
function activateReadmore(){
$('.read-more').readMore();
}
<script>

you have to call this function after you bind your html in your c# code

blogData.InnerHtml = sb.ToString();
// after this you will activate your function
Page.ClientScript.RegisterStartupScript(this.GetType(),"CallMyFunction","activateReadmore()",true);

hope that helps