Queried Data to be Updated

Posted on 2006-03-30
Last Modified: 2010-04-17
Here is my situation:

A value is entered into a textbox.  This value is then used against a query that fills several other textboxes.  The values that are entered into all the textboxes need to then be inserted, updated or deleted against the database.

I've tried binding the textboxes to a dataset and using a data adapter to update it, but I can't figure out how to get it to query the record and update the database.

Should I use a series of sqlcommands instead?  Is the data adapter a better route?  How can I make this work?  Please include sample code.
Question by:enlightec
    LVL 4

    Expert Comment

    Please explain which kind of Database you are using and what programming language you are talking about. Thanks
    LVL 1

    Author Comment

    I apologize.  I meant to post this in VB.NET.

    I'm using ADO.NET in VB.NET 2003.  I'm accessing a MS SQL Server database.
    LVL 4

    Accepted Solution

    I'm still a little confused. You want the user to input information into the textbox, then preform a query. This queries information should then be displayed in another series of boxes, which if changed should be updated?
    LVL 1

    Author Comment

    Yes, that would work.  Would it be possible to have them enter the queried value in a textbox that would be connected to the dataset?  If not, the way you described it should be fine.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    java ^ examples 8 48
    countPairs challenge 7 39
    firstChar challenge 13 57
    java  and programming certification ? 4 29
    Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
    This article will show, step by step, how to integrate R code into a R Sweave document
    In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    729 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

    20 Experts available now in Live!

    Get 1:1 Help Now