using System.IO;

using System.Data;

using Ingres.Client;

 

class App

{

static public void Main()

{

string myConnectionString =

"Host=myserver.mycompany.com;" +

"User Id=myname;PWD=mypass;" +

"Database=mydatabase";

IngresConnection conn = new IngresConnection(

myConnectionString );

conn.Open(); // open the Ingres connection

 

string cmdtext = "select table_owner, table_name, " +

"create_date from iitables " +

" where table_type in ('T','V') and " +

" table_name not like 'ii%' and" +

" table_name not like 'II%'";

IngresCommand cmd = new IngresCommand(cmdtext, conn);

 

//          read the data using the DataReader method

IngresDataReader datareader = cmd.ExecuteReader();

 

//          write header labels

Console.WriteLine(datareader.GetName(0).PadRight(18) +

datareader.GetName(1).PadRight(34) +

datareader.GetName(2).PadRight(34));

int i = 0;

while (i++ < 10 && datareader.Read())

// read and write out a few data rows

{     // write out the three columns to the console

        Console.WriteLine(

        datareader.GetString(0).Substring(0,16).PadRight(18) +

        datareader.GetString(1).PadRight(34) +

                datareader.GetString(2));

}

datareader.Close();

DataSet  ds  = new DataSet("my_list_of_tables");

//          read the data using the DataAdapter method

IngresDataAdapter adapter = new IngresDataAdapter();

adapter.SelectCommand = new IngresCommand(cmdtext, conn);

adapter.Fill(ds);  // fill the dataset

 

//          write the dataset to an XML file

ds.WriteXml("c:/temp/temp.xml");

 

conn.Close();   // close the connection

}  // end Main()

}  // end class App