How to check if XML element name is equal to database field name in ASP.Net

RamThila...

Hi,

I have to check if XML Element name is equal to db table column name in c#.net

Iam using data access layer for sql commands.

Ex,

if XML Element name is Userid the same name must be exist in the db table column name(Uerid)

if the column does not exist in the table the value should not be stored.

Mudassar

0 2

You can check the names of columns in Table using the following query

SELECT name FROM  sys.columns WHERE object_id = OBJECT_ID('Users')

But your idea in actual implemetation is very difficult as checking each column and saving data is a lengthy as well as time consuming process