Dynamic Column Mapping

[Bill]

By dynamic mapping, I meant that before the records are
transferred from one table to the other(source to target),
the xml file which will have the field names of the two
tables mapped, is to be checked so that while formulating
the "insert into" statement, the column names of the
target table should match that of the source table.

-----Original Message-----
Bill,

Could you clarify what you mean by "check mapping file dynamically"?
--
Kathleen Dollard
Microsoft MVP
Author "Code Generation in Microsoft .NET"
"Bill" <an*******@discussions.microsoft.com> wrote in messagenews:02****************************@phx.gbl...

Hi,
I need to take out records from one table and insert it
into another identical table via a C# application.Is there a way to dynamically determine the corresponding columns
of the two tables ?

If I use an XML file to map the corresponding columns of
the two tables, how do I check the mapping file
dynamically before data insertion ?

Any help is appreciated.

Thank You