saving xml file into the database table using C#

Normaly when you write an insert to a table, the fields needs to match ,even the Data-types, unless you want to do something that will mimic a select into, that means a table with that name should not exist., but you insert data in a table that does not match with Column data-types

Thank you for posting at Dotnetfunda
[Administrator]

Kmathusudan, if this helps please login to Mark As Answer. | Alert Moderator

Hi Kmathusudan

Try The below link you get your solution, if not then let me know i'll made a sample project for you.



http://support.microsoft.com/kb/311566

http://www.java2s.com/Code/CSharp/XML/SavedatainDataGridintoXMLfile.htm

Kmathusudan, if this helps please login to Mark As Answer. | Alert Moderator

I need the following situation to be implemented:
I want to read the XML file(not the entire content but only 4 XML tags) and store in a database.
The link provided by Er.deepakdalal ask to create a new windows application.
My intention is that the program should run daily via windows scheduler, since there will always be a new file scanned every-time
However my question is :
is it possible that a program can be written in C# and its exe be executed daily via scheduler?
Could anyone please help me with a sample code to do this?

Kmathusudan, if this helps please login to Mark As Answer. | Alert Moderator

http://www.java2s.com/Code/CSharp/XML/SavedatainDataGridintoXMLfile.htm

Regards,
Susan

Kmathusudan, if this helps please login to Mark As Answer. | Alert Moderator

Thanks Susanthampy!

Kmathusudan, if this helps please login to Mark As Answer. | Alert Moderator