ASP.NET如何执行SQL命令 - .NET技术 / ASP.NET

ASP.NET如何执行SQL命令？如：创建新表CREATE TABLE的命令，如何编写执行代码。用VB语言，完整的代码。谢谢了。

---

沙发。。。。。。。。
帮顶

---

C# code:
StringBuilder strSql=new StringBuilder();
strSql.Append(@"CREATE TABLE [tb2] (
[id] [bigint] IDENTITY (1, 1) NOT NULL ,
[tb1_id] [bigint] NULL ,
[type] [int] NULL ,
CONSTRAINT [PK_tb2] PRIMARY KEY CLUSTERED
(
[id]
) ON [PRIMARY]
) ON [PRIMARY]");


DbHelperSQL.ExecuteSql(strSql.ToString(),null);

---

引用

C# code StringBuilder strSql=new StringBuilder();
strSql.Append(@"CREATE TABLE [tb2] (
[id] [bigint] IDENTITY (1, 1) NOT NULL ,
[tb1_id] [bigint] NULL ,
[type] [int] NULL ,
CONSTRAINT [PK_tb2] PRIMARY KEY CLUSTERED <