Example #1
0
        private void lbSp_SelectedIndexChanged(object sender, EventArgs e)
        {
            ListBox myLb = (ListBox)lblSp;

            if (myLb.Text != "System.Data.DataRowView")
            {
                Works.RunIfDbExists(GetSPContents, cbDatabases.Text.Trim());
            }
        }
Example #2
0
        private void cbDatabases_SelectedIndexChanged(object sender, EventArgs e)
        {
            ComboBox mycb = (ComboBox)sender;

            if (!string.IsNullOrEmpty(mycb.Text) &&
                mycb.Text != "System.Data.DataRowView")
            {
                Works.RunIfDbExists(GetSPList, cbDatabases.Text.Trim());
            }
        }
Example #3
0
        private void lstTables_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (!lblSearch.Text.Contains("("))
            {
                lblSearch.Text += " ( in " + DbName + " )";
            }

            ListBox myLb = (ListBox)lstTables;

            if (myLb.Text != "System.Data.DataRowView")
            {
                Works.RunIfDbExists(GetColumnsByTable, DbName);
            }
        }
Example #4
0
        private void txtCriteria_TextChanged(object sender, EventArgs e)
        {
            if (chkColumns.Checked)
            {
                lstTables.Items.Clear();

                Works.RunIfDbExists(delegate()
                {
                    SqlDataAdapter da = new SqlDataAdapter(
                        string.Format(@"USE {0}; SELECT c.name +' ('+t.name+')' ad FROM sys.tables AS t INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID WHERE c.name LIKE '%{1}';",
                                      DbName, GetMyFilter()), Settings.Default.cnnStr);

                    DataTable dtTables = new DataTable();
                    da.Fill(dtTables);

                    lstColumns.DataSource    = dtTables;
                    lstColumns.DisplayMember = "ad";
                    lstColumns.ValueMember   = "ad";

                    label1.Text = string.Format("Columns ({0})", lstColumns.Items.Count);
                }, DbName);
            }
            else
            {
                Works.RunIfDbExists(delegate()
                {
                    SqlDataAdapter da = new SqlDataAdapter(
                        string.Format(@"USE {0}; SELECT name ad 
                                                        FROM sys.objects 
                                                        WHERE type = 'U' and name like '%{1}';",
                                      DbName, GetMyFilter()), Settings.Default.cnnStr);

                    DataTable dtTables = new DataTable();
                    da.Fill(dtTables);

                    lstTables.DataSource    = dtTables;
                    lstTables.DisplayMember = "ad";
                    lstTables.ValueMember   = "ad";

                    lblSpName.Text = string.Format("Tables ({0})", lstTables.Items.Count);
                }, DbName);
            }
        }
Example #5
0
        private void txtCriteria_TextChanged(object sender, EventArgs e)
        {
            Works.RunIfDbExists(delegate()
            {
                SqlDataAdapter da = new SqlDataAdapter(
                    string.Format(@"USE {0}; SELECT DISTINCT OBJECT_NAME(id) as ad,id 
                                            FROM syscomments 
                                            WHERE OBJECTPROPERTY(id, 'IsProcedure') = 1
                                                    AND (OBJECT_NAME(id) LIKE '%{1}' OR [text] LIKE '%{1}');",
                                  cbDatabases.Text.Trim(), GetMyFilter()), Settings.Default.cnnStr);

                DataTable dtProcedures = new DataTable();
                da.Fill(dtProcedures);

                lblSp.DataSource    = dtProcedures;
                lblSp.DisplayMember = "ad";
                lblSp.ValueMember   = "id";

                lblSpName.Text = string.Format("Stored Procedures ({0})", lblSp.Items.Count);
            }, cbDatabases.Text.Trim());
        }