display data into datagridview from foreign key table through id from primary key table in c#

[AftabSoomro]

Hi everyone

Can anyone help me, to resolve this issue below?


I have two tables in Sql Server, In first customers table the fields are CustomerID, CustomerName and Address

and Second table customerPaymentDetails the Foreign key table in which columns are ID, CustomerID as foreign key, dateOfPayment, amount


table name are = customers and customerPaymentDetails


Now I want to display foreign key table data on the c# form, using combo box in which customerName is taken from customers table then it should display the foreign key related data in DataGridView by selecting customerName from combo box.

Continue reading...