Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP .Net Datagrid Control > What's the fastest method to populate data into GRID

Reply
Thread Tools

What's the fastest method to populate data into GRID

 
 
sqlak sqlak
Guest
Posts: n/a
 
      09-11-2004
Hi Everyone,

I have ASP.NET application which is working fine in the Country lever
having 20+ remote users. Speed, performance everything is ok with
current sytemd design and logic I applied for application.

I' have report called "abc" which dataeader to populate data (SQL
SERVER) into to grid. In the grid, each rows had command button whcih is
basically show another grid with details of rows user cicked. To provide
details system will make round trip to sever to get the details.

Now, other country (all of them are in the same network) want use this
application. To know the application performance I ran the report "abc"
from other country which really takes time to populated the data into
grid. I though it will take much time if user click "detail" command
button which basically make a rounf-trip to server.

To avoid this, I'm thiniking of using DataSet and Adaptor to keep the
data offline. So when user click "detail" command button, not required
round-trip to server to get the details since the data is already in the
"dataset"

but, when I was testing using dataset from dev't machine. I noticed that
sytem takes time to show the grid even excution of the following lines.
Any idea why ?


cmd1.CommandType = CommandType.StoredProcedure
cmd1.CommandTimeout = 300
cmd1.CommandText = "[Services].[dbo].COB_WC_Vs_OK_NEW"
cmd1.Connection = objConn
If objConn.State = 0 Then objConn.Open()

Dim da1 As New SqlDataAdapter
Dim ds1 As New dsCOB_KPIS
da1.SelectCommand = cmd1
da1.Fill(ds1.tbl_WCvsOK_Sum)

Me.MainGrid.DataSource = ds1.tbl_WCvsOK_Sum
Me.MainGrid.DataBind()

exit sub


also I have another issue.

currently the SP return only one SELECT statement which returns data
from a TEMP table and fills the DataSet.

I need to return 2 set of data (2 SELECT statements) from my SP from
TEMP table and each set of data to be filled in different tables of
DataSet. How can I do this ?.

If I use datareader, I can have data from multiple SELECT statments from
the SP. I can't fill a dataset using datareader.

Many thanks in advance..

Regards,


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Absolutely the fastest data grid control on the world Pril ASP .Net 0 07-08-2006 05:12 PM
Absolutely the fastest data grid control on the world Pril ASP .Net Web Controls 0 07-08-2006 04:55 PM
Populate a popup window with clickable records from an Access DB and upon clicking, populate a selectbox on the original webpage with the clicked record Enjoy Life ASP General 2 02-23-2005 10:48 PM
Populate Data Grid at Client side Vijay Kerji ASP .Net Web Controls 1 11-24-2004 06:52 AM
Fastest 5 mp Digital Camera ? Fastest 4 mp Digital Camera? photoguysept102004@yahoo.com Digital Photography 6 10-28-2004 11:33 AM



Advertisments