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