Home
Browse all 647 examples
Download all 647 examples
Download sample chapters
Reviews
Errata
Acknowledgments
Links on .NET
Paradoxal Press

Buy directly from Paradoxal Press at $33.99 (Save 43%)



Category: Programming
Level: Beginner to seasoned
900 pages
ISBN-10 097661322-0
ISBN-13 978-097661322-0
$59.99 USA
$79.99 CANADA


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";
      usingSqlConnection cnx = new SqlConnection( sCnx ) ) {
         usingSqlDataAdapter 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