دلتنگ اسمان
دوشنبه 23 تیر 1393, 23:14 عصر
سلام. این کد خطا میده و دیتابیس ساخته نمیشه:
public void CreateDB()
{
//create DB
SqlConnection con = new SqlConnection();
SqlCommand cmd = new SqlCommand();
con.ConnectionString = ("Data Source=ALI-PC ;Integrated security=true");
string dataBase = "CREATE DATABASE Hesabdari ON PRIMARY (NAME = Hesabdari, FILENAME = 'E:\\Hesabdari.mdf',SIZE = 3MB) LOG ON (NAME = Hesabdari_log, FILENAME = 'd:\\Hesabdari_log.ldf', SIZE = 1MB)";
cmd.CommandText = dataBase;
try
{
con.Open();
cmd.ExecuteNonQuery();
con.Close();
con.Dispose();
MessageBox.Show("ok");
}
catch (Exception d)
{
MessageBox.Show("error");
}
//
con.ConnectionString = "Data Source=ALI-pc ;Initial Catalog=Hesabdari; Integrated Security=True";
cmd.CommandText = "CREATE Table TbLogin ([UserName] [varchar](100) NOT NULL,[PassWord] [varchar](100) NOT NULL,[pic] [image],[No] [varchar](1),[Savepass] [varchar](1), CONSTRAINT [PK_TB_Login] PRIMARY KEY CLUSTERED ([UserName] ASC) ON [PRIMARY]) ; ";
try
{
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception)
{ }
}
public void CreateDB()
{
//create DB
SqlConnection con = new SqlConnection();
SqlCommand cmd = new SqlCommand();
con.ConnectionString = ("Data Source=ALI-PC ;Integrated security=true");
string dataBase = "CREATE DATABASE Hesabdari ON PRIMARY (NAME = Hesabdari, FILENAME = 'E:\\Hesabdari.mdf',SIZE = 3MB) LOG ON (NAME = Hesabdari_log, FILENAME = 'd:\\Hesabdari_log.ldf', SIZE = 1MB)";
cmd.CommandText = dataBase;
try
{
con.Open();
cmd.ExecuteNonQuery();
con.Close();
con.Dispose();
MessageBox.Show("ok");
}
catch (Exception d)
{
MessageBox.Show("error");
}
//
con.ConnectionString = "Data Source=ALI-pc ;Initial Catalog=Hesabdari; Integrated Security=True";
cmd.CommandText = "CREATE Table TbLogin ([UserName] [varchar](100) NOT NULL,[PassWord] [varchar](100) NOT NULL,[pic] [image],[No] [varchar](1),[Savepass] [varchar](1), CONSTRAINT [PK_TB_Login] PRIMARY KEY CLUSTERED ([UserName] ASC) ON [PRIMARY]) ; ";
try
{
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception)
{ }
}