select from BindingList

I have the following Object

PatientEligibilityObject

It has One To Many relation with PatientsE开发者_JAVA百科ligibilitiesDoctorsSpecialties

I fill the Child value into Grid like following : -

 Dim lst = PatientEligibilityObject.PatientsEligibilitiesDoctorsSpecialties.GetNewBindingList() 

It fills the grid with All Columns in the Table PatientsEligibilitiesDoctorsSpecialties

ID

PatientsEligibilityID

DoctorSpecialtyID

RegDate RegUserID

RegComputerID

CancelDate

CancelUserID

CancelComputerID

Instead Of Column DoctorSpecialtyID i want to Display

DoctorSpeciality.Code And DoctorSpeciality.EngName

Notice that there is a foreign key between PatientsEligibilitiesDoctorsSpecialties and DoctorsSpecialties

Would the sample in MSDN

where they explain how to modify columns in a DataGridView bound to a table, help you? You remove one column and insert a different style column in it's place.

I used Datatable filled using LINQ query in which i could be able to select relational table >>