/// <summary> /// 窗体初始化加载数据 /// </summary> private void LoadData(string strXType) { lvSelectList.Items.Clear(); lvNotSelectList.Items.Clear(); DataTable _tables = SQLServerDBHelper.GetTables(selectConnectionString, strXType); foreach (DataRow _tableNameRow in _tables.Rows) { string _tableName = _tableNameRow["name"].ToString(); ListViewItem lvi = new ListViewItem(_tableName); lvi.Tag = _tableNameRow["xtype"]; lvNotSelectList.Items.Add(lvi); } }
/// <summary> /// 数据库选择改变发生 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void cboDataBase_TextChanged(object sender, EventArgs e) { lvSelectList.Items.Clear(); lvNotSelectList.Items.Clear(); foreach (DBConfig _DBConfig in DBSettings.DataBaseConfigList) { if (_DBConfig.DataBase == cboDataBase.Text) { selectDataBase = _DBConfig.DataBase; selectConnectionString = _DBConfig.ConString; } } DataTable _tables = SQLServerDBHelper.GetTables(selectConnectionString, "U"); foreach (DataRow _tableNameRow in _tables.Rows) { string _tableName = _tableNameRow["name"].ToString(); ListViewItem lvi = new ListViewItem(_tableName); lvNotSelectList.Items.Add(lvi); } }
/// <summary> /// 读取数据库 /// </summary> /// <param name="_DBConfig"></param> /// <returns></returns> public TreeNode LoadDataBase(DBConfig _DBConfig) { TreeNode tn = new TreeNode(); tn.Text = _DBConfig.DataBase; tn.ImageIndex = 1; tn.Tag = "DataBase"; //tn.ContextMenuStrip = cmsForDataBase; TreeNode tnDataTables = new TreeNode(); tnDataTables.Text = "数据表"; tnDataTables.ImageIndex = 2; tnDataTables.Tag = "DataTables"; DataTable dtTables = new DataTable(); dtTables = SQLServerDBHelper.GetTables(_DBConfig.ConString, "U"); for (int i = 0; i < dtTables.Rows.Count; i++) { DataRow tableRow = dtTables.Rows[i]; TreeNode tnTable = new TreeNode(); tnTable.Text = tableRow[0].ToString(); tnTable.ImageIndex = 3; tnTable.Tag = "Table|" + _DBConfig.ConString; //tnTable.ContextMenuStrip = cmsForTable; tnDataTables.Nodes.Add(tnTable); } TreeNode tnDataView = new TreeNode("视图"); //tnDataView.Nodes[0].show tnDataView.ImageIndex = 2; tnDataView.Tag = "DataViews"; //tnDataView. DataTable dtViews = new DataTable(); dtViews = SQLServerDBHelper.GetTables(_DBConfig.ConString, "V"); for (int j = 0; j < dtViews.Rows.Count; j++) { DataRow viewRow = dtViews.Rows[j]; TreeNode tnView = new TreeNode(); tnView.Text = viewRow[0].ToString(); tnView.ImageIndex = 4; tnView.Tag = "View"; //tnView.ContextMenuStrip = cmsForView; tnDataView.Nodes.Add(tnView); //HideCheckBox(tnView); } TreeNode tnDataProc = new TreeNode("存储过程"); tnDataProc.ImageIndex = 2; tnDataProc.Tag = "DataProcs"; DataTable dtProcs = new DataTable(); dtProcs = SQLServerDBHelper.GetTables(_DBConfig.ConString, "P"); for (int k = 0; k < dtProcs.Rows.Count; k++) { DataRow procRow = dtProcs.Rows[k]; TreeNode tnProc = new TreeNode(); tnProc.Text = procRow[0].ToString(); tnProc.ImageIndex = 5; tnProc.Tag = "Proc"; //tnProc.ContextMenuStrip = cmsForProc; tnDataProc.Nodes.Add(tnProc); //HideCheckBox(tnProc); } tn.Nodes.Add(tnDataTables); tn.Nodes.Add(tnDataView); tn.Nodes.Add(tnDataProc); return(tn); }