How to merge two database together to datagrid c# winsform

Good day everyone please i am working on c# windowsform applicaton for loan i want to join two database base on a particular column. i have two database(employement,loanform) please i want to join the two of them to a new table so there will not be duplicate colums)

database employementform(1st database)

id employementnumber fullname age

1 ts/02/001 adedoyin 40

2 ts/02/003 chisom 25

3 ts/02/012 femi 44

database loanform(2nd database)

id employementnumber amountofloan percent totalamount

1 ts/02/003 10000 10 100000

2 ts/02/003 2500 10 2750

3 ts/02/01 1200 10 1320

4 ts/02/012 60 10 66

i want to join them on a new database to show on a datagridview and i want it to be like this:

database join

id employementnumber fullname age amountofloan percent totalamount

1 ts/02/003 adedoyin 40 10000 10 100000

2 ts/02/003 adedoyin 40 2500 10 2750

3 ts/02/01 chisom 25 1200 10 1320

this is my code

SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\odt\Documents\Loanapp.mdf;Integrated Security=True;Connect Timeout=30");

DataTable dt = new DataTable();

con.Open();

SqlCommand cmd = con.CreateCommand();

cmd.CommandType = CommandType.Text;

cmd.CommandText = "select * from loanform,Registrationform";

cmd.ExecuteNonQuery();

SqlDataAdapter da = new SqlDataAdapter(cmd);

please help thanks.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

James Axsom7y ago
Hi Oladotun,

Use a join in your SQL text. Assign the SQL join to your ADO.Net command.commandtext. I made a sample database with sql text to help you. Please peruse.
SELECT * FROM Customer

SELECT * FROM Loan

SELECT L.ID AS 'Loan Number', C.FirstName, C.LastName, C.Occupation, C.Income, L.Amount, L.Rate, L.[Status]
FROM Customer C
JOIN Loan L ON C.ID=L.CustomerID
Rajanikant Hawaldar7y ago
Hi Oladotun,

Here is solution

https://stackoverflow.com/questions/5145637/querying-data-by-joining-two-tables-in-two-database-on-different-servers

Thanks