DB Invader : A Database Explorer

It helps you explore all available databases in SQL Server(you can provide multiple DB Servers/Instances simultaneously), tables under them and data contained in tables. You can select any database and browse their tables. Select any table and look into data contained in them.

C# (169.1 KB)
 
 
 
 
 
5 Star
(4)
3,847 times
Add to favorites
3/25/2014
E-mail Twitter del.icio.us Digg Facebook
Sign in to ask a question


  • why not auto read in local and network servers
    2 Posts | Last post October 24, 2015
    •  Public Sub GetNetworkServers(cboServers As ComboBox)
      
              ' Retrieve the enumerator instance and then the data.
              Dim instance As SqlDataSourceEnumerator = SqlDataSourceEnumerator.Instance
              Dim table As System.Data.DataTable = instance.GetDataSources()
              Dim strLine As String = ""
      
              For Each row As DataRow In table.Rows
                  strLine = ""
                  strLine = row(0).ToString + "\\" + row(1)  ' .ToString 
                  cboServers.Items.Add(strLine)
                  '                     ["ServerName"] + "\\" + servers.Rows[i]["InstanceName"]);
              Next
              cboServers.SelectedIndex = 0
      
          End Sub
    • Thanks for stopping by.
      
      Initially I planned to Auto Fetch Local and Network Servers, but it was kind of running slow in my enterprise network, making app a bit unusable. So dropped it.
      
      I will put a button which will auto fetch local and network servers so that users requiring those features can use them. Some more features are in pipeline.
      
      I would love if you can rate this app and other ones. Thanks again.
  • if (DBConn == null)  is useless
    2 Posts | Last post December 12, 2013
    • private static SqlConnection getConn(DBConnections DBConn, String DBName) 
              { 
                  if (DBConn == null) 
                  { 
                      DBConn = new DBConnections(); 
                      DBConn.conn = new SqlConnection(DBConn.ConnString); 
                      DBConn.conn.Open(); 
                      DBConn.DBName = ""; 
                  } 
                  else if (DBConn.conn == null) 
                  { 
                      DBConn.conn = new SqlConnection(DBConn.ConnString); 
                      DBConn.conn.Open(); 
                  } 
                  if (!DBConn.conn.Database.ToLower().Equals(DBName.ToLower())) 
                  { 
                      if (DBConn.conn.State != ConnectionState.Open) DBConn.conn.Open(); 
                      DBConn.conn.ChangeDatabase(DBName); 
                      DBConn.DBName = DBName; 
                  } 
                  return DBConn.conn; 
              } 
      DBConn can not be null.If DBconn is null,then after DBConn is created,the fields of DBConn are alse null.So 'new SqlConnection(DBConn.ConnString); ' statement will generate an error.
    • I agree with you niaomingjian. Will update when I promote the code.