Dataset..

[Alen Smith]

Is it possible to sort the data is dataset. .Net 1.1.

Thanks,

Smith

 

[Patrice]

See the DefaultView member... The DataTable holds the data, views allows to
create sorted, filtered, restricted views of those data...

 

[Alen Smith]

Where to add DefaultView member in the below code? How to SORT the data?

Dim myAdapter As New SqlDataAdapter(data from SP)

Dim ds As New DataSet

myAdapter.Fill(ds)

myDataGrid.DataSource = ds

myDataGrid.DataBind()

Thanks,

Smith

 

[MarkD]

Dim _dv As DataView = New DataView(ds.Tables(0))
dv.Sort = Sort
myDataGrid.DataSource = dv
myDataGrid.DataBind()

 

[Alen Smith]

Thanks a lot.
Smith

Dim _dv As DataView = New DataView(ds.Tables(0))
dv.Sort = Sort
myDataGrid.DataSource = dv
myDataGrid.DataBind()



message