using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
namespace CreateDataBaseByVS
{
class Program
{
static void Main(string[] args)
{
try
{
string conStr = "Data Source=.;Initial Catalog=master;User id=sa;pwd=123;";
SqlConnection conn = new SqlConnection(conStr);
conn.Open();
StringBuilder sb = new StringBuilder();
sb.AppendLine("use master");
sb.AppendLine("if exists (select * from sysdatabases where name='q')");
sb.AppendLine("drop database q");
sb.AppendLine("Create Database q");
sb.AppendLine("on primary");
sb.AppendLine("(");
sb.AppendLine("name='q',");
sb.AppendLine("FILENAME='D:\\q.mdf',");
sb.AppendLine("size=15mb,");
sb.AppendLine("maxsize=100mb,");
sb.AppendLine("filegrowth=15%");
sb.AppendLine(")");
sb.AppendLine("log on");
sb.AppendLine("(");
sb.AppendLine("name='q.ldf',");
sb.AppendLine("FILENAME='D:\\q.ldf',");
sb.AppendLine("size=15mb");
sb.AppendLine(")");
SqlCommand command = new SqlCommand(sb.ToString(), conn);
int it =(int)command.ExecuteScalar();//执行命令,要有,只为了执行
//
Console.WriteLine("创建失败");
}
catch (Exception)
{
Console.WriteLine("创建成功");
}
Console.Read();
}
}
}