/// <summary> /// DBViewerGui Instance - Singelton. /// </summary> /// <returns></returns> public static DBViewerGui Instance() { if (instance == null) { instance = new DBViewerGui(); } return(instance); }
private void SendRequestForDataTableView() { if (CalculateNodeHierarchy(this.SelectedNode) == (int)DatabaseTreeViewHierarchy.Table) { string path = this.SelectedNode.FullPath; string[] arguments = path.Split(this.PathSeparator[0]); DBViewerGui.Instance().ViewDataTable(arguments[1], arguments[2], arguments[3]); } }
static void Main() { try { Application.EnableVisualStyles(); Application.Run(DBViewerGui.Instance()); } catch { // catches all exceptions. } }
/// <summary> /// Saves database table. /// </summary> public void SaveDatabaseTable() { // gets the db info (server, database, table). string[] databaseInfo = GetDatabaseInfo(this.Parent.Text); // adds the deleted rows to the table. DataTable table = RestoreDeletedRowsInDataSource(); DBViewerGui.Instance().SaveDatabaseTable(databaseInfo[0], databaseInfo[1], databaseInfo[2], table); //deleted data reseted. deletedRows.Clear(); //saved data marked as unchanged. table.AcceptChanges(); }
/// <summary> /// /// </summary> /// <param name="e"></param> protected override void OnBeforeExpand(TreeViewCancelEventArgs e) { base.OnBeforeExpand(e); //TODO: add a check the eliminates the need ot expand it every time. if (CalculateNodeHierarchy(e.Node) == (int)DatabaseTreeViewHierarchy.Server) { ArrayList databases = new ArrayList(); foreach (TreeNode node in e.Node.Nodes) { databases.Add(node.Text); } DBViewerGui.Instance().AddSqlDataTables(e.Node.Text, databases); } }
static void Main() { try { Application.EnableVisualStyles(); DBViewerConstants.connectionString = "data source=IA-SQL01\\IALICENSE;initial catalog=LightBridgeDev;persist security info=True;user id=iadev;password=iadev;encrypt=False;trustservercertificate=False;user instance=False;context connection=False;MultipleActiveResultSets=True;App=EntityFramework"; DBViewerConstants.EndpointMachine_Id = 2; Application.Run(DBViewerGui.Instance()); } catch { // catches all exceptions. } }
/// <summary> /// Handles the "Add new server ..." click event. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void SqlServerRegistrationMenuItemClickEventHandler(object sender, EventArgs e) { DBViewerSqlServerRegistrar registrar = new DBViewerSqlServerRegistrar(); if (registrar.ShowDialog(this) == DialogResult.OK) { // gets the server, user name and password. string server = registrar.ServerName; string user = registrar.UserName; string password = registrar.UserPassword; // updates the DBViewerGui that a sql server should be added. DBViewerGui.Instance().AddSqlServer(server, user, password); } registrar.Dispose(); }