-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: Arpitha6
Message 8 in Discussion
HI Kalpesh,
I am doing the first approach what u have told me...But I have a problem in
this .
It is creating its own tags, but i want to add custom tags.
I am attaching the code snippet..
String strConn;
string sname;
string filename = "C:/myXmlDoc.xml";
System.IO.FileStream myFileStream = new
System.IO.FileStream
(filename, System.IO.FileMode.Create);
System.Xml.XmlTextWriter myXmlWriter =
new System.Xml.XmlTextWriter(myFileStream,
System.Text.Encoding.Unicode);
strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\question test.XLS;Extended Properties=Excel 8.0;";
sname="Sheet1$";
OleDbConnection oConn = new OleDbConnection();
oConn.ConnectionString = strConn;
oConn.Open();
OleDbDataAdapter oCmd = new OleDbDataAdapter("SELECT
* FROM [" + sname + "]", oConn);
DataSet oDS = new DataSet();
oCmd.Fill(oDS);
oDS.WriteXml(myXmlWriter);
myXmlWriter.Close();
oConn.Close();
This is working fine but, In this I want to add my custom tags. Can u please
help me out.
Thanks,
Arpitha
Software Engineer
Ivega Corporation
Bangalore.
**********************************************************Disclaimer***************************************************************************************************************************************
This is a transmission from Ivega Corporation Private Limited (Ivega), and may contain
information that is privileged and confidential. Ivega assumes no responsibility for
damages resulting from unauthorized access, disclosure, tampering or delayed receipt,
which could have occurred during transmission. If you have received this transmission
in error, please destroy it and notify the sender immediately.
Further, Ivega assumes no responsibility for any opinions, conclusions and other
information in this message that do not relate to its official business.
*************************************************************************************************************************************************************************************************************
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
