Hi,
I have a dataset from a SQL view. In the ASP .NET code I have appended a few rows to the dataview temporarily. I then want to sort it on a couple of fields and present it through a datagrid.
However, no matter what I try it will not sort!
e.g.

With SqlDataAdapter
.Fill(DsStats1)
End With

'create new row in code

DsStats1.vwStats.Rows.Add(RowNew)

vwStats = DsStats1.Tables("vwStats").DefaultView
vwStats.Sort = "Area"
datagrid1.DataSource = vwStats

Thanks in advance.