UC知道GridView中无法对每列的数据进行排序
来源：百度知道 编辑：UC知道 时间：2024/05/10 22:52:10
我将一个名为grdUser的GridView的Sorting事件写好了相应的方法：
protected void grdUser_Sorting(object sender, GridViewSortEventArgs e)
{
DataTable dataTable = grdUser.DataSource as DataTable;
if (dataTable != null)
{
DataView dataView = new DataView(dataTable);
dataView.Sort = e.SortExpression + " " + ConvertSortDirectionToSql(e.SortDirection);
grdUser.DataSource = dataView;
grdUser.DataBind();
}
}
private string ConvertSortDirectionToSql(SortDirection sortDireciton)
{
string newSortDirection = String.Empty;
switch (sortDireciton)
{
case SortDirection.Ascending:
newSortDirection = "ASC";
break;
case SortDirection.Descending:
newSortDirection = "DESC";
protected void grdUser_Sorting(object sender, GridViewSortEventArgs e)
{
DataTable dataTable = grdUser.DataSource as DataTable;
if (dataTable != null)
{
DataView dataView = new DataView(dataTable);
dataView.Sort = e.SortExpression + " " + ConvertSortDirectionToSql(e.SortDirection);
grdUser.DataSource = dataView;
grdUser.DataBind();
}
}
private string ConvertSortDirectionToSql(SortDirection sortDireciton)
{
string newSortDirection = String.Empty;
switch (sortDireciton)
{
case SortDirection.Ascending:
newSortDirection = "ASC";
break;
case SortDirection.Descending:
newSortDirection = "DESC";
对不起,和datagrid混了
ataView.Sort = e.SortExpression + " " + ConvertSortDirectionToSql(e.SortDirection);
换成
if (e.SortDirection == SortDirection.Ascending)
{
dv.Sort = e.SortExpression+" Desc";
}
else
{
dv.Sort = e.SortExpression + " Asc";
}
g.DataSource = dv;
g.DataBind();
}
是不是你排序的属性没打开啊
极其有可能，排序的属性还是false,建议检查一下
晕死~ 用DataSet中Tables的 Select()方法啊
ds.Tables[0].Select(语句);