Best data structure for a large database application

Posted on 2006-04-12
Last Modified: 2008-01-09


I have a really large db application and it needs to do basic operation such as insert, modify, and delete records...

For example, one of the task is to read about 30 000 entries in the Excel file and import it to the database.

What is the best data structure to be used in this situation? (dataset, arraylist, etc...) ?

Thanks for your help
Question by:TungVan
    LVL 1

    Accepted Solution

    its good to use dataset
    LVL 41

    Assisted Solution

    Actually, I wouldn't be too concerned about the "data base structure" at the client end.... as much as how I plan to manipulate the data at the server end.  The "traditonal" ADO.Net disconnected model isn't well suited for doing 30,000 inserts into a database.

    So, I'd be thinking about how I could iterate thru the Excel file in "chunks" and use stored procedures at the database end to do the inserts.

    ...this making sense?

    Tell us more about the language you're using (, the version of the .Net framework (v2.0?), and the database (SQL Server 2005?), etc.

    Author Comment


    I am using C#, .Net 1.1 and SQL Server 2000
    LVL 41

    Expert Comment

    OK, that's what we needed to know.

    Here is a good article on how to simulate a "bulk copy" inserts using XML and stored procedures.;en-us;315968

    I'd put my effort on that "end" of the solution, and not worry about how to store the data in the client.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Flash ( has evolved over the years to where it has become a masterful tool for displaying content screen.  It has excellent layout placement, UI precision as well as rendering capabilities. This, along with t…
    A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now