Speeding up data withdrawal

This problem appeared when I introduced the "translation" function. That function is a simple for loop that checks every row in the dataGridView and based on one columns value, writes a textual value to another column (of DataColumn type, I add it to the myDataSet.Tables[0] when it is filled). This function slows things up significantly   (I displayed the data without it and it loads very quickly).

Hi,

This should be fast.

Because you need the stored procedure should have the parameters some thing like

@PageNumber
@Pagesize
@column
@Sorting

Here when use click on 2nd paging then

@PageNumber = 2
@PageSize = 25
@Sorting = ASC

Here it will return only 25 records from total of 500 records.

You need to check the stored procedure performance by using the query estimation plan and tune it.

Well thats what I'm doing now, I'm using this code:
 
command.CommandText = ".....";
command.Connection = myConnection;
mySQLDataAdapter.Fill(myDataSet);
dataGridView1.DataSource = myDataSet.Tables[0].DefaultView

So far this worked perfectly, but now I have to display a table form database that has almost 500 entries and like I said one of columns is a numerical representative that I need to change into a textual description. I cant use INNER JOIN's because the textual equivalent of that representative does not exist in the database, and I'm not allowed to add new tables, only use the existing ones.
 

Hi Neven,

what you need to do is do not pull the data once into the DataSet or something.

Retrieve the data on demand and using the stored procedure to retrieve the data which is exactly required for the current page in the gridview.

This will help you to improve the performance, because it will not take much time to query the data and avoid huge view state in the client side.

http://www.codeguru.com/csharp/.net/net_asp/controls/article.php/c15145/Custom-Paging-for-GridView.htm