Link to home
Start Free TrialLog in
Avatar of VBBRett
VBBRett

asked on

Attempting to create an infinite scroll app using jquery and asp.net

I am attempting to create an infinite scroll app using asp.net and jquery.  I would like it to be able to pull 10 records at a time.  I did in fact find a somewhat half done solution but it keeps repeating the same information from an xml source.  Does anybody have an idea on how I can do this as a commenting system similar to facebook?  This is the code that I found in the default.aspx.cs file.  How could I make it so that I am only pulling 10 records per postback?

     [WebMethod]
        public static string Foo()
        {
            StringBuilder getPostsText = new StringBuilder();
            using (DataSet ds = new DataSet())
            {
                ds.ReadXml(HttpContext.Current.Server.MapPath("App_Data/books.xml"));
                DataView dv = ds.Tables[0].DefaultView;

                foreach (DataRowView myDataRow in dv)
                {
                    getPostsText.AppendFormat("<p><b>author:</b> {0}</br>", myDataRow["author"]);
                    getPostsText.AppendFormat("genre: {0}</br>", myDataRow["genre"]);
                    getPostsText.AppendFormat("price: {0}</br>", myDataRow["price"]);
                    getPostsText.AppendFormat("publish date: {0}</br>", myDataRow["publish_date"]);
                    getPostsText.AppendFormat("description: {0}</br></p>", myDataRow["description"]);
                }
                getPostsText.AppendFormat("<div style='height:15px;'></div>");

            }
            return getPostsText.ToString();
        }
ASKER CERTIFIED SOLUTION
Avatar of Roopesh Reddy
Roopesh Reddy
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of VBBRett
VBBRett

ASKER

Why do I get the feeling that every time I look into a JQuery, JavaScript or similar framework for help, the creator of the JQuery or JavaScript framework is short on instructions and doesn't follow through with examples of pulling data from databases?  The site is short on instructions.  I feel like every time I look for an example of somebody pulling data from a database, they always talk about stagnant content or loop through a for or while loop.  This is extremely frustrating!
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of VBBRett

ASKER

Thank you roopeshreddy...I am currently reviewing the code that you sent me the link to.
Avatar of VBBRett

ASKER

Is it best to use a web service to do an example like this?