DataGrid Sorting does not work

[Sameeksha]

Hello,
I've a datagrid whose AllowSorting property is set to True. The datagrid is
bound to northwind table suppliers. I've handled the SortCommand event of the
datagrid control. But somehow the code is not working. The SortCommand event
handler is called, but the data shown in the grid is not sorted.

I've written the following code in the asp.net web appl.
private void Page_Load(objec t sender, System.EventArg s e)
{
if (!this.IsPostBa ck)
{
sqlDataAdapter1 .Fill(dataSet11 );
DataGrid1.DataS ource = dataSet11.Suppl iers;
DataGrid1.DataB ind();
}
}

private void DataGrid1_SortC ommand(object source,
DataGridSortCom mandEventArgs e)
{
sqlDataAdapter1 .Fill(dataSet11 );
DataView dv1 = new
DataView(dataSe t11.Suppliers," ",e.SortExpress ion,DataViewRow State.CurrentRo ws);
dv1.Sort = e.SortExpressio n.ToString();
dv1.ApplyDefaul tSort = false;
DataGrid1.DataS ource = dv1;
DataGrid1.DataM ember = "Suppliers" ;
DataGrid1.DataB ind();
}

Can anybody point out the problem? The sorting works if I change the
SelectCommand property of the dataset and fill the dataset again with the new
command with an 'order by' clause. But what's wrong with the dataview
approach that I've demonstrated above?
--
Sameeksha,
MCP (.NET)

[Sameeksha]

Hello
The problem has been solved
I'd done the data binding of grid in the designer. Instead I should have
used only dynamic binding. Once I removed the binding in the designer, it
started working

Sameeksha

"Sameeksha" wrote:

Hello,
I've a datagrid whose AllowSorting property is set to True. The datagrid is
bound to northwind table suppliers. I've handled the SortCommand event of the
datagrid control. But somehow the code is not working. The SortCommand event
handler is called, but the data shown in the grid is not sorted.

I've written the following code in the asp.net web appl.
private void Page_Load(objec t sender, System.EventArg s e)
{
if (!this.IsPostBa ck)
{
sqlDataAdapter1 .Fill(dataSet11 );
DataGrid1.DataS ource = dataSet11.Suppl iers;
DataGrid1.DataB ind();
}
}

private void DataGrid1_SortC ommand(object source,
DataGridSortCom mandEventArgs e)
{
sqlDataAdapter1 .Fill(dataSet11 );
DataView dv1 = new
DataView(dataSe t11.Suppliers," ",e.SortExpress ion,DataViewRow State.CurrentRo ws);
dv1.Sort = e.SortExpressio n.ToString();
dv1.ApplyDefaul tSort = false;
DataGrid1.DataS ource = dv1;
DataGrid1.DataM ember = "Suppliers" ;
DataGrid1.DataB ind();
}

Can anybody point out the problem? The sorting works if I change the
SelectCommand property of the dataset and fill the dataset again with the new
command with an 'order by' clause. But what's wrong with the dataview
approach that I've demonstrated above?
--
Sameeksha,
MCP (.NET)