Please Help!!

Please Help!!

• jca_john

  To retrieve the list of databases on that SQL Connection:

  you can execute the sp_databases stored procedure which will retrieve the list of databases on that connection.

  so you can use a dataReader to read each row (column name Database_name) and populate this in a list box/combo box

  you can also retrieve a list of stored procedures for the specific database using this query on the database:

  select name from dbo.sysobjects where type ='P'

  I hope this helps in some way!

  
  
  

• renyx

  Thanks to both of you,

  I will try these codes and let you know what works for me.

  
  

• biki

  Another Solution differ from what Ahmed Suggest is to use

  SMO (Server Management Objects)

  To Use it first you need to do the following

  Add The Reference To

  • Microsoft.SqlServer.ConnectionInfo.dll
  • Microsoft.SqlServer.Smo.dll
  • Microsoft.SqlServer.SmoEnum.dll

  Write

  • using Microsoft.SqlServer.Management.Smo;
  • using Microsoft.SqlServer.Management.Common;

  You Can do the Following

      //To Connect To The Serevr
      string serverName = "Localhost";
      Server server = new Server(serverName);

  //Get List of Databases in the serevr
  foreach (Database db in server.Databases)
  {
  lstDatabases.Items.Add(db.Name);
  }
  

  //To get specific Database
  string databaseName = "Northwind";
  Database db = server.Databases[databaseName];
  

  //To get all the table in database
  foreach (Table table in db.Tables)
  {
  lstTable.Items.Add(tableName);
  }
  

  //To Get All Stored Procedures
  foreach (StoredProcedure sp in db.StoredProcedures)
  {
  lstSP.Items.Add(sp.Name);
  }
  

  //To Search For SP
  string spName="spTest";
  if (db.StoredProcedures.Contains(spName) == true)
  {
  //Found it so do it
  }
  else
  
  {
  //sorry i can not found what you search for
  }

  Look Also To This Thread

  How to add SQL ConnectionString editor form

   

  
  
  
• Please Help!!