I am very confused to choose among many ways to do a task efficiently. Please suggest me the best way to do the following..
All I want is to "search a sql-database and show up the result in a grid". Note that each row would have an image, a link and some text.
My main check points are
1) Ajax-style grid: On pressing next-page, only the grid should be updated not the whole page
2) Client side pagination: Since the search result might be huge, on each time pressing the next-page, I want to get only the specified rows from the server. NOT THE WHOLE SEARCH RESULT- WHICH WOULD SLO DOWN MY INITIAL GRID SHOWING
I am new to web-programming. While browsing through I got the following points...But i am not able to put them all together and somehow i am not confident about it..very much confused what to use and what not to... please help!!!
1) asp.net ajax toolkit
2) use a simple way to create a table with many rows in client side using java script, and get the data form server using AJAX writing the all code of myself. But in this case i need to have a way of pagination if myself
3) etc (may be many other solutions exist)
Practically, there may be many pros and cons which I am unaware of. I am looking for something efficient and easy to use. May be less code.
technology: vs2008/2010, Ajax/Jquerry/JS, sql-db... since havent started teh project I am open to any technology which gives the best solution.
thanks in advance