Sort Grid from Column Header and Drop Down???

[DBLWizard]

I posted a message on the topic earlier and thought I had it solved
but in testing have found problems. I have a Templated GridView
control on a webpage bound to an ObjectDataSourc e. There are 3
columns that are "Sortable" That sorting works fine until I add the
dropdown with a "refresh" button into the mix. The only way that I
have found to sort the grid from the dropdown requires the following
code.

When I set the e.Arguments.Sor tExpression it causes the grid to get
sorted the problem is the Grid properties do not reflect this change.
So when you next click on the grid column to sort it has the wrong
information as to which column is sorted and what direction is
sorted. So the first click on the column header the results are
unpredicable. Is there a better way to do this?

Any help would be greatly appreciated.

Thanks

dbl

protected void btnRefresh_Clic k(object sender, EventArgs e)
{
sortColumn =
Convert.ToInt16 (cboSortBy.Sele ctedValue.Subst ring(0, 1));
sortExpression =
grdUpcoming.Col umns[sortColumn].SortExpression ;

if (cboSortBy.Sele ctedValue.EndsW ith("A"))
{
sortDirection = "ASC";
}
else if (cboSortBy.Sele ctedValue.EndsW ith("D"))
{
sortDirection = "DESC";
}
else
{
throw new Exception("Inva lid sort by Value");
}
grdUpcoming.Dat aBind();
}

protected void ObjectDataSourc e1_Selecting(ob ject sender,
ObjectDataSourc eSelectingEvent Args e)
{
if (!e.ExecutingSe lectCount)
{
if (sortExpression != "")
{
e.Arguments.Sor tExpression = sortExpression + " "
+ sortDirection;
}
else
{
cboSortBy.Selec tedValue =
GetSortColumnIn dex().ToString( ) +
grdUpcoming.Sor tDirection.ToSt ring().Substrin g(0, 1).ToUpper();

}
}
}