hi frds,
I am working with .net envirement with c#. I want to take a table which contain 10 million data or above with the help of dataset. but my application unable to handle due to large amount.

help required

Others who know C# will provide better assistance, but if you're having memory problems, then try to load only the maximal subset of rows of information you need at any one time. For instance, if the user can only see 25 rows of data, then having 10 million in memory isn't helpful. This can complicate queries, but I know that C# has some DB interfaces and you'll definitely do best to use one of them.

Hope that helps a bit. I'm sure others will come in with more pointed advice.

Jeremy is basically right, although C# and SQL interaction isn't really something that comes into play with the answer here. They're cleanly separated, and should be.

There's absolutely no reason you should need 10,000,000 rows in a DataSet, especially in a web application. You know about page life cycle, right? Only request the data you need. The database is responsible for the storage and exposure of data - your application is responsible for whatever processing it does. It should request only the data that's necessary. Precaching the entire database will work against you - as you're seeing.

I can't say all that much more about how to achieve that, without knowing the details of your application.