C# .NET DataReader WriteXml Extension Method using CsvDatabase Library

Created By: Dominic Sputo
Call me 813.750.5459

[organicprogrammer]

//Writes a XML File using DataReader WHERE CustomerID = Note Overwrites old file.
CsvDataReader dtr9 = new CsvDataReader(System.IO.Path.GetFullPath("OrderLines.txt"), "CustomerID =

DataSet ds = new DataSet();


//Writes a XML File using CSV File WHERE CustomerID IN OR Note Overwrites old file.
CsvToXml.WriteXml(System.IO.Path.GetFullPath("OrderLines.txt"), System.IO.Path.GetFullPath("OrderLines.xml"), "CustomerID IN
DataSet ds2 = new DataSet();


//SQL Server Data to XML File using Extension Method WriteXml(New_XML_File). Note Overwrites old file.
SqlConnection conSQLServer = new SqlConnection(@"Data Security=True");
SqlCommand cmdSQLServer = new SqlCommand("SELECT Top 100 * FROM million", conSQLServer);
conSQLServer.Open();
SqlDataReader dtrSQLServer =
100 SQL Server.xml"));
conSQLServer.Close();

//Import Oracle Data to XML File using Extension Method WriteXml(New_XML_File). Note Overwrites old file.
OracleConnection conOracle = new OracleConnection(@"User
OracleCommand cmdOracle = new OracleCommand("SELECT * FROM million WHERE rownum <= 100", conOracle);
conOracle.Open();
OracleDataReader dtrOracle = cmdOracle.ExecuteReader();
100 Oracle.txt"));
conOracle.Close();