我把AutoGenerateColumns设为false;然后在程序里创建BOUNDCOLUMN来增加列，再用DATAFIELD来绑定，现在想排序，应该怎么弄？

zj510 2003-10-08 10:15:07

...全文

44 3 打赏收藏转发到动态举报

写回复

用AI写文章

3 条回复

切换为时间正序

请发表友善的回复…

发表回复

saucer 2003-10-08

打赏
举报

1. you need to override LoadViewState to recreate the columns
2. you need to set SortExpression and add SortCommand handler

try something like

<%@ Page Language="C#" AutoEventWireup="True" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<html>
<script runat="server">

protected override void LoadViewState(object savedState)
{
base.LoadViewState(savedState);
AddColumns();
}

void AddColumns()
{
BoundColumn bc = new BoundColumn();
bc.DataField = "au_lname";
bc.SortExpression = "au_lname";
bc.HeaderText = "Last Name";
DataGrid1.Columns.Add(bc);

bc = new BoundColumn();
bc.DataField = "au_fname";
bc.SortExpression = "au_fname";
bc.HeaderText = "First Name";
DataGrid1.Columns.Add(bc);

DataGrid1.SortCommand += new DataGridSortCommandEventHandler(this.Sort_Grid);

}

void BindData(string sSortExpression)
{

SqlDataAdapter da = new SqlDataAdapter("select * from authors", "server=localhost;database=pubs;uid=smart;pwd=getsmart;");
DataTable dt = new DataTable();
da.Fill(dt);
DataView dv = dt.DefaultView;
dv.Sort = sSortExpression;
DataGrid1.DataSource = dv;
DataGrid1.DataBind();
}

void Page_Load(Object sender, EventArgs e)
{

if (!IsPostBack)
{
DataGrid1.AllowSorting = true;
AddColumns();
BindData("");
}
}

void Sort_Grid(Object sender, DataGridSortCommandEventArgs e)
{
BindData(e.SortExpression);
}

</script>

<body>

<form runat=server>
<asp:DataGrid id=DataGrid1 runat=server AutoGenerateColumns=false/>
<asp:Button id=btn runat=server Text="submit" />
</form>

</body>
</html>

xrll 2003-10-08

打赏
举报

BoundColumn bc = new BoundColumn();
bc.DataField="IntegerValue";
bc.SortExpression = "CurrencyValue";
bc.HeaderText = "aaaa";
bc.HeaderStyle.BackColor = Color.Black;
bc.HeaderStyle.ForeColor = Color.White;
bc.HeaderStyle.HorizontalAlign=HorizontalAlign.Center;
bc.ItemStyle.HorizontalAlign=HorizontalAlign.Center;
bc.ItemStyle.Wrap = false;
MyDataGrid.Columns.Add(bc);
......
MyDataGrid.AllowSorting = true;
MyDataGrid.SortCommand += new DataGridSortCommandEventHandler(this.Sort_Grid);
....
下面就是写Sort_Grid事件了,如：
void Sort_Grid(Object sender, DataGridSortCommandEventArgs e)
{
DataTable dt = (DataTable)Session["Source"];
DataView dv = new DataView(dt);
dv.Sort = e.SortExpression;
MyDataGrid.DataSource = dv;
MyDataGrid.DataBind();

}

竹君子 2003-10-08

打赏
举报

1.添加AllowSorting="True"和OnSortCommand="SortCommand"在<datagrid>里
2 .cs文件里写函数
public void SortCommand(object sender,DataGridSortCommandEventArgs e)
{
ViewState["SortExpression"]=e.SortExpression;
UpdateView();

}