C# 创建SQL Server 2005数据库及建表
来源:互联网 发布:正规网络兼职有哪些 编辑:程序博客网 时间:2024/05/28 16:14
C# 创建SQL Server 2005数据库及建表
2010-10-28 17:39:46| 分类:C# | 标签:c# 创建数据库 建表 system.data.sqlclient |字号大中小 订阅
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;
namespace notebook
{
class MyDB
{
private const string DB_NAME = "NOTEBOOK";
private const string DB_PATH = "E:\\notebook\\";
private string ConnectionString = "Integrated Security=SSPI;" +
"Initial Catalog=" + DB_NAME + ";" +
"Data Source=localhost;";
private SqlConnection conn = null;
private SqlCommand cmd = null;
private string sql = null;
public MyDB()
{
}
//------------------------------------创建数据库------------------------------------------------------------------------
public void createDB()
{
string newConnectionString = "Integrated Security=SSPI;Initial Catalog=;Data Source=localhost;";
conn = new SqlConnection(newConnectionString);
// 打开数据库连接
if (conn.State != ConnectionState.Open)
conn.Open();
string sql = "CREATE DATABASE " + DB_NAME + " ON PRIMARY" +
"(name=test_data,filename = '" + DB_PATH + DB_NAME + ".mdf', size=3," +
"maxsize=5,filegrowth=10%)log on" +
"(name=mydbb_log,filename='" + DB_PATH + DB_NAME + "_log.ldf',size=3," +
"maxsize=20,filegrowth=1)";
cmd = new SqlCommand(sql, conn);
try
{
cmd.ExecuteNonQuery();
this.createTable();
}
catch (SqlException ae)
{
MessageBox.Show(ae.Message.ToString());
}
finally
{
if (conn.State == ConnectionState.Open)
conn.Close();
}
}
//------------------------------------建表--------------------------------------------------------------------------
private void createTable()
{
// 打开数据库连接
if (conn.State == ConnectionState.Open)
conn.Close();
conn.ConnectionString = ConnectionString;
conn.Open();
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, 'Puneet Nehra', 'A 449 Sect 19, DELHI', 23.98 ) ";
cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
sql = "INSERT INTO myTable(myId, myName,myAddress, myBalance) " +
"VALUES (1002, 'Anoop Singh', 'Lodi Road, DELHI', 353.64) ";
cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
sql = "INSERT INTO myTable(myId, myName, myAddress, myBalance) " +
"VALUES (1003, 'Rakesh M', 'Nag Chowk, Jabalpur M.P.', 43.43) ";
cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
sql = "INSERT INTO myTable(myId, myName, myAddress, myBalance) " +
"VALUES (1004, 'Madan Kesh', '4th Street, Lane 3, DELHI', 23.00) ";
cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
}
catch (SqlException ae)
{
MessageBox.Show(ae.Message.ToString());
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
conn.Dispose();
}
}
}
}
}
说明:要确保E盘下存在notebook这个文件夹,否则会报错。
转载请说明出处
自动检查待改进
- C# 创建SQL Server 2005数据库及建表
- c# 创建SQL Server2005数据库及建表
- C#创建SQL Server数据库浅析
- SQL Server系统安装及数据库创建
- SQL SERVER 2012创建数据库,使用数据库以及建表
- SQL server创建数据库
- SQL Server创建数据库
- sql server 创建数据库
- SQL Server创建数据库
- SQL Server创建数据库
- 创建SQL Server数据库
- SQL Server 数据库创建
- sql Server创建数据库
- sql server数据库及c#操作sql server数据库(第四次C#作业)
- Visual C# .NET 以编程方式创建 SQL Server 数据库
- C#使用ADO.NET创建SQL Server数据库
- C# 创建sql数据库
- 创建数据库用户 (SQL Server 2005)
- FOB价格计算
- C#中 一次执行多条带GO的sql语句
- win32程序测试键盘钩子
- java 网络编程 -- IP地址的表示与网络接口信息的获取(InetAddress和NetworkInterface)
- android 相对布局
- C# 创建SQL Server 2005数据库及建表
- java 集合类型的clone
- HDU 2897 邂逅明下
- 爱 不说再见
- Java字符串跟ASCII码互转 收藏
- Android下打印调用栈
- WorkflowApplication 应用中变量、参数、书签
- cocos2d-x Action:补间动作
- go语言编程在windows下开发环境配置(图文)