Dear All,
Greetings of the day...
I am learning C# with Windows application and in a form I want to get a crystal report of employee details. there are two databases and the data will be fetched from two tables i.e. T1 table from DB1 database and T2 table from DB2 database. I am applying inner join to fetch record.
DB1=Employees, T1=EmpDetails.
DB2=Masters, T2=City.
I am trying to fetch EmpName, EmpDesig, EmpDoj from DB1 and EmpCity from DB2.
Please see the code...
private void btnShow_Click(object sender, EventArgs e)
{
//OleDbDataAdapter ShowEmp = new OleDbDataAdapter("Select Experiments.Employee.EmpName,Experiments.Employee.EmpDoJ,Experiments.Employee.EmpDesignation,ExperimentsMAS.MasterCity.CityName From Experiments.Employee Inner Join ExperimentsMas.MasterCity On Experiments.Employee.EmpCity=ExperimentsMAS.MasterCity.CityID Where Experiments.Employee.EmpName=" + cmbEmployee.Text, MyConn);
//OleDbDataAdapter ShowEmp = new OleDbDataAdapter("Select EmpName, EmpDoj, EmpDesignation From Experiments.Employee as T1 Inner Join MasterCity ExperimentsMAS.MasterCity as T2 on T1.EmpCity=T2.ID", MyConn);
//OleDbDataAdapter ShowEmp = new OleDbDataAdapter("Select a.*,b.* From Experiments.dbo.Employee as a left join ExperimentsMAS.dob.MasterCity as b on a.EmpCity=b.ID", MyConn);
DataSet dsShowEmp = new DataSet();
ShowEmp.Fill(dsShowEmp);
CR_MultiDB XYZ = new CR_MultiDB();
XYZ.SetDataSource(dsShowEmp.Tables[0]);
CRVEmployee.ReportSource = XYZ;
}
Three queries from different sources of net (google, of course) but none of them works.
I run inner join from same DB but I want to join two tables from two database.
Please note that... 1. I use MS Access as database. 2. It's Windows application, and 3. please show me other simple mathod to do this, if any.
Thank you.
Mayank Jani.