Creating a database within a class in C# wpf

Question

Hi guys i am a student try ing to create a database within a WPF class in c#. Would appreciate any advice. regards Kieran

Pravin More · Answer

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.

Mamta M · Answer

What have you completed so far?