Jquery and SQL data table
<p>Learning Jquery here and I would like to show my SQL table on my webpage. I have the "shell" of my jquery that matches the SQL table and my web.config is setup correctly but my jquery doesnt load data. Where it says <code>url: 'ConnectionString',</code> I would like for it to point to my table or the web.config file. What can I do here. I need some guidance as this is something Im learning. </p>

<p>Thanks</p>

<pre><code>&lt;script type='text/javascript'&gt;

    $(function () {
        $("#list").jqGrid({
            url: 'Default.aspx',
            datatype: 'xml',
            mtype: 'GET',
            colNames: ['Inv No', 'Date', 'Amount', 'Tax', 'Total', 'Notes'],
            colModel: [
  { name: 'ID', index: 'ID', width: 55 },
  { name: 'Date', index: 'Date', width: 90 },
  { name: 'amount', index: 'amount', width: 80, align: 'right' },
  { name: 'tax', index: 'tax', width: 80, align: 'right' },
  { name: 'total', index: 'total', width: 80, align: 'right' },
  { name: 'note', index: 'note', width: 150, sortable: false }
],
            pager: '#pager',
            rowNum: 10,
            rowList: [10, 20, 30],
            sortname: 'invid',
            sortorder: 'desc',
            viewrecords: true,
            caption: 'Joshs first grid'
        });
    }); 

&lt;/script&gt;
</code></pre>

<p>My Aspx part as follows</p>

<pre><code>&lt;div class="ui-widget"&gt;

    &lt;table id="list"&gt;&lt;/table&gt; 

    &lt;div id="pager"&gt;&lt;/div&gt; 

&lt;/div&gt;
</code></pre>
