c#创建数据库

2019-11-09 14:43:09

字体：大中小

来源：转载

供稿：网友

PRivate void button1_Click(object sender, EventArgs e) { //打开数据库连接 SqlConnection conn = new SqlConnection("server=192.168.2.70; uid=sa; pwd=sa123456"); if (conn.State != ConnectionState.Open) { conn.Open(); } string sql = "CREATE DATABASE MyDataBase on primary" + "(name=MyDataBase,filename='F://MyDataBase.mdf',size=5, maxsize=20,filegrowth=10%)"; sql += "log on" + "(name=MyDataBase_log,filename='F://MyDataBase_log.ldf',size=3,filegrowth=1)"; SqlCommand cmd = new SqlCommand(sql, conn); try { cmd.ExecuteNonQuery(); MessageBox.Show("数据库创建成功。"); } catch (SqlException ae) { MessageBox.Show("数据库创建失败。" + ae.Message.ToString()); } }

上一篇：Fresco 使用要点

下一篇：Principle for Mac 2.1.3 简体中文完美汉化包原型设计工具