如何使用Gridview的Datatable排序

Question

我有一个表在GridView

vName   iId
Jeeva   323243
raj     4343
Abishek 3434
ramesh  4545
Manoj   7374234
viky    885

我想用DataTable按升序/降序显示这个表。

static string strcon = "Data Source=;Initial Catalog=;Integrated Security=True";
SqlConnection con = new SqlConnection(strcon);
SqlCommand cmd = new SqlCommand();
SqlDataAdapter da = new SqlDataAdapter("select * from one", con);
DataTable dt = new DataTable();
da.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();

Answer 1

试试这个:

datatable.DefaultView.Sort = "yourcolumnname ASC"; 

datatable = datatable.DefaultView.ToTable();

Answer 2

使用linq:

var OrderedItems = dt.OrderBy(x=>x.vName).ToList();
GridView1.DataSource = OrderedItems;

或按其他列排序(OrderByDescending也可以使用)