private void RenderDataSourceSchema(DataSchema dataSchema) { DataSourceTree.Nodes[0].Nodes.Clear(); if (dataSchema != null) { RenderDataSourceSchemaTree(DataSourceTree.Nodes[0], dataSchema); DataSourceTree.ExpandAll(); } }
private void Btn_Confirm_Click(object sender, RoutedEventArgs e) { string txt_databaseVal = txt_database.SelectedValue.ToString();//数据库 ConnectionString += "Initial Catalog:" + txt_databaseVal + ";"; //string getDataBaseSqlString = "SELECT name FROM master..sysdatabases WHERE name NOT IN ( 'master', 'model', 'msdb', 'tempdb', 'northwind','pubs' )"; //DataSet DS_DataBase = DbHelperSQL.Query(getDataBaseSqlString); string getTablesSqlString = "SELECT name FROM " + txt_database.SelectedValue.ToString() + "..sysobjects Where xtype='U' ORDER BY name "; DataSet DS_Tables = DbHelperSQL.Query(getTablesSqlString); //string sqlString = "SELECT COLUMN_NAME,DATA_TYPE,CHARACTER_MAXIMUM_LENGTH,IS_NULLABLE,COLUMN_DEFAULT FROM INFORMATION_SCHEMA.columns WHERE TABLE_NAME=\'" + selectedTable + "\' "; //DataTable dataSource = new DataTable(); //dataSource.Columns.Add("Name", typeof(string)); //dataSource.Columns.Add("ParentId", typeof(int)); List <DataSourceTree> list = new List <DataSourceTree>(); foreach (DataRow dr in DS_Tables.Tables[0].Rows) { DataSourceTree tree = new DataSourceTree(); tree.Name = dr["name"].ToString(); tree.Children = null; list.Add(tree); } DataSourceTree dataSourceTree = new DataSourceTree(); dataSourceTree.Name = txt_server.Text; //dataSourceTree.Children = list; dataSourceTree.Children.Add(new DataSourceTree() { Name = txt_databaseVal, Children = list }); //string jsonData = JsonHelper.Serialize(dataSourceTree); dataSourceTreeList.Add(dataSourceTree); mainWindowModel.DataSourceTreeList = null; mainWindowModel.DataSourceTreeList = dataSourceTreeList; this.Close(); }