Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
[ Team LiB ] Recipe 0.2 Retrieving Database Schema Information from SQL Server Problem You need to retrieve database schema information from a SQL Server database. | Team LiB Recipe 10.2 Retrieving Database Schema Information from SQL Server Problem You need to retrieve database schema information from a SQL Server database. Solution Retrieve table schema information using either information schema views or the OLE DB .NET data provider Connection object. The sample code retrieves a list of tables in the Northwind sample database. The C code is shown in Example 10-2. Example 10-2. File DatabaseSchemaForm.cs Namespaces variables and constants using System using System.Configuration using System.Data using System.Data.SqlClient using System.Data.OleDb . . . DataTable schemaTable if sqlServerRadioButton.Checked String getSchemaTableText SELECT FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE BASE TABLE ORDER BY TABLE_TYPE Retrieve the schema table contents. SqlDataAdapter da new SqlDataAdapter getSchemaTableText ConfigurationSettings.AppSettings S ql_ConnectString schemaTable new DataTable da.Fill schemaTable schemaDataGrid.CaptionText SQL Server .NET Provider else OleDbConnection conn new OleDbConnection ConfigurationSettings.AppSettings OleDb_ConnectString conn.Open Get the schema table. schemaTable conn.GetOleDbSchemaTable OleDbSchemaGuid.Tables new object null null null TABLE conn.Close schemaDataGrid.CaptionText OLE DB .NET Provider Bind the default view of schema table to the grid. schemaDataGrid.DataSource schemaTable.DefaultView Discussion The first solution uses information schema views that are available in SQL Server 7.0 and later. These views provide system-table independent access to SQL Server metadata. Although based on the sysobjects and syscomments system tables the views allow applications to continue to work properly even if the system tables change. They provide an alternative to the system stored procedures that were previously used and are still available. The INFORMATION_SCHEMA views conform to the SQL-92 Standard. The views are defined within each database in a schema named INFORMATION_SCHEMA. To access .