update a record in a form

Posted on 2006-05-23
Last Modified: 2010-04-16
I have a form that is used to update a record from a sql table. This page will load with a value being retrieved from a querystring.
The value is from the querystring and a call is made to a WS that returns the record (that is to fill all the fields in the form) which then allows the user to update this record. Not delete or add a new record just update.
Having said that, with many different ways to do this, what is the best way and recommended approach.

There are about 40 fields, which include drop down, radio buttons and text area fields.
Question by:chicabow
    LVL 6

    Expert Comment

    You should used Typed DataSet for this.
    Explore This page to learn about typedDataSet

    Best regards
    Adil Fazal
    LVL 6

    Expert Comment

    LVL 1

    Author Comment

    Thanks for the links. I have reviewed the docs and well i am not building a Windows  new Console C# project. This is to be a web application.
    So are Typed DataSet, the ideal solution for what am i looking for? If so, please explain why.
    LVL 6

    Accepted Solution

    Hello Dear
    following are some point why typed dataset is better then Dataset.
    First typed dataset Separates datalayer form business logic
    Second Easy to use VS genrates code visually
    Third Easy to write custom methods
    Forth Easy to update, insert, delete (All DDL operations)

    Explore these pages.;en-us;320714

    Best of Luck

    Adil Fazal

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Bit flags and bit flag manipulation is perhaps one of the most underrated strategies in programming, likely because most programmers developing in high-level languages rely too much on the high-level features, and forget about the low-level ones. Th…
    Article by: Najam
    Having new technologies does not mean they will completely replace old components.  Recently I had to create WCF that will be called by VB6 component.  Here I will describe what steps one should follow while doing so, please feel free to post any qu…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    759 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

    11 Experts available now in Live!

    Get 1:1 Help Now