System.Data.Common.DbConnection.GetSchema C# (CSharp) Method

GetSchema() public method

public GetSchema ( ) : DataTable
return System.Data.DataTable
        public virtual DataTable GetSchema()
        {
            throw ADP.NotSupported();
        }

Same methods

DbConnection::GetSchema ( string collectionName ) : DataTable
DbConnection::GetSchema ( string collectionName, string restrictionValues ) : DataTable

Usage Example

Exemplo n.º 1
0
        private void BindGrid(DbConnection conn)
        {
            conn.Open();
                _schema = new DataSet();
                var schema = conn.GetSchema();

                foreach (DataRow dataRow in schema.Rows)
                {
                    var tableName = dataRow["CollectionName"].ToString();
                    if(!_schema.Tables.Contains(tableName))
                    {
                        var dt = conn.GetSchema(tableName);
                        dt.TableName = tableName;
                        _schema.Tables.Add(dt);
                    }
                }
                conn.Close();
                dgSchema.DataSource = _schema.Tables[0];

                cbTable.DataSource = _schema.Tables[0];
                cbTable.DisplayMember = "CollectionName";
                cbTable.ValueMember = "CollectionName";
                _previousWidth = dgSchema.Width;
                _previousState = WindowState;
        }
All Usage Examples Of System.Data.Common.DbConnection::GetSchema