private void tsbViewObject_Click(object sender, EventArgs e) { ObjectViewer ov = new ObjectViewer(); string ObjectText = string.Empty; string ObjectDescription = string.Empty; try { using (DataStuff sn = new DataStuff()) { DataTable dt = sn.GetDatabaseObjectText(ConnectionString, DatabaseName, ObjectName); if (dt.Rows.Count > 1) { foreach (DataRow row in dt.Rows) { ObjectText = row["FullDefinition"].ToString(); ObjectDescription = row["ROUTINE_NAME"].ToString() + ": " + row["ROUTINE_TYPE"].ToString(); } } else { ObjectText = LoadHelpText(ConnectionString, DatabaseName, ObjectName); ObjectDescription = ObjectName; if (ObjectText.Trim() == "") { dt = sn.GetTableHelpText(ConnectionString, DatabaseName, ObjectName); foreach (DataRow row in dt.Rows) { ObjectText = row[0].ToString(); } ObjectText = ObjectText.Replace("~", Environment.NewLine); } } } ov.ObjectDescription = ObjectDescription; ov.ObjectText = ObjectText; ov.ConnectionString = ConnectionString; ov.DatabaseName = DatabaseName; ov.ObjectName = ObjectName; ov.AliasName = ServerAlias; ov.Show(); } catch { } }
protected virtual void OnKeyDown(object sender, System.Windows.Forms.KeyEventArgs e) { if (e.Handled) { return; } if (IsMoveUpDown(e)) { e.Handled = true; return; } RaiseKeyDown(e); if (e.Handled) { return; } switch (e.KeyCode) { case System.Windows.Forms.Keys.F11: ObjectViewer.Show(this); break; case System.Windows.Forms.Keys.Delete: if (e.Shift) { Cut(); } else { OnKeyDownDelete(e); } break; case System.Windows.Forms.Keys.PageDown: OnKeyDownPageDown(e); break; case System.Windows.Forms.Keys.PageUp: OnKeyDownPageUp(e); break; case System.Windows.Forms.Keys.C: if (e.Control) { Copy(); } break; case System.Windows.Forms.Keys.X: if (e.Control) { Cut(); } break; case System.Windows.Forms.Keys.V: if (e.Control) { Paste(); } break; case System.Windows.Forms.Keys.Insert: if (e.Control) { Copy(); } else if (e.Shift) { Paste(); } break; default: break; } }