Load data in windows form without closing form

Question

0.00/5 (No votes)

See more:

Hello friends,

I am having a problem. I am using SQL Server as my DB. All is well with loading, adding, deleting data.

Problem is when i insert a record in database:
After inserting a record, it does not show properly in the form unless i close the form and reload it again. Is there any method in VB.net or C# by which we can refresh the table and can load it in the form same time without restarting the form?

thanks:)

Posted 29-Apr-10 17:55pm

satendra negi

Updated 29-Apr-10 19:27pm

Sandeep Mewara

v2

Add a Solution

6 solutions

Solution 6

By the way I got my answer [;)] by myself ..... it was just a line of code [:D]

Thanks yaaro for help

Posted 9-May-10 2:03am

satendra negi

Comments

Ondeda 27-Aug-10 5:47am

hi, what was your solution. I seem to be stuck on finding one

Solution 4

WEll thanks all friends for answering and all answers are usefull 10/10

but let me provide some more input ...

i have a function for loading data binding to textboxes etc like

VB

Private Sub filldata()
        Try
            'Dialog2.DataGridView1.DataSource = dBind
            TxtName.DataBindings.Add(New Binding("Text", dspd, "Patient_details.Pname"))
            TxtBedNo.DataBindings.Add(New Binding("Text", dspd, "Patient_details.Pbedno"))
            TxtDr.DataBindings.Add(New Binding("Text", dspd, "Patient_details.pdoc"))
            TxtClass.DataBindings.Add(New Binding("Text", dspd, "Patient_details.pclass"))
            TxtDisease.DataBindings.Add(New Binding("Text", dspd, "Patient_details.pds"))
            TxtDOA.DataBindings.Add(New Binding("Text", dspd, "Patient_details.pdoa"))
            TxtMedicine.DataBindings.Add(New Binding("Text", dspd, "Patient_details.pmd"))
            comboId.DataBindings.Add(New Binding("Text", dspd, "Patient_details.pid"))
        Catch ex As Exception
            MsgBox(ex.ToString())
        End Try

but problm is that when i am calling this function again for binding again after inserting data... its showing error that .......

>> System.ArgumentException:this causes two bindings in the collections to bind the same property
:O

Posted 30-Apr-10 22:59pm

satendra negi

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 · Accepted Answer · 2010-04-29T19:33:00

satendra negi wrote:
After inserting a record, it does not show properly in the form unless i close the form and reload it again. Is there any method in VB.net or C# by which we can refresh the table and can load it in the form same time without restarting the form?

Yes, when you modify your data, you need to rebind your form to the data source so that it updates to reflect changes in the database. Set the datasource and databind again.

Henry Minute · Accepted Answer · 2010-04-30T02:14:00

Solution 3

The BindingSource[^] Component is your friend.

Particularly the BindingSource.ResetBindings[^] Method.

In addition to that look up BindingSource.ListChanged event on MSDN/Google/Bing/Yahoo. You will find lots of interesting and useful stuff.

Good luck! :)

Posted 30-Apr-10 2:14am

Henry Minute

Wayne Gaylard · Accepted Answer · 2010-05-02T22:38:00

Solution 5

You need to set the DataSource to nothing before you try to rebind.

Posted 2-May-10 22:38pm

Wayne Gaylard

hiren soni · Accepted Answer · 2010-04-30T01:48:00

Solution 2

Its simple.... what you are doing when your form loads?? write it in one procedure. and call that procedure on form load. When u finish your saving or modifying or deleting data call the same procedure. You dont need to close the form.

Hope this will work.

Posted 30-Apr-10 1:48am

hiren soni

Load data in windows form without closing form

6 solutions

Solution 1

Solution 3

Solution 5

Solution 6

Solution 2

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us