ASP.NET

Y_Kaushik wrote:

sql = "select * from table "

SELECT * FROM table ORDER BY <field1>

SELECT TOP 5 * FROM table ORDER BY <field1>

SELECT TOP 5 PERCENT * FROM table

SELECT TOP 5 PERCENT WITH TIES * FROM table ORDER BY <field1>

PERCENT 
Indicates that the query returns only the first expression percent of rows from the result set.

WITH TIES 
Specifies that additional rows be returned from the base result set with the same value in the ORDER BY columns appearing as the last of the TOP n (PERCENT) rows. TOP ...WITH TIES can be specified only in SELECT statements, and only if an ORDER BY clause is specified.

private void FillGrid( string sortExpression, SortDirection sortDir )
{
   string sort = sortExpression + " " + (sortDir == SortDirection.Descending ? "desc" : "" );

   DataTable dt = GetDataTableFromSomewhere();
   DataView dv = new DataView(dt, "", sort, DataViewRowState.CurrentRows );
   GridView1.DataSource = dv;
   GridView1.DataBind();
}

protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
{
   FillGrid(e.SortExpression, e.SortDirection);
}

 <br />
dim ds as new dataset<br />
ds = DBUsers.Pages_Select(DDLTypes.SelectedValue)<br />
        Dim tblPages As DataTable = New DataTable<br />
        tblPages = ds.Tables(2)<br />
        DGPages.DataSource = tblPages<br />
        DGPages.DataBind()