windows generated code

Question

When you drag a datatable onto the form and then drag another data table that is linked to the first table, you have created a master/detail database.  I have it working properly but would like to know where the windows generated code is so I can learn how to program that.  I have looked in the Form1.Designer.VB but it is not there.  When I click on a row in the master table, it fills the detail table.  It must do some type of parameter or query.  Where is that code.  Thank you.

Answer 1

I'm assuming you have a dataset that has a foreign key constraint to link the tables together.  The code would probably be there.  If not there, check the BindingSource.

Answer 2

if you see a dataSet (.xsd) file in your Solution Explorer, you can check out the SataSet.Designer.vb file also

Answer 3

Hi,

I checked into Form1.Designer.vb for the code that you mentioned.  When I ran through an example, assuming Customers is my master table and Orders is my detail table, Form1.Designer.vb contains the following lines of code:

Me.OrdersBindingSource.DataMember = "FK_Orders_Customers"

Me.OrdersBindingSource.DataSource = Me.CustomersBindingSource

'...took out some other lines of code here...'

Me.OrdersDataGridView.DataSource = Me.OrdersBindingSource

Hope that helps,

Yun