Pulling information from one database to another and show it in datagridview form

[wertqt]

Hi all,
Im using C#.Net to write a program on updating system (autoamtion project).
However, im new to this language and does not have much knowledge on it.
I have some doubts on the source code part.

Qn : Can i pull information from a database to another database and show them in a windows form?

i had created a form with 2 datagridview connected to their respective database. In this case, i need to pull information from some columns in datagridview1 and show it in datagridview2, but the column name in datagridview1 is different from that in datagridview2.
How do i write the source code for this function in the program?

After this function, how can i save user input (written in the datagridview) to the database?

Please help! It's urgent.
Your help will be greatly appreciated!

Thanks in advance! =D

[junal]

do you have any relation between these tables?

[wertqt]

yes there there is relation between these 2 tables.
Some of the columns in database1 has the exact information that i want to pull it into database2 columns.
The thing is, the column header name in database1 are different from that in database2.

For e.g, :
in database1, i have a field(column) called 'Date'. I want to pull this column information into database2 under a column name 'StopDate'.

How can i achieve that?

Thanks for replying =P