C#

using System.Data;
using System.Data.SqlClient;

namespace Employee
{
public partial class Emp_Details : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection connection = new SqlConnection("server=myDB;uid=sa;pwd=password;database=master");
connection.Open();
SqlCommand command = new SqlCommand("select * from employee",connection);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = command;
DataSet ds = new DataSet();
da.Fill(ds,"employee");
DataView dv = new DataView(ds.Tables["employee"]);
dv.RowFilter = "emp_age<30";
dv.Sort = "First_Name ASC";
EmpDetails.DataSource = dv;
EmpDetails.DataBind();
connection.Close() }
}
}

VB

Imports System.Data
Imports System.Data.SqlClient

Partial Public Class Emp_Details
Inherits System.Web.UI.Page

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim connetion As SqlConnection = New SqlConnection("server=myDB;uid=sa;pwd=password;database=master")
connection.Open()
Dim command As SqlCommand = New SqlCommand("select * from employee", connection)
Dim da As SqlDataAdapter = New SqlDataAdapter()
da.SelectCommand = command
Dim ds As DataSet = New DataSet()
da.Fill(ds, "employee")
Dim dv As DataView = New DataView(ds.Tables("employee"))
dv.RowFilter = "emp_age<30"
dv.Sort = "First_Name ASC"
EmpDetails.DataSource = dv
EmpDetails.DataBind()
connection.Close()
End Sub
End Class

Description

dv.RowFilter = "emp_age<30" retrieves records of those employees whose age is less than 30.
dv.Sort = "First_Name ASC" Sorts column First_Name of table employee in ascending order.
EmpDetails is a GridView ID.