i have list which has more than 4000 row data,it takes much

Babloo

However this function working smoothly for small and average data sets which means if number of rows less to 1000 this is loading with much time

NewSaleMasterModel lst = (from newsale in _dbContext.proc_GetAllNewSale()

where newsale.NewSaleID == _modelID

select new NewSaleMasterModel

{

NewSaleID = newsale.NewSaleID,

EmployeeID = newsale.EmployeeID,

ProductID = newsale.ProductID,

EmpName = newsale.EmpName,

ProductName = newsale.ProductName,

Salutation = newsale.Salutation,

FirstName = newsale.FirstName,

MiddleName = newsale.MiddleName,

LastName = newsale.LastName,

AccountHolderName = newsale.AccountHolderName,

NewSaleDate = newsale.NewSaleDate,

PhoneNo = newsale.PhoneNo,

AlternatePhoneNo = newsale.AlternatePhoneNo,

EmailID = newsale.EmailID,

DateOfBirth = newsale.DateOfBirth,

StreetAddress = newsale.StreetAddress,

PostalAddress = newsale.PostalAddress,

PaymentMode = newsale.PaymentMode,

CardHolderName = newsale.CardHolderName,

CardNumber = newsale.CardNumber,

CardExpirymonth = newsale.CardExpirymonth,

CardExpiryYear = newsale.CardExpiryYear,

CVV = newsale.CVV,

CardPayTerm = newsale.CardPayTerm,

CardDabitDate = newsale.CardDabitDate,

BankName = newsale.BankName,

BSBNO = newsale.BSBNO,

AccountNo = newsale.AccountNo,

BankDabitDate = newsale.BankDabitDate,

BankPayTerm = newsale.BankPayTerm,

Isactive = newsale.Isactive,

AudioFile = newsale.AudioFile,

RecordingFile = newsale.recordingfile,

StreetState = newsale.StreetState,

StreetCity = newsale.StreetCity,

StreetPostalCode = newsale.StreetPostalCode,

PostalState = newsale.PostalState,

PostalCity = newsale.PostalCity,

PostalCode = newsale.PostalCode,

Reason = newsale.Reason,

CardBankName = newsale.CardBankName,

AgentNotes = newsale.AgentNotes

}).FirstOrDefault();

return lst;

and displying in datatable list

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mohsin Arif7y ago
hi
Amit was saying right.
but if you have worry about code that how much code should i have to do .so dont wory you can use jquery grid which so fast and alot of options please check this link
http://jquerygrid.net/
hope so it would be helpful to you. i suggest use this , this is wonderful with alot of options.
0
Amit Kumar7y ago
Hi Babloo,
Why your are binding whole records(4000) . If you bind whole records then it will take some to load it behalf of this your application performance is very slow.

You can solve it may ways but I am giving a solution which is very helpful for you and your application. Solution: In your application every page will display 50 or 100 records at a time. First create you page no for paging(suppose you want to display 500 records in a page then divide 4000/500= 8 pages) 1 ,2, 3 ....8 and first pagae you diplay only 500 records and your paging will display 1-8.

If you bind 500 records then it bind quickly. If someone click on 2nd page no then you will display 500-1000 (means 500 records again) so you can bind it easliy.
Finally you can bind data on each number click but do not need to show 4000 records at a time.

I hope you will understand my points.If you have any doubt then ask again.
0