XML, C# and MySQL

[Guest]

Hello Friends,

I hope you can help me with this one. I am doing a web-based project in
asp.net, using c# as the scripting language and MySQL as the back-end
database. I want to construct an XML String from my web-form values and then
from the XML string, I want the values to go in to the MySQL D/Base. Can we
do that in C# in collaboration with MySQL Database. Will look forward to you
useful pieces of advice.

Many Thanks,

Irfan

 

[Derek Harmon]

I want to construct an XML String from my web-form values and then
from the XML string, I want the values to go in to the MySQL D/Base. Can we
do that in C# in collaboration with MySQL Database.

MySQL has a Connector / NET product available which is an ADO.NET Data Provider
for MySQL and .NET, so you can program to MySQL using ADO.NET classes in a
fashion similar to how you would program for OLE DB or SQL Server,

http://www.mysql.com/products/connector/net/

In C#, using the classes in the System.Xml namespace (the first class I'd look at probably
would be XmlDocument) you can also work with XML in a variety of ways. However,
do you have a purpose in mind for the XML in your web application? Why not just take
the web-form values and poke them directly into the MySQL database (why waste time
converting them into XML and then parsing them back out of XML)?


Derek Harmon