| Author: mahalakshmi 05 Jul 2008 | Member Level: Gold | Rating:  Points: 6 |
use SortExpression to sort datagrid data or use ORDERBY in sql.
try the follwing code but i have sent code for sorting gridview data ,u can change gv to dg,
protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
{
//string s = GridView1.SortExpression;
//e.SortExpression = s;
SqlDataAdapter da1 = new SqlDataAdapter ("Select * from product",con);
DataTable dt = new DataTable();
da1.Fill(dt);
DataView dv = new DataView(dt);
//dv.Sort
// GridView1.DataSource = dv.Sort;
//GridView1.DataBind();
dv.Sort = e.SortExpression +
" " + "ASC";
GridView1.DataSource = dv;
GridView1.DataBind();
}
|