Wednesday, 25 January 2012

check db Existance and execute script

  1. Public Shared Function CheckDatabaseExists(ByVal Server As String, ByVal Database As String) As Boolean
  2.         Dim connString As String = ("Data Source="  _
  3.                     + (Server + ";Initial Catalog=Master;Integrated Security=True;"))
  4.         Dim cmdText As String = ("SELECT * FROM master.dbo.sysdatabases WHERE NAME=\'"  _
  5.                     + (Database + "\'"))
  6.         Dim bRet As Boolean = false
  7.         Using sqlConnection As SqlConnection = New SqlConnection(connString)
  8.         sqlConnection.Open
  9.         Using sqlCmd As SqlCommand = New SqlCommand(cmdText, sqlConnection)
  10.         Using reader As SqlDataReader = sqlCmd.ExecuteReader
  11.         bRet = reader.HasRows
  12.         End Using
  13.         End Using
  14.         End Using
  15.         Return bRet
  16.     End Function 
  17.  
    1.   string sqlConnectionString = "Data Source=FIRSTONE;User ID=sa; Persist Security Info=True;";
    2.  
    3.   FileInfo file = new FileInfo("name_of_the_sql_script.sql");
    4.   string script = file.OpenText().ReadToEnd();
    5.   string rscript = script.Replace("GO", "");
    6.  
    7.   SqlConnection conn = new SqlConnection(sqlConnectionString);
    8.   SqlCommand cmd = new SqlCommand(rscript, conn);
    9.   cmd.Connection.Open();
    10.  
    11.   cmd.ExecuteNonQuery();
    12.  
    13.   cmd.Dispose();
    14.  

1 comment:

  1. It is very nice post and help me.

    If you want to get more information related to PHP then go http://www.phpcreating.blogspot.com

    Thanks
    Bhargav Anadkat
    Wordpress Development India

    ReplyDelete