使用sql命令创建数据库表 [英] to make database table using sql comand

问题描述

我需要在vb.net中使用sql命令制作tabale。我的命令在下面。但它的错误

i need make tabale using sql comand in vb.net. my comand is below.but its wrong

Dim conStr As String = "Data Source=.\SQLEXPRESS;AttachDbFilename=C:\aInven\Database\esay_master_database.mdf;Integrated Security=True;User Instance=True"
Dim DBCon As New SqlConnection(conStr)
Dim obj As SqlCommand
Dim strSQL As String



' Create a table
conStr = "Data Source=.\SQLEXPRESS;AttachDbFilename=C:\aInven\Database\esay_master_database.mdf;Integrated Security=True;User Instance=True"
DBCon = New SqlConnection(conStr)
DBCon.Open()
obj = DBCon.CreateCommand()
strSQL = "CREATE TABLE " & TextBox2.Text & " (No int, Date text, Amount money, Cheque money, Cash money, Balance money, AC_No varchar(30), Cheque_no1 varchar(30), Cheque_no2 varchar(30), Released_date_cqe1 text, Released_date_cqe2 text, Value_cqe1 money, Value_cqe2 money PRIMARY KEY(NO))"

' Execute
obj.CommandText = strSQL
Try
    obj.ExecuteNonQuery()
Catch ex As Exception
    MessageBox.Show(ex.Message)
End Try

推荐答案

我认为你的连接有问题。请你检查你的连接是否正常。调试你的代码和检查你的数据库连接。检查这样。

Hi,
I think your connection has problem.Did u check with your connection is that ok.Debug your code and check for your DB Connection.Check like this.

Dim conStr As String = "Server=yourServerName;Database=YourDBName;Trusted_Connection = yes"
Dim objCon As New SqlConnection(conStr)

这篇关于使用sql命令创建数据库表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！