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);
}
