Gridview按照列值排序数据 [英] Gridview sorting data as per Column Values

问题描述

嗨专家，

i有关于绑定gridview值的问题..我的网格视图就像这样

  1  School1 关闭 
  2  School2 打开 
  3  School3 关闭 
  4  School4 关闭 
  5  School5 打开 
  6  School6 打开 
  7  School7 关闭 

我如何在页面上方的网格视图中显示Open Schools First ..



请帮帮我..





提前致谢

解决方案

如果您绑定DataTable，那么您也可以尝试这个

 dt.DefaultView.Sort =   StatusCol Desc;  //   dt是您的数据表，StatusCol是您的列名 
 grdView.DataSource = dt 。默认视图; 
 grdView.DataBind（）; 

您可以按'DESC'对该特定列进行排序，以便按照字典文本格式对列进行排序因此，如果它按降序排序，则打开将首先出现，然后是关闭。



您可以使用如下所述的任何级别的排序： -



1）在查询本身从数据库中提取时对其进行排序

ex： -

  ORDER   BY  [StatusColoumn]  DESC  

2）否则，您可以在页面加载时对网格应用默认排序，如下所示： -

例如： -

 受保护  void  Page_Load （ object  sender，EventArgs e）
 {
  //  设置y我们的deault排序表达式。 
  if （ String  .IsNullOrEmpty（GridView1.SortExpression ））GridView1.Sort（& quot; SortExpression& quot;，SortDirection.Ascending）; 
} 

Hi Experts,
i have a problem with Binding gridview values.. my gridview like this

1   School1    Close
2   School2    Open
3   School3    Close
4   School4    Close
5   School5    Open
6   School6    Open
7   School7    Close

how can i show Open Schools First on page load in above grid view..

Please help me..


Thanks in advance

解决方案

If You are binding DataTable then you can also try this

dt.DefaultView.Sort = "StatusCol Desc"; //dt is your data table and StatusCol is your column name
grdView.DataSource = dt.DefaultView;
grdView.DataBind();

You can sort that particular column by 'DESC" so as per the dictionary text format it will sort the column and so the 'Open' will come first then 'Close' if it sorted in descending order.

You can use sorting either of the levels like described below :-

1) Sort it while fetching from database in query itself
ex :-

ORDER BY [StatusColoumn] DESC

2) Else you can apply default sorting for the grid on page load as below :-
ex :-

protected void Page_Load(object sender, EventArgs e)
    {
        // Set your deault sort expression.
        if (String.IsNullOrEmpty(GridView1.SortExpression)) GridView1.Sort("SortExpression", SortDirection.Ascending);
    }

这篇关于Gridview按照列值排序数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！