Creating a database within a class in C# wpf

Hello Kieran......

here is code for creating database programmatically.......
Note:- change coonection string etc. setting according to yours....


private void CreateDatabase(DatabaseParam DBParam)
{
  System.Data.SqlClient.SqlConnection tmpConn;
  string sqlCreateDBQuery;
  tmpConn = new SqlConnection();
  tmpConn.ConnectionString = "SERVER = " + DBParam.ServerName +
  "; DATABASE = master; User ID = sa; Pwd = sa";
  sqlCreateDBQuery = " CREATE DATABASE "
  + DBParam.DatabaseName
  + " ON PRIMARY "
  + " (NAME = " + DBParam.DataFileName +", "
  + " FILENAME = '" + DBParam.DataPathName +"', "
  + " SIZE = 2MB,"
  + " FILEGROWTH =" + DBParam.DataFileGrowth +") "
  + " LOG ON (NAME =" + DBParam.LogFileName +", "
  + " FILENAME = '" + DBParam.LogPathName + "', "
  + " SIZE = 1MB, "
  + " FILEGROWTH =" + DBParam.LogFileGrowth +") ";
  SqlCommand myCommand = new SqlCommand(sqlCreateDBQuery, tmpConn);
  try
  {
  tmpConn.Open();
  MessageBox.Show(sqlCreateDBQuery);
  myCommand.ExecuteNonQuery();
  MessageBox.Show("Database has been created successfully!",
  "Create Database", MessageBoxButtons.OK,
  MessageBoxIcon.Information);
  }
  catch (System.Exception ex)
  {
  MessageBox.Show(ex.ToString(), "Create Database",
  MessageBoxButtons.OK,
  MessageBoxIcon.Information);
  }
  finally
  {
  tmpConn.Close();
  }
  return;
}



Thanks.
Pravin.

Mark this post Accepted Answer, if it helps you.

What have you completed so far?