public ViewColumnTreeNode(Bamboo.Mssql.ViewColumn column) { this.Text = column.Name; this.Tag = column; this.ImageIndex = Images.Column; this.SelectedImageIndex = Images.Column; }
private void ShowViewColumn(Bamboo.Mssql.ViewColumn column) { this.listView.Columns.Add("", 250, System.Windows.Forms.HorizontalAlignment.Left); this.listView.Columns.Add("", 250, System.Windows.Forms.HorizontalAlignment.Left); this.listView.Items.Add(new System.Windows.Forms.ListViewItem(new string[] { "Name", column.Name })); this.listView.Items.Add(new System.Windows.Forms.ListViewItem(new string[] { "Datatype", column.Datatype })); if (column.Length > 0) { this.listView.Items.Add(new System.Windows.Forms.ListViewItem(new string[] { "Length", column.Length.ToString() })); } }
public static Bamboo.Mssql.ViewColumnCollection ReadViewColumns(string viewName, System.Data.SqlClient.SqlConnection connection) { Bamboo.Mssql.ViewColumnCollection columns = new Bamboo.Mssql.ViewColumnCollection(); string query = "SELECT COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '" + viewName + "' ORDER BY TABLE_NAME, ORDINAL_POSITION"; System.Data.SqlClient.SqlCommand command = new System.Data.SqlClient.SqlCommand(query, connection); System.Data.SqlClient.SqlDataReader dataReader = command.ExecuteReader(); while (dataReader.Read()) { Bamboo.Mssql.ViewColumn column = new Bamboo.Mssql.ViewColumn(); if (!dataReader.IsDBNull(dataReader.GetOrdinal("COLUMN_NAME"))) { column.Name = dataReader.GetString(dataReader.GetOrdinal("COLUMN_NAME")); } if (!dataReader.IsDBNull(dataReader.GetOrdinal("DATA_TYPE"))) { column.Datatype = dataReader.GetString(dataReader.GetOrdinal("DATA_TYPE")); } if (!dataReader.IsDBNull(dataReader.GetOrdinal("CHARACTER_MAXIMUM_LENGTH"))) { column.Length = dataReader.GetInt32(dataReader.GetOrdinal("CHARACTER_MAXIMUM_LENGTH")); } columns.Add(column); } dataReader.Close(); return(columns); }
private void sqlDatabaseTreeView_SelectionChanged(object sender, System.EventArgs e) { System.Windows.Forms.TreeNode selectedNode = this.sqlDatabaseTreeView.SelectedNode; if (selectedNode != null) { if (selectedNode is TablesTreeNode) { this.listView.View = System.Windows.Forms.View.List; this.listView.Columns.Clear(); this.listView.Clear(); TablesTreeNode tablesTreeNode = (TablesTreeNode)selectedNode; Bamboo.Mssql.TableCollection tables = (Bamboo.Mssql.TableCollection)tablesTreeNode.Tag; this.ShowTables(tables); } else if (selectedNode is TableTreeNode) { this.listView.View = System.Windows.Forms.View.List; this.listView.Columns.Clear(); this.listView.Clear(); TableTreeNode tableTreeNode = (TableTreeNode)selectedNode; Bamboo.Mssql.Table table = (Bamboo.Mssql.Table)tableTreeNode.Tag; this.ShowTableColumns(table.Columns); } else if (selectedNode is ColumnsTreeNode) { this.listView.View = System.Windows.Forms.View.List; this.listView.Columns.Clear(); this.listView.Clear(); ColumnsTreeNode columnsTreeNode = (ColumnsTreeNode)selectedNode; Bamboo.Mssql.TableColumnCollection columns = (Bamboo.Mssql.TableColumnCollection)columnsTreeNode.Tag; this.ShowTableColumns(columns); } else if (selectedNode is ColumnTreeNode) { this.listView.Clear(); this.listView.View = System.Windows.Forms.View.Details; ColumnTreeNode columnTreeNode = (ColumnTreeNode)selectedNode; Bamboo.Mssql.TableColumn column = (Bamboo.Mssql.TableColumn)columnTreeNode.Tag; this.ShowTableColumn(column); } else if (selectedNode is ViewsTreeNode) { this.listView.View = System.Windows.Forms.View.List; this.listView.Columns.Clear(); this.listView.Clear(); ViewsTreeNode viewsTreeNode = (ViewsTreeNode)selectedNode; Bamboo.Mssql.ViewCollection views = (Bamboo.Mssql.ViewCollection)viewsTreeNode.Tag; this.ShowViews(views); } else if (selectedNode is ViewTreeNode) { this.listView.View = System.Windows.Forms.View.List; this.listView.Columns.Clear(); this.listView.Clear(); ViewTreeNode viewTreeNode = (ViewTreeNode)selectedNode; Bamboo.Mssql.View view = (Bamboo.Mssql.View)viewTreeNode.Tag; this.ShowViewColumns(view.Columns); } else if (selectedNode is ViewColumnsTreeNode) { this.listView.View = System.Windows.Forms.View.List; this.listView.Columns.Clear(); this.listView.Clear(); ViewColumnsTreeNode viewColumnsTreeNode = (ViewColumnsTreeNode)selectedNode; Bamboo.Mssql.ViewColumnCollection columns = (Bamboo.Mssql.ViewColumnCollection)viewColumnsTreeNode.Tag; this.ShowViewColumns(columns); } else if (selectedNode is ViewColumnTreeNode) { this.listView.Clear(); this.listView.View = System.Windows.Forms.View.Details; ViewColumnTreeNode viewColumnTreeNode = (ViewColumnTreeNode)selectedNode; Bamboo.Mssql.ViewColumn column = (Bamboo.Mssql.ViewColumn)viewColumnTreeNode.Tag; this.ShowViewColumn(column); } else if (selectedNode is ProceduresTreeNode) { this.listView.View = System.Windows.Forms.View.List; this.listView.Columns.Clear(); this.listView.Clear(); ProceduresTreeNode proceduresTreeNode = (ProceduresTreeNode)selectedNode; Bamboo.Mssql.ProcedureCollection procedures = (Bamboo.Mssql.ProcedureCollection)proceduresTreeNode.Tag; this.ShowProcudures(procedures); } else if (selectedNode is ProcedureTreeNode) { this.listView.Clear(); this.listView.View = System.Windows.Forms.View.Details; ProcedureTreeNode procedureTreeNode = (ProcedureTreeNode)selectedNode; Bamboo.Mssql.Procedure procedure = (Bamboo.Mssql.Procedure)procedureTreeNode.Tag; this.ShowProcudure(procedure); } else { this.listView.Clear(); } } }