Complex Sorting and Paging ASP.Net and DWMX

Step 2

Creating the Data Set:

A dataset will be all the information from the database that will be displayed in your datagrid. On the "Applications" panel click the "Bindings" tab on the top then click the "+" sign and select "DataSet (Query)" from the list of options.

The dataset box will come up in one of two views "simple" or "advanced". This is what the advanced view looks like (below). If you have a button on the right side that says "Advanced.." click it! you should see this box:

Make the following changes:

1. Name: dsGrid
2. Connection: select "connlocal" from the dropdown box (remember you just created this)
3. Either type in the SQL string or select it from the "Database Items" Selection box

Now click "Test" you should see the result set from the Northwind database then click "OK" and "OK" again on the "Dataset" box:

Note: if you get an error close out the "Dataset" box and try creating it again (Step 2 again).

You have created the Dataset which you can see in the "Bindings" panel: