void FillTree(string tablename) { ClearTree(); Tree.Nodes.Add(tablename); Tree.Nodes[0].Expand(); DataTable RefTables = Conn.SQLRunner( " SELECT object_name(rkeyid) FROM sysreferences "+ " WHERE fkeyid = object_id(" + QueryCreator.quotedstrvalue(tablename, true) + ")" + " AND object_name(rkeyid) != " + QueryCreator.quotedstrvalue(tablename, true)); foreach (DataRow Rtable in RefTables.Rows) { Tree.Nodes.Add(Rtable[0].ToString()); } foreach (TreeNode N in Tree.Nodes) { string currtable = N.Text; dbstructure DBS = Conn.GetStructure(currtable); foreach (DataRow ColDesc in DBS.columntypes.Rows) { N.Nodes.Add(ColDesc["field"].ToString()); } } }
/* * public static void EditExtClass(Form F, DataAccess MyDataAccess) { * frmSelectClassificazione frm = new frmSelectClassificazione(MyDataAccess); * DialogResult res = frm.ShowDialog(F); * if (res == DialogResult.OK){ * EditExtClass frm2 = new EditExtClass(frm.SelectedCodiceTipoClass, MyDataAccess); * frm2.ShowDialog(F); * frm2.Dispose(); * } * frm.Dispose(); * } * * public static void doTraduzioneClassificazioni(Form F, DataAccess MyDataAccess){ * SelezionaOrigineClass Frm = new SelezionaOrigineClass(MyDataAccess); * Frm.ShowDialog(F); * Frm.Dispose(); * } */ /// <summary> /// Export the MetaData Structure of MetaData DLL into a XML file /// </summary> public static void WriteMetaDataStructureToXml(Form F, DataAccess MyDataAccess, SaveFileDialog FileSaver) { if (MyDataAccess == null) { return; } DialogResult Res = FileSaver.ShowDialog(F); if (Res != DialogResult.OK) { return; } dbstructure DS = MyDataAccess.GetStructure("customobject"); DataSet DSCopy = DS.Clone(); DSCopy.Clear(); dbanalyzer.ExportDataSetToXML(FileSaver.FileName, MyDataAccess, DSCopy, true); }