|
Listing 21-14 extracted from chapter XML
Listing 21-13< > Listing 21-15
This listing can be compiled with the command line: csc.exe /target:exe Example_21_14.cs Errors: 0 Warnings: 0
Example_21_14.cs
using System.Data;
using System.Data.SqlClient;
class Program {
static void Main() {
string sCnx =
"server = localhost ; uid=sa ; pwd =; database = ORGANIZATION";
using( SqlConnection cnx = new SqlConnection( sCnx ) ) {
using( SqlDataAdapter dataAdapter = new SqlDataAdapter() ) {
DataSet dataSet = new DataSet();
string sCmd = "SELECT * FROM EMPLOYEES";
dataAdapter.SelectCommand = new SqlCommand( sCmd, cnx );
dataAdapter.Fill( dataSet, "EMPLOYEES" );
dataSet.WriteXml( System.Console.Out );
System.Console.WriteLine("-----------------------------");
dataSet.WriteXmlSchema( System.Console.Out );
} // end using SqlDataAdapter
} // end using SqlConnection
}
}
Copyright Patrick Smacchia 2006 2007
|