>using System; >using System.Data; >using System.Data.OleDb; > >namespace ConsoleApplication2 >{ > /// <summary> > /// Summary description for Class1. > /// </summary> > class Class1 > { > /// <summary> > /// The main entry point for the application. > /// </summary> > [STAThread] > static void Main(string[] args) > { > String myConnectionString; > myConnectionString = "Provider=SQLOLEDB;Data Source=YOURSQLNAMEHERE;Initial Catalog=Northwind;" + > "User Id=sa;password=;"; > OleDbConnection myConnection = new OleDbConnection(myConnectionString); > >// DataTable dt = GetTables(myConnection); > > myConnection.Open(); > DataTable dt = myConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, > new object[] {null, null, null, "TABLE"}); > myConnection.Close(); > > int i; > > foreach(DataRow myRow in dt.Rows) > { >// foreach(DataColumn myCol in dt.Columns) >// { > Console.WriteLine(myRow[2]); >// } > } > Console.ReadLine(); > > } > > } >} > >>