how to edit a DataGridView which is bound with a Collection

Question

0.00/5 (No votes)

See more:

Hi Friends,

I have a DataGridView which is bound with the Business object Collection. The Grid populates the Order detail(OrderDetailId,ItemCode, ItemName,Qty,Rate,Amount...) data.

Now I want to edit the item row through grid. The idea is when I click on itemrow in the grid it should fill the row data in the respective controls placed just above the grid(suppose Itemcode cell value in the Itemcode textbox...). after making the necessary changes in the row data user just click on update button and it updates the Grid data even in the Business object collection.

could you please help me what is way to implement this? Do you have any in hand example or you can just give me outline of the logic.

I will appreciate your valuable efforts.

Thanks

Posted 10-Jun-10 23:15pm

rajeshswami27

Updated 10-Jun-10 23:17pm

v2

Add a Solution

3 solutions

Solution 3

Thank you very much Henry

now I have two approaches receiving attention to implement this.

1) Either I retrieve the object through DataBoundItem property for the current row and update the object through the editing control thereafter it will be updated back in the collection as well as in the Grid.

2) Secondly I use the Uniquekey to update the object as you explained.

But I want to know which one perform best when the grid is having a number of records and also heavy business validations implemented in the entity class while user is updating the records.

I think both are perfect :)

Posted 11-Jun-10 1:56am

rajeshswami27

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)

Hristo-Bojilov · Accepted Answer · 2010-06-11T00:56:00

Solution 1

Why haven't you tried accessing collection item bounded to DataGridViewRow using DataBoundItem property.Afterward cast it to the items type and and last edit it and refresh the bindings if needed.

Posted 11-Jun-10 0:56am

Hristo-Bojilov

Comments

rajeshswami27 11-Jun-10 7:37am

Hi Hristo Bojilov

Thanks for your quick note.

You put me on the right direction.now it is very easy to handle with a particular object from dgview/collection

http://msdn.microsoft.com/en-us/library/4wszzzc7.aspx

Henry Minute · Accepted Answer · 2010-06-11T01:03:00

Here is a general idea of the logic.

1. when the user clicks the grid (tip: use double-click to avoid accidental triggering when user is just 'looking round') get the DataGridViewRow that was selected, save a reference to a key piece of the data (an identity number or similar), and then pass the row to a method that will:
2. Go through your editing controls one-by-one retrieving the data e.g. myNameTextBox.Text = row.Cells["Name"].Value.ToString()

3. Allow user to edit.
4. When they click the 'Update' button use the key saved earlier to locate the record in your collection and update it e.g. myBusinessObject.Name = myNameTextBox.Text.

What you do next will depend on how your collection is bound to your DataGrid. If you have used a BindingSource (recommended) the grid should update automatically otherwise you will have to re-bind to reflect the changes.

Hope this helps. :)