GET DATA FROM MULTIPLES TABLE IN ONE FORM USING C#

Question

ASSALAM-O-ALIKUM TO ALL OF YOU;

SIR, MY QUESTION IS "HOW WE CAN GET DATA FROM MULTIPLES TABLE IN ONE FORM USING C#". FOR EXAMPLE, I HAVE THREE DIFFERENT TABLES ONE IS SURGERY(SURGERY ID,SURGERY NAME, CHARGES, SURGERY TYPE ID), SECOND IS SURGERY TYPE(SURGERY TYPE ID, SURGERY TYPE NAME), THIRD IS PATIENT SURGERY(SURGERY ID,PATIENT VISIT ID,CHARGES). SO I WANT DATA OF THESE TABLES IN MY MAIN SURGERY FORM.

REGARDS
SUMAIRA MANZOOR