How to call & display multible tables datas in dotnet c# with MySql with crystal report by programmatically

Dear All,

How to call & display multible tables datas in crystal report by programmatically dot net c# with MySql.

Kindly help me to complete my pending task in my project.

Table Name: BILLS / FIELDS: BILL_NO, AC_YEAR, BL_DT, SOME ADDL FIELDS; / BILL_NO = AC_YEAR

Table Name: BILL_DATA / FIELDS: BILL_NO, AC_YEAR, BL_DT, PROCESS_SLNO, PROCESS_STAGE, SOME ADDL FIELDS; <-> MULTIBLE DATA RECORD>

Table Name: BILL_EXP / FIELDS: BILL_NO, AC_YEAR, BL_DT, PROCESS_SLNO, PROCESS_EXP_SLNO, PROCESS_EXP_AMT, SOME ADDL FIELDS; <-> MULTIBLE DATA RECORD>

Table Name: BILL_OUT / FIELDS: BILL_NO, AC_YEAR, BL_DT, PROCESS_SLNO, PROCESS_EXP_SLNO, BL_OUT_DT, PROCESS_STATUS, SOME ADDL FIELDS; <-> MULTIBLE DATA RECORD>