Can we bind 1 Lakh Records to DataSet

Question

1.00/5 (1 vote)

See more:

ASP.NET

Hi friends,

can i bind one Lakh records to dataset, What happend if i bind, please suggest me.

Posted 1-Jul-14 1:16am

Baroor

Add a Solution

Comments

Kornfeld Eliyahu Peter 1-Jul-14 7:26am

DataSet can hold millions of records, but for what purpose? What would you do with that amount of records? Bind to where? Display it? On what surface?

Awadhendra Tripathi 1-Jul-14 9:15am

after binding 1 lakh records what you will do with that records :)

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

DamithSL · Answer 1 · 2014-07-01T01:26:00

The maximum number of rows that a DataTable can store is 16,777,216.
reference:http://msdn.microsoft.com/en-us/library/system.data.datatable.aspx[^]
you can go up to that but large number of records will lead many other issues like, network timeouts, memory issues, performance etc..
you better rethink about your application architecture

Chakravarthi Elchuri · Answer 2 · 2014-07-02T08:53:00

Yes you can add 1Lak records to dataset.
For this here you can do like this
1.Read all the records and Split the records into 10000 or 25000 through your code
2.Use threads to process the records(Store data into database)

Benefits:
With this you can easily find how many records are not get inserted or updated and save the failed records into a separate CSV or Excel file
No network issues.

Can we bind 1 Lakh Records to DataSet

2 solutions

Solution 1

Solution 3

Add your solution here

Preview 0