Developing database application

Posted on 2005-04-23
Last Modified: 2010-04-23
I am looking at developing a datbase app.

Is it best to use a connection everytime the user performs an action (i think this is best) or use dataset with datadapters?

There is a lot of data so i believe the first option is more viable - just looking for further opinions.

Question by:willbdman
    LVL 28

    Expert Comment

    You cannot use dataset and dataadapters without open connection. You need to create a connection (in any case) and then use dataadapter to populate your dataset.
    LVL 8

    Accepted Solution

    It depends on what u are doing to the database. if u are wanting to manipulate data, etc then pull the data to the pc into a dataset do the manipulations and then send back. If u are wanting to lets say populate a combobox with values from a database then use a data reader.

    I really only use dataset when I am going to have some crystal reports, or datagrid. Most of the time I use reader, but then again I don't really have that many programs that manipulates a lot of data.

    LVL 6

    Author Comment

    I know you always need a connection, the difference is the datareader performs the actions directly, the data adapter grabs the required data allows you to modify it then send it back later.

    I will be pulling data but only a record at a time.

    E.G. list of say outlets clicking on one brings up the outlet in more detail.

    What are crystal reports?

    Is there anyway of producing reports for printing using VB.NET?
    LVL 13

    Assisted Solution

    I would open and close a connection everytime the user performs an action.  It really doesn't save alot of time by just keeping one connection open the entire time, in my experience.

    Crystal reports is a program that lets you create very detailed/business oriented reports.

    Crystal does have a plug-in for VB.NET if you own the professional version of VB.NET.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Article by: jpaulino
    XML Literals are a great way to handle XML files and the community doesn’t use it as much as it should.  An XML Literal is like a String ( Literal, only instead of starting and ending with w…
    Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    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

    23 Experts available now in Live!

    Get 1:1 Help Now