Permalink
Cannot retrieve contributors at this time
Fetching contributors…
| using System; | |
| using System.Data.SqlClient; | |
| using System.Data; | |
| namespace NextResultCS | |
| { | |
| class Program | |
| { | |
| static void Main() | |
| { | |
| string s = GetConnectionString(); | |
| SqlConnection c = new SqlConnection(s); | |
| GetSchemaInfo(c); | |
| Console.ReadLine(); | |
| } | |
| // <Snippet1> | |
| static void GetSchemaInfo(SqlConnection connection) | |
| { | |
| using (connection) | |
| { | |
| SqlCommand command = new SqlCommand( | |
| "SELECT CategoryID, CategoryName FROM Categories;", | |
| connection); | |
| connection.Open(); | |
| SqlDataReader reader = command.ExecuteReader(); | |
| DataTable schemaTable = reader.GetSchemaTable(); | |
| foreach (DataRow row in schemaTable.Rows) | |
| { | |
| foreach (DataColumn column in schemaTable.Columns) | |
| { | |
| Console.WriteLine(String.Format("{0} = {1}", | |
| column.ColumnName, row[column])); | |
| } | |
| } | |
| } | |
| } | |
| // </Snippet1> | |
| static private string GetConnectionString() | |
| { | |
| // To avoid storing the connection string in your code, | |
| // you can retrieve it from a configuration file. | |
| return "Data Source=(local);Initial Catalog=Northwind;" | |
| + "Integrated Security=SSPI"; | |
| } | |
| } | |
| } |