Before I pull out my hair, ADO.NET and VB.NET :D

• • Reply

  18 years ago

  by Tony Ho

  Tony Ho

  Lexington, KY, United States

  Joined 18 years ago

  I've been looking for an answer to this for quite awhile!
  

  
  Questions:
  1. Is there a way in ADO.NET w/ VB.NET, that I may query the SQL Server on what databases it has (just need the names)?
  2. Is there a way in ADO.NET w/ VB.NET, that I can create a database in an SQL server?
  

  
  Comments:
  1. Stored Procedures are really no help here. , I had already looked through them
  2. I know how to create tables inside a database, but how to create an actual database on the server? (assuming that you have the right permissions)
  

  
  Any help will be greatly appreciated and my hair will be saved!!!
  

  
  Thanks,
  Tony

  Report abuse
• • Reply

  18 years ago

  by James Crowley

  James Crowley

  London, United Kingdom

  Joined 20 years ago

  I'm not sure if there are any native ado.net commands, but to retrieve a list of databases, you can call the sp_databases stored procedure on SQL Server. To create a database, you can use the CREATE DATABASE command:
  

  
  

  Code:

  USE master
  GO
  CREATE DATABASE Sales
  ON
  ( NAME = Salesdat,
    FILENAME = 'c:\program files\microsoft sql server\mssql\data\saledat.mdf',
    SIZE = 10,
    MAXSIZE = 50,
    FILEGROWTH = 5 )
  LOG ON
  ( NAME = 'Saleslog',
    FILENAME = 'c:\program files\microsoft sql server\mssql\data\salelog.ldf',
    SIZE = 5MB,
    MAXSIZE = 25MB,
    FILEGROWTH = 5MB )
  GO
  

  
  

  
  

  
  plz note that this is very specific to SQL Server!!
  

  
  (i found all of this in the SQL Server manual)

  Report abuse
• • Reply

  18 years ago

  by Tony Ho

  Tony Ho

  Lexington, KY, United States

  Joined 18 years ago

  Interesting... Thanks James. , I think I have tried the sp_databases sp b4 and had unsuccessful outcomes, but I'll try again

  Report abuse