i have created a datagrid which link with 2 different tables.

Eg Tables A & Tables B
Using a Combo Box select of Order No, both table A & Tables B information will display in one data grid

Order No -> (Order No) Tables A (Part Code) -> Tables B (Part Code) -> display information

Problem :-
I have already link the data adapter & dataset. anyway, when i execute this program, it display error as below.

Script :-
OleDbDataAdapter2.SelectCommand.CommandText = "select tbl_excel.excel_ord_no, tbl_excel.excel_ord_item, tbl_lead.lead_part," & _
"tbl_excel.excel_part_code, tbl_lead.lead_dc, tbl_excel.excel_qty," & _
"tbl_lead.lead_vendor, tbl_excel.excel_del_status, tbl_lead.lead_time," & _
"tbl_lead.lead_delete FROM tbl_excel LEFT OUTER JOIN " & _
"tbl_lead ON tbl_excel.excel_part_code = tbl_lead.lead_part" & _
"WHERE (tbl_excel.excel_ord_no = '" & cb_ord.Text & "')" & _
"ORDER BY tbl_excel.excel_ord_no, tbl_excel.excel_ord_item, tbl_excel.excel_part_code "

Src_excel_lead1.Clear()
OleDbDataAdapter2.Fill(Src_excel_lead1)

Errors:-
An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll


Can anyone please help me on this problem.

Thank you.

Regards,
Eileen