GridView Data Filtering

After Binding a grid you can filter grid using this code..



protected void btnFiltering_Click( object sender, EventArgs e)

{ // Filtering of Data using DataView

string strConn = "Data Source=localhost;Initial Catalog= pubs; user Id=sa;Password =test" ;

string sqlQuery = "select * from stores" ;

SqlConnection conn = new SqlConnection (strConn);

SqlDataAdapter ada = new SqlDataAdapter (sqlQuery, conn);

DataTable dtStore = new DataTable ();

ada.Fill(dtStore);

//Create DataView Object

DataView dvStores = new DataView (dtStore);

dvStores.RowFilter = "state = 'CA'" ;

//Bind GridView : Only 'CA' state

grdvFilter.DataSource = dvStores;

grdvFilter.DataBind();

}

protected void btnSorting_Click( object sender, EventArgs e)

{ //Sorting of Data Using DataView

string strConn = "Data Source=localhost;Initial Catalog= pubs; user Id=sa;Password = test" ;

string sqlQuery = "select * from stores" ;

SqlConnection conn = new SqlConnection (strConn);

SqlDataAdapter ada = new SqlDataAdapter (sqlQuery, conn);

DataTable dtStore = new DataTable ();

ada.Fill(dtStore);

//Create DataView Object

DataView dvStores = new DataView (dtStore);

dvStores.Sort = "city" ;

//Bind GridView : Sorting By City

grdvSort.DataSource = dvStores;

grdvSort.DataBind();

}

}

If any query regarding this feel free to ask me.
vivek mehta thevivek.pro