建库
string sql = "CREATE DATABASE mydb ON PRIMARY"
+"(name=test_data, filename = 'C:\\mysql\\mydb_data.mdf', size=3,"
+"maxsize=5, filegrowth=10%)log on"
+"(name=mydbb_log, filename='C:\\mysql\\mydb_log.ldf',size=3,"
+"maxsize=20,filegrowth=1)"; cmd = new SqlCommand(sql, conn);
try
{
cmd.ExecuteNonQuery(); //
MessageBox.Show("...﹚!");
}
catch(SqlException ae)
{
MessageBox.Show(ae.Message.ToString());
}
建表
sql = "CREATE TABLE myTable"+
"(myId INTEGER CONSTRAINT PKeyMyId PRIMARY KEY,"+
"myName CHAR(50), myAddress CHAR(255), myBalance FLOAT)"; 粂
cmd = new SqlCommand(sql, conn);
try
{
cmd.ExecuteNonQuery();
sql = "INSERT INTO myTable(myId, myName, myAddress, myBalance) "+
"VALUES (1001, '㏄', '打玭', 1500 ) " ;
cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
sql = "INSERT INTO myTable(myId, myName, myAddress, myBalance) "+
"VALUES (1002, '', '玭', 1500) " ;
cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery(); sql = "INSERT INTO myTable(myId, myName, myAddress, myBalance) "+
"VALUES (1003, '法', 'ヌ德', 1500) " ;
cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery(); sql = "INSERT INTO myTable(myId, myName, myAddress, myBalance) "+
"VALUES (1004, '眎', '打玭', 1500) " ;
cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
MessageBox.Show("穌﹚!"); //InserTo(SQL,TableName)
}
catch(SqlException ae)
{
MessageBox.Show(ae.Message.ToString());
}
string sql = "CREATE DATABASE mydb ON PRIMARY"
+"(name=test_data, filename = 'C:\\mysql\\mydb_data.mdf', size=3,"
+"maxsize=5, filegrowth=10%)log on"
+"(name=mydbb_log, filename='C:\\mysql\\mydb_log.ldf',size=3,"
+"maxsize=20,filegrowth=1)"; cmd = new SqlCommand(sql, conn);
try
{
cmd.ExecuteNonQuery(); //
MessageBox.Show("...﹚!");
}
catch(SqlException ae)
{
MessageBox.Show(ae.Message.ToString());
}
建表
sql = "CREATE TABLE myTable"+
"(myId INTEGER CONSTRAINT PKeyMyId PRIMARY KEY,"+
"myName CHAR(50), myAddress CHAR(255), myBalance FLOAT)"; 粂
cmd = new SqlCommand(sql, conn);
try
{
cmd.ExecuteNonQuery();
sql = "INSERT INTO myTable(myId, myName, myAddress, myBalance) "+
"VALUES (1001, '㏄', '打玭', 1500 ) " ;
cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
sql = "INSERT INTO myTable(myId, myName, myAddress, myBalance) "+
"VALUES (1002, '', '玭', 1500) " ;
cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery(); sql = "INSERT INTO myTable(myId, myName, myAddress, myBalance) "+
"VALUES (1003, '法', 'ヌ德', 1500) " ;
cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery(); sql = "INSERT INTO myTable(myId, myName, myAddress, myBalance) "+
"VALUES (1004, '眎', '打玭', 1500) " ;
cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
MessageBox.Show("穌﹚!"); //InserTo(SQL,TableName)
}
catch(SqlException ae)
{
MessageBox.Show(ae.Message.ToString());
}
先判断电脑中有没有这两个文件:yourDataBase_Data,yourDataBase_Log若没有,则运行SQL脚本创建它。
IF EXISTS(select * from master..sysdatabases
where name='test')
DROP DATABASE test
go
CREATE DATABASE test