what's the best way

[John 3:16]

Hello...
I have a question related to performance.
Being new to asp.net & vp programming, I put together
a webform that displays columns of data in a datagrid.
Users can sort by the header label.

QUESTION: When they click to sort, I run a new
stored procedure to return the resorted data...

Should I only get the data once and query the
disconnected dataset.. and if so .. can someone
point me in the right direction.

Thanks in advance....

[KJ]

Get the data once, and just use a DataView to sort, like so:

//(pseudo C#), in SortCommand event handler
DataSet ds = GetMyDataSet(); // your function here
DataView dv = new DataView (ds.Tables[0]); //first table
v.Sort = "Clicked Column Name"; //column name of the table to sort on
MyDataGrid.Data Source = dv; //set the sorted view as the data source to
the datagrid
MyDataGrid.Data Bind(); // bind the grid to the view

Note: Sort direction may also be changed by appending " ASC" or " DESC"
to the v.Sort assigned value.

[John 3:16]

Thanks KJ.
I will try to work through your suggestion.
I have one more question if you don't mind...
Is this the best..(fastest) way to retrive data into a dataset...

Dim sTextBranchCoun ts As String = "dcc.dbo.afCoun t_Display" 'Stored Proc to
return the Pre Processed Data

Dim sConn As String =
"SERVER=localho st;UID=*****;PA SSWORD=*****;DA TABASE=*****;"

Dim dsBC As DataSet = New DataSet

Dim cmdBC As SqlDataAdapter = New SqlDataAdapter( sTextBranchCoun ts, sConn)

cmdBC.SelectCom mand.CommandTyp e = CommandType.Sto redProcedure

dsBC.Clear()

cmdBC.Fill(dsBC , cmdBC.SelectCom mand.ToString)

Me.dgBranchCoun ts.DataSource = dsBC

Me.dgFleetInspe ctions.DataBind ()

Thanks in advance...
"KJ" <n_**********@m ail.com> wrote in message
news:11******** **************@ f14g2000cwb.goo glegroups.com.. .

Get the data once, and just use a DataView to sort, like so:

//(pseudo C#), in SortCommand event handler
DataSet ds = GetMyDataSet(); // your function here
DataView dv = new DataView (ds.Tables[0]); //first table
v.Sort = "Clicked Column Name"; //column name of the table to sort on
MyDataGrid.Data Source = dv; //set the sorted view as the data source to
the datagrid
MyDataGrid.Data Bind(); // bind the grid to the view

Note: Sort direction may also be changed by appending " ASC" or " DESC"
to the v.Sort assigned value.

[KJ]

Your way of getting the job done looks fine. Note that the Framework is
quite flexible in that there are many ways to achive the same result.

One thing to also get in the habit of is to call the Dispose method of
any SqlDataAdapter, SqlCommand, SqlConnection, DataSet, or any other
object you instantiate that provides a Dispose() method.

This will ensure that your objects get cleaned up asap, releasing any
unmanaged resources (such as COM objects) used by them under the hood.

[Steve Mauldin]

Bob,

I concur with KJ the Dataview is the way to go. I am attaching some code
you may find useful. This is from a report from one of my websites that
uses dataview to sort on grid clicks. NationalConfere ncetable is a
datatable that in my code is stored in the application object but you can
get your datatable from just about any persistent storage area Application,
Session, Cache, etc.. I hope this helps you.

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArg s) Handles MyBase.Load

ReportDataGrid. DataSource = Application ("NationalConfe rencetable")

ReportDataGrid. DataBind()

End Sub

'sorting code to use headers to sort data.

Private Sub ReportDataGrid_ SortCommand(ByV al source As System.Object, ByVal
e As System.Web.UI.W ebControls.Data GridSortCommand EventArgs) Handles
ReportDataGrid. SortCommand

Dim firstView As DataView = New DataView(Applic ation
("NationalConfe rencetable"))

firstView.Sort = e.SortExpressio n

ReportDataGrid. DataSource = firstView

ReportDataGrid. DataBind()

End Sub


"John 3:16" <bo****@tricoeq uipment.com> wrote in message
news:u6******** *****@TK2MSFTNG P09.phx.gbl...

Hello...
I have a question related to performance.
Being new to asp.net & vp programming, I put together
a webform that displays columns of data in a datagrid.
Users can sort by the header label.

QUESTION: When they click to sort, I run a new
stored procedure to return the resorted data...

Should I only get the data once and query the
disconnected dataset.. and if so .. can someone
point me in the right direction.

Thanks in advance....

[John 3:16]

Thanks KJ... I will discipline myself to you the dispose method whenenver
possible.
"KJ" <n_**********@m ail.com> wrote in message
news:11******** **************@ o13g2000cwo.goo glegroups.com.. .

Your way of getting the job done looks fine. Note that the Framework is
quite flexible in that there are many ways to achive the same result.

One thing to also get in the habit of is to call the Dispose method of
any SqlDataAdapter, SqlCommand, SqlConnection, DataSet, or any other
object you instantiate that provides a Dispose() method.

This will ensure that your objects get cleaned up asap, releasing any
unmanaged resources (such as COM objects) used by them under the hood.

[John 3:16]

The biggest filtered set is just under 1,000 records.
It's currently taking 5-7 sec. to retrieve the data.
I'd like to do this once when they open the webform and
then when they sort, I'd like the data to be there already and
just be able to change the sort on that data.

"Spam Catcher" <sp**********@r ogers.com> wrote in message
news:Xn******** *************** ***********@127 .0.0.1...

"John 3:16" <bo****@tricoeq uipment.com> wrote in news:u6p4wefHGH A.344
@TK2MSFTNGP09.p hx.gbl:

Should I only get the data once and query the
disconnected dataset.. and if so .. can someone
point me in the right direction.

Depends on how big your data set is...

--
Stan Kee (sp**********@r ogers.com)

[John 3:16]

Thanks Steve.
I will work with your example and try to understand how this works.
Thanks again,
Bob.

"Steve Mauldin" <st**********@h otmail.com> wrote in message
news:u0******** ********@TK2MSF TNGP11.phx.gbl. ..

Bob,

I concur with KJ the Dataview is the way to go. I am attaching some code
you may find useful. This is from a report from one of my websites that
uses dataview to sort on grid clicks. NationalConfere ncetable is a
datatable that in my code is stored in the application object but you can
get your datatable from just about any persistent storage area
Application,
Session, Cache, etc.. I hope this helps you.

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArg s) Handles MyBase.Load

ReportDataGrid. DataSource = Application ("NationalConfe rencetable")

ReportDataGrid. DataBind()

End Sub

'sorting code to use headers to sort data.

Private Sub ReportDataGrid_ SortCommand(ByV al source As System.Object,
ByVal
e As System.Web.UI.W ebControls.Data GridSortCommand EventArgs) Handles
ReportDataGrid. SortCommand

Dim firstView As DataView = New DataView(Applic ation
("NationalConfe rencetable"))

firstView.Sort = e.SortExpressio n

ReportDataGrid. DataSource = firstView

ReportDataGrid. DataBind()

End Sub


"John 3:16" <bo****@tricoeq uipment.com> wrote in message
news:u6******** *****@TK2MSFTNG P09.phx.gbl...

Hello...
I have a question related to performance.
Being new to asp.net & vp programming, I put together
a webform that displays columns of data in a datagrid.
Users can sort by the header label.

QUESTION: When they click to sort, I run a new
stored procedure to return the resorted data...

Should I only get the data once and query the
disconnected dataset.. and if so .. can someone
point me in the right direction.

Thanks in advance....