Error While Creating Database in SQL

Question

I am new to SQL and trying to create a Database using C#. Here is my Code...

private void CreateDBBtn_Click(object sender, EventArgs e)
{
  String connectionString = GetConnectionString();
  SqlConnection connection = new SqlConnection(connectionString);
  connection.Open();

  String SQLCommand = "CREATE DATABASE MyDatabase ON PRIMARY " +
           "(NAME = MyDatabase_Data, " +
           "FILENAME = 'D:\\MyDatabase.mdf'," +
           "SIZE = 2MB, MAXSIZE = 10MB, FILEGROWTH = 10%)";

  SqlCommand cmd = new SqlCommand(SQLCommand, connection);
  try
  {
    cmd.ExecuteNonQuery();
  }
  catch (SqlException ae)
  {
    MessageBox.Show(ae.Message);
  }
}

private String GetConnectionString()
{
   SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
   builder.DataSource = @".\SQLSERVER";
   builder.AttachDBFilename = @"D:\MyDatabase.mdf";
   builder.IntegratedSecurity = true;
   builder.ConnectTimeout = 30;
   builder.UserInstance = true;
   return builder.ConnectionString;
}

but it gives me error that...

enter image description here

Where as D:\MyDataBase.mdf file has size 3.13 MB on my PC.

So set SIZE = 5MB then. Also MAXSIZE = 10MB? Surely you can afford more space than that? — Martin Smith
– Martin Smith, Commented Jun 18, 2013 at 17:58
The error says it has to be 5MB. You said it is 3.13MB. Did you try boosting the initial size? Also, did you try scripting a samlple of the database from the sql server gui and then use that in your code? I wouldn't do it the way you are doing anyhow but those are some things I would try. — Mike Cheel
– Mike Cheel, Commented Jun 18, 2013 at 17:59
Yes, @MartinSmith, SIZE = 5B worked for me but I feel the Problem was this file Name builder.AttachDBFilename = @"D:\MyDatabase.mdf"; and the One in Create DataBase "FILENAME = 'D:\\MyDatabase.mdf', should also be different. — Pankaj
– Pankaj, Commented Jun 18, 2013 at 18:17
[refer this site][1]stackoverflow.com/questions/14034351/… — Techrefresh
– Techrefresh, Commented Jun 18, 2013 at 18:31

khinkle · Accepted Answer · 2013-06-18 18:44:25Z

-1

I completely agree with DJ KRAZE. It would take about two seconds to create that using whatever server manager you have.

answered Jun 18, 2013 at 18:44

khinkle

1118 bronze badges

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

3 Comments

HardCode Over a year ago

This is a comment, not an answer.

khinkle Over a year ago

I have to have 50 reputation points to be able to comment. Otherwise I would have.

Pankaj Over a year ago

I agree @khinkle that it will take hardly 2 seconds to create using DataBase server but then I will never learn how to do that using C# and My First Line was "I am new to SQL and trying to create a Database using C#".

Collectives™ on Stack Overflow

Error While Creating Database in SQL

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related