Tool For Building Feature-Rich Tables?

Discussion in 'HTML & Website Design' started by barrow, Nov 16, 2007.

0
  1. #1
    Hey everyone,
    Does anyone know of a tool that I can use to easily create tables that will have the following features:
    - Sortable
    - Searchable
    - Pagination
    - Filtering
    - AJAX (this isn't a necessity but it would be lovely)

    I don't really care what the back end is: SQL, XML, whatever. And it doesn't matter if there's a free solution or not, I'll buy a product if I have to.

    So does anyone have any suggestions for me?

    Much appreciated!
     
    barrow, Nov 16, 2007 IP
  2. AstarothSolutions

    AstarothSolutions Peon

    Messages:
    2,680
    Likes Received:
    77
    Best Answers:
    0
    Trophy Points:
    0
    #2
    If you use ASP.Net then you have <asp:updatepanel> <asp:gridview> & <asp:sqldatasource> which will do sortable, pagination and ajax out the box and it isnt hard to add filtering and searching to it (as long as it isnt weighted searching which is more complex)
     
    AstarothSolutions, Nov 16, 2007 IP
  3. barrow

    barrow Peon

    Messages:
    135
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I have never used ASP.Net before but that sounds like a great solution so I think I'm going to dive into it this weekend. Thanks for the suggestion.
     
    barrow, Nov 16, 2007 IP
  4. AstarothSolutions

    AstarothSolutions Peon

    Messages:
    2,680
    Likes Received:
    77
    Best Answers:
    0
    Trophy Points:
    0
    #4
    ASP.Net is the web version of microsofts .Net framework.

    They do a free version of the development tool called Visual Web Developer Express which has wysiwyg type interface as well as source code & a test server built into it for playing :)
     
    AstarothSolutions, Nov 16, 2007 IP
  5. barrow

    barrow Peon

    Messages:
    135
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Before I go and write something semi from scratch, nobody knows of any php scripts that do this? It seems like a ton of people would have a need for inventory tables, I'm suprised it's so hard to find a product that does this.
     
    barrow, Nov 17, 2007 IP
  6. AstarothSolutions

    AstarothSolutions Peon

    Messages:
    2,680
    Likes Received:
    77
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Writing from scratch? not really hard, your paging, sorting etc is simply:
    
<%@ Page Language="VB" %>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:ScriptManager ID="ScriptManager1" runat="server" />
        <asp:UpdatePanel ID="UpdatePanel1" runat="server">
        <ContentTemplate>
            <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True" DataSourceID="SqlDataSource1" />
            <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ImPlayingCS %>" SelectCommand="SELECT * FROM [Comments]" />
        </ContentTemplate>
        </asp:UpdatePanel>
    </div>
    </form>
</body>
</html>
    Code (.Net):
    just need a small amount of code to do filtering and searching
     
    AstarothSolutions, Nov 17, 2007 IP