xml in to table to database
C#
1
Posts
1
Posters
0
Views
1
Watching
-
hi all i have an xml i am able to change into data table and insert into database also... StringReader xmlsr3 = new StringReader(region); dset3.ReadXml(xmlsr3, XmlReadMode.IgnoreSchema); OleDbDataAdapter da3 = new OleDbDataAdapter("select * from drregion", m_Conn); OleDbCommandBuilder cb3 = new OleDbCommandBuilder(da3); da3.Update(dtab3); dtab3 = dset3.Tables[0]; like this it gets updated now the problem is when xml string has a keywords (of databases) while updating into database that is in the last statement there is an error saying insert into syntax error i need to change the ex: keyfield-desc to [desc] (i could nt do it in xml ) there was another error if i do that how can i do this or is there any other way....