2 database connection in c#

Question

Hello everyone,

I want to get data from an odbc connection and copy the data into sql server table. The scenario is like this, I want to open odbc connection, then get the data into something(actyally the data is in tabular format), then open the sql connection and then whatever the data we took from the odbc connection, want to dump(store) into sql server table or say just want to copy the odbc tabular format data into sql server database. please guide me something, I am new to c#.

Advance Thanks...

Raj