Creating Databases and tables using c#

Question

I have a windows form application created using C#. I have a few databases and tables in SQL server 2005 express edition. To create a setup of my project I wish to attach the databases and tables dynamically while my setup wizard runs on any remote machine.

I tried to write a code which will simply create database and also a try-catch statement which will check if the database exists but everytime execution of try catch statement whenever my application runs may be a problem.

Is this possible by simply attaching the .mdf files with my project as I create the setup wizard ?

Please help. Thanks in advance.

@HosseinNarimaniRad: Sir is it possible to do it using SQL server ? i mean a ADO.net connection with SQL server ? how can it be done ? — Sudeep Purohit
– Sudeep Purohit, Commented Mar 29, 2013 at 10:41
@HosseinNarimaniRad: The answer is useful sir but my question is how can we write a connection string as the database is also to be created dynamically. — Sudeep Purohit
– Sudeep Purohit, Commented Mar 29, 2013 at 11:57

Hossein Narimani Rad · Accepted Answer · 2013-03-29 10:49:19Z

2

To create a table:

string createString = "CREATE TABLE myTable (column1 INT, column2 NVARCHAR(10))"; //YOUR SQL COMMAND TO CREATE A TABLE
SqlConnection connection = new SqlConnection(YOUR CONNECTION STRING);

SqlCommand create = new SqlCommand(createString , connection);

connection.Open();
create.ExecuteNonQuery();
connection.Close();

answered Mar 29, 2013 at 10:49

Hossein Narimani Rad

32.7k19 gold badges92 silver badges121 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ramezani r · Accepted Answer · 2013-06-11 11:03:46Z

0

You could copy your .mdf file in root and if you make a setup it would be in your setup file. I had done it. Your connection string would be: string.Format("{0}{1}{2}", @"Data Source=.\SQLEXPRESS;AttachDbFilename=", AppDomain.CurrentDomain.BaseDirectory, @"Database.mdf;Integrated Security=True;User Instance=False");

answered Jun 11, 2013 at 11:03

Ramezani r

1611 silver badge7 bronze badges

Comments

Andrew · Accepted Answer · 2013-09-27 20:37:10Z

0

string myConnectionString= @"DataSource =...";

SqlConnection dbConnection = new SqlConnection(myConnectionString);

string myCommand = "CREATE TABLE myTable (column1 VARCHAR(10),colunm2 INT)";

SqlCommand dbConnection = new SqlCommand(myCommand,dbConnection);

try
{
dbConnection.Open();

dbCommand.ExecuteNonQuery();
}

catch{}

dbConnection.Close();

edited Sep 27, 2013 at 20:37

Andrew

15.4k6 gold badges68 silver badges101 bronze badges

answered Sep 27, 2013 at 20:10

wast3dMynd

1

Collectives™ on Stack Overflow

Creating Databases and tables using c#

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related