如何对Gridview中显示的数据表数据进行排序 [英] how to sort Datatable data that is displayed in Gridview
问题描述
第1页:(以下是按钮点击时包含的代码。当我点击第1页的按钮时,应显示第2页的表格数据)
< pre lang =c#> protected void btnSubmit_Click( object sender,EventArgs e)
{
string s = select * from items;
SqlDataAdapter da = new SqlDataAdapter(s,con);
DataTable dt = new DataTable();
da.Fill(dt);
会话[ a] = dt;
Response.Redirect( Default2.aspx);
}
第2页:(第2页显示表数据的代码)
< pre lang =c#> protected void Page_Load( object sender,EventArgs e)
{
DataTable dt =(DataTable)Session [ 一个跨度>];
GridView1.DataSource = dt;
GridView1.DataBind();
}
现在我可以知道如何在运行时对gridview中显示的数据进行排序吗?
添加预
标签。
[/编辑] 这样的事情......
dt.DefaultView.Sort = YourColumnName ASC; // DESC for descending。
Page 1:(the following is the Code incorporated in button click. When i click on button of page 1 should display the table data in page 2)
protected void btnSubmit_Click(object sender, EventArgs e)
{
string s="select * from items";
SqlDataAdapter da = new SqlDataAdapter(s,con);
DataTable dt = new DataTable();
da.Fill(dt);
Session["a"]=dt;
Response.Redirect("Default2.aspx");
}
page 2 :(Code for displaying the table data in page 2)
protected void Page_Load(object sender, EventArgs e)
{
DataTable dt=(DataTable)Session["a"];
GridView1.DataSource = dt;
GridView1.DataBind();
}
Now may i know how to sort the data displayed in gridview at run time?
[Edit member="Tadit"]
Added pre
tags.
[/Edit]
Something like this...
dt.DefaultView.Sort = "YourColumnName ASC"; // DESC for descending.
这篇关于如何对Gridview中显示的数据表数据进行排序的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!