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?

Creating a database within a class in C# wpf

Answers (2)