如何创建两个表？

[wfl_1000]

conn1 = New SqlConnection(ConnectionString)
If (strSecond > 19 And strSecond <= 59) Or (strSecond >= 0 And strSecond <= 7) Then

If conn1.State = ConnectionState.Open Then
conn1.Close()
End If
conn1.ConnectionString = ConnectionString
conn1.Open()
sql1 = "CREATE TABLE " + theName1 + "(Time NVARCHAR(50) Null,myid NVARCHAR(50) Null,myname NVARCHAR(50) NOT Null,myaddress NVARCHAR(50) Null)"
cmd1 = New SqlCommand(sql1, conn1)
上面这段代码只可以创建一个表。但是我想创建两个表，为什么下面这段不可以？

conn1 = New SqlConnection(ConnectionString)
conn2 = New SqlConnection(ConnectionString)

If (strSecond > 19 And strSecond <= 59) Or (strSecond >= 0 And strSecond <= 7) Then

If conn1.State = ConnectionState.Open Then
conn1.Close()
End If
conn1.ConnectionString = ConnectionString
conn1.Open()
sql1 = "CREATE TABLE " + theName1 + "(Time NVARCHAR(50) Null,myid NVARCHAR(50) Null,myname NVARCHAR(50) NOT Null,myaddress NVARCHAR(50) Null)"
cmd1 = New SqlCommand(sql1, conn1)


If conn2.ConnectionString = ConnectionString Then
conn2.Close()
End If
conn2.ConnectionString = ConnectionString
conn2.Open()
sql2 = "CREATE TABLE " + theName2 + "(Time NVARCHAR(50) Null,myid NVARCHAR(50) Null,myname NVARCHAR(50) NOT Null,myaddress NVARCHAR(50) Null)"
cmd2 = New SqlCommand(sql2, conn2)

[wuyq11]

用二楼方法就可，定义一个SqlConnection就可。

[wfl_1000]

谢谢：xiaoxuanZhu 的及时回复！问题解决了！多谢大家的支持！

[晓轩]

conn1 = New SqlConnection(ConnectionString)
If (strSecond > 19 And strSecond <= 59) Or (strSecond >= 0 And strSecond <= 7) Then

If conn1.State = ConnectionState.Open Then
conn1.Close()
End If
conn1.ConnectionString = ConnectionString
conn1.Open()
sql1 = "CREATE TABLE " + theName1 + "(Time NVARCHAR(50) Null,myid NVARCHAR(50) Null,myname NVARCHAR(50) NOT Null,myaddress NVARCHAR(50) Null)"
cmd1 = New SqlCommand(sql1, conn1)
cmd1.ExecuteNonQuery
sql1 = "CREATE TABLE " + theName2 + "(Time NVARCHAR(50) Null,myid NVARCHAR(50) Null,myname NVARCHAR(50) NOT Null,myaddress NVARCHAR(50) Null)"
cmd1.commandtext=sql1
cmd1.ExecuteNonQuery