Refreshing DataGridView in form1 after closing form2

Question

0.00/5 (No votes)

See more:

Hello guys,

I have DTG in form1 and I'm inserting values in it using SQLCommand.
When I click button SAVE in form2(which also closes form2) I would like to refresh form1's datagridview.

Is there any solution?
THanks so much.

SQL

SqlCommand prikaz = new SqlCommand
                    ("INSERT INTO ..);
spojeni.Open();
                prikaz.ExecuteNonQuery();
                System.Data.DataTable dt = new System.Data.DataTable();
                System.Data.SqlClient.SqlDataAdapter SDA = new System.Data.SqlClient.SqlDataAdapter("...", spojeni);
                SDA.Fill(dt);

Posted 8-Jul-13 11:28am

mareksip

Updated 15-Oct-13 4:22am

v3

Add a Solution

Comments

[no name] 8-Jul-13 17:54pm

Any solution to what? Requery the data.

3 solutions

Solution 2

May be this help you
While closing the form2 you call the Constructor of form1 and write the logic to update the grid in the constructor

Posted 8-Jul-13 21:19pm

Vipin kumar.P

Comments

mareksip 9-Jul-13 3:46am

Would you please help me with the code?

Member 12341349 17-Apr-16 12:05pm

yes

Solution 3

Well,
after you complete you process inserting data in form2 you have to bind form1 grid again on page load event because if you are not bind it or not refresh that form it should saw old record so you have to write code on page load for binding grid.

This will definitely solve you problem:

http://stackoverflow.com/questions/7797975/how-to-refresh-a-form-from-another-form[^]

http://stackoverflow.com/questions/15896135/how-to-reload-form-in-c-sharp-when-button-submit-in-another-form-is-click

And accept as solution and vote if solve your problem.

Posted 8-Jul-13 21:25pm

jaideepsinh

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)

berrymaria · Accepted Answer · 2013-07-08T14:23:00

Solution 1

Requery the data after clicking the Save Button.

Posted 8-Jul-13 14:23pm

berrymaria

Comments

mareksip 9-Jul-13 4:48am

Would you please help me with the code?

berrymaria 9-Jul-13 5:39am

Hi, please see this examples:

http://stackoverflow.com/questions/14374348/refresh-button-refreshing-data-grid-view-after-inserting-deleting-updating

http://stackoverflow.com/questions/15526067/c-sharp-refresh-datagridview-when-updating-or-inserted-on-another-form