<div>
I suggest you review this article and some of the articles it links in its footnotes:<br />
<br />
<a href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vbconDataSets.asp" rel="ugc nofollow">http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vbconDataSets.asp</a>
</div>


I suggest you review this article and some of the articles it links in its footnotes:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vbconDataSets.asp [http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vbconDataSets.asp]

<div>
<div class="content wysiwyg-content">
I have a program where I have one form that contains a DataGridView which is bound to a SQL Server Table. When the user selects a row from the grid...another form (maintenance form) will pop up containing the data from the grid. The user will then make changes to the data and then save the data and have it immediately reflect the changes in the grid on the first form.<br />
<br />
Unfortunately, I'm not sure how to code for this in the maintenance form.<br />
<br />
What I'm thinking is that I need to make a reference to the dataset object (linked to the grid), in the maintenance form where I make the changes. I was thinking of something like this.<br />
<br />
<br />
'The following Event is in the Maintenance Form<br />
Private Sub btnSave_Click() <br />
&nbsp; &nbsp; &nbsp; &nbsp;'Make a reference to the Form containing the Grid<br />
&nbsp; &nbsp; &nbsp; &nbsp;frmProducts.dsEmployee.Tab<wbr />les(0).Row<wbr />s(?).Item(<wbr />&quot;Category&quot;<wbr />) = cmbCategory.Text<br />
End Sub<br />
<br />
dsEmployee is the DataSet bound to the grid.<br />
<br />
I hope I've explained myself adequately.<br />
<br />
Thanks,<br />

</div>
</div>


I have a program where I have one form that contains a DataGridView which is bound to a SQL Server Table. When the user selects a row from the grid...another form (maintenance form) will pop up containing the data from the grid. The user will then make changes to the data and then save the data and have it immediately reflect the changes in the grid on the first form.

Unfortunately, I'm not sure how to code for this in the maintenance form.

What I'm thinking is that I need to make a reference to the dataset object (linked to the grid), in the maintenance form where I make the changes. I was thinking of something like this.


'The following Event is in the Maintenance Form
Private Sub btnSave_Click() 
       'Make a reference to the Form containing the Grid
       frmProducts.dsEmployee.Tables(0).Rows(?).Item("Category") = cmbCategory.Text
End Sub

dsEmployee is the DataSet bound to the grid.

I hope I've explained myself adequately.

Thanks,


Modifying form data and showing reflected change in another form at same time???

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.