Insert records with Databound TextBox (Windows Forms)

Question

0.00/5 (No votes)

See more:

Hi all,

I'd like to know if there's a general practice for inserting (new) records into a DataSet through databound controls.

The scenario is the following: I have a dataGirdView that displays a list of the records and some textboxes bound to the same dataset that display each field separately.

I can edit a record (using the textboxes) and then call dataSet.AcceptChanges(), however, adding a new row to the dataset is a different story. After I create the row I can't position my dataset to it, therefore I can't use the textboxes to populate the fields with data.

Maybe my problem is that I'm trying to approach this "the Delphi way". Any help is much appreciated!

Thank you all,
blizzard

Posted 21-Dec-09 10:48am

lackonagy

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Christian Graus · Answer 1 · 2009-12-21T10:54:00

I NEVER use any of that 'accept changes' crap. I write a proper data layer, and call it to update, insert or delete records. You can't data bind a textbox, as far as I know, although you can create edit/insert templates. In any case, if the template lets me create inline editing or inserting, I'd still expect to write my own code to call a data layer I control to do the insert. Then, you just rebind the grid to the data source and your insertion will be there.

Mycroft Holmes · Answer 2 · 2009-12-21T11:14:00

I agree with CG, you need to understand and use a Data Access Layer (DAL), it is fundamental to controlling you development.

I would also add that you should look at NOT editing in a list control. I always pop a dialog for any CRUD operations and never edit within a list control. This gives you complete control of the data, you can use binding in the dialog, manage any defaults and insure the data is written to the database. Then close the dialog and and reload the list.

Insert records with Databound TextBox (Windows Forms)

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0