How can I create a CRUD operation withing winforms datagridview?

Question

0.00/5 (No votes)

See more:

I want to perform CRUD operation within datagrid of winforms just like I do it in ASP.Net Gridview. But When I saw the events I just could not understand which one to use and how.
Can any one get me a good link for CRUD using winforms datagrid?. Or a hint on flow of events.
For example I need to insert when a row is left(another one created or row leave etc) or something like that.
I need all the operations inside grid,no form.
I tried searching but approximately all of the results are using a separate form for insertion.I need the insert part first.

I think you are getting my point otherwise I'll try to rephrase my question.
Thank You.

Posted 26-Mar-15 1:23am

Manvendra Singh

Add a Solution

Comments

CHill60 26-Mar-15 7:54am

This CP article (with demo code) might get you started ADO.NET for the Object-Oriented Programmer – Part Two[^]

Manvendra Singh 27-Mar-15 0:17am

Thank you Chill60. I am going through it. By the way I am doing insertion of row on rowleave. Is it a good idea?

CHill60 27-Mar-15 5:33am

I personally prefer my Users to have to take a specific action (e.g. a save button), but then I rarely trust my users ;-) I have seen commercial software save data on rowleave so it's ok to do that too.

Manvendra Singh 27-Mar-15 3:59am

Now got another problem. I set a cell with autocomplete. Now row leave is firing even when I am selecting an item from that autocomplete. I don't want that. How to stop it. Any suggestions?

To me datagridview in winforms looks like a road full of potholes . You come out from one and fall into another:-)

CHill60 27-Mar-15 5:36am

Not sure about this one - I'll have a play around when I get an opportunity - In the meantime have a look at the validation properties to see if anything springs out.
As per my previous comment - I tend to have a form-style of input so rarely use DataGridViews for input. Might be old-fashioned but I don't hit these sorts of problems ;-)

Manvendra Singh 27-Mar-15 6:57am

I do the same thing but this is the requirement of the client who first made me switch to winforms(he wants everything local..i.e fast+ he learned something about winforms from somewhere) and now he wants inline editing as he likes Excel very much and wants the entry form to be the copy of it.:-)

Manvendra Singh 30-Mar-15 2:07am

Row leave fires every time I leave the row(as expected) but I want it to fire only when A row has data in it. Is it possible??

CHill60 30-Mar-15 8:57am

No. But you can check for data as you leave

Manvendra Singh 1-Apr-15 2:32am

One more question for u. How to fill other textboxes when selecting an autocomplete item.
For example if an item is selected in winforms datagrid,rate and unit should be filled automatically. Any ideas??

CHill60 1-Apr-15 2:47am

You could populate them in the Leave event or (probably better)in the SelectedIndexChanged event

Manvendra Singh 1-Apr-15 5:15am

Got it on leave event. Thank you Chill60. Your suggestions are very good and helpful and in this way you are an integral part of the project whether you are in front of me or not.:-)

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)