且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

在运行时在现有数据库中创建表

更新时间:2023-02-03 16:57:55

您错过了括号(表名周围的[]也不会受到损害):
You missed the parenthesis (also [] around table names wouldn''t hurt):
db.Execute ("CREATE TABLE  [" & TabName & "] (" _
            & "Invoice_No Text(20)," _
            & " Supplier_Name Text(20)," _
            & " Purchase_Date Date," _
            & " Delivery_Date Date," _
            & " Material_Type Text(20)," _
            & " Material_Name Text(20)," _
            & "Order_Qty Number(DOUBLE)," _
            & "Price_Per_Unit Number(DOUBLE)," _
            & "Total_Amount Number(DOUBLE)," _
            & "Received_Qty Number(DOUBLE)," _
            & "Qty_Instock Number(DOUBLE) )")




请查看以下链接:

http://www .c-sharpcorner.com/uploadfile/manishkdwivedi/create-table-at-run-time-in-database-by-using-Asp-Net/ [ http://www.developerfusion.com/code/3039/create-table-in -a-database/ [ ^ ]

http://www.dotnetcurry.com/ShowArticle.aspx?ID=135 [ ^ ]


check out below link:

http://www.c-sharpcorner.com/uploadfile/manishkdwivedi/create-table-at-run-time-in-database-by-using-Asp-Net/[^]

http://www.developerfusion.com/code/3039/create-table-in-a-database/[^]

http://www.dotnetcurry.com/ShowArticle.aspx?ID=135[^]


检查此
http://www.programmersheaven .com/mb/VBNET/351660/351660/creating-table-during-run-time-in-vbnet --- urgent/ [
Check this
http://www.programmersheaven.com/mb/VBNET/351660/351660/creating-table-during-run-time-in-vbnet---urgent/[^]

try this
db.Execute ("CREATE TABLE  [" & TabName & "] (" _
                & "Invoice_No VarChar(20)," _
                & " Supplier_Name VarChar(20)," _
                & " Purchase_Date DateTime," _
                & " Delivery_Date DateTime," _
                & " Material_Type VarChar(20)," _
                & " Material_Name VarChar(20)," _
                & "Order_Qty Number(DOUBLE)," _
                & "Price_Per_Unit Number(DOUBLE)," _
                & "Total_Amount Number(DOUBLE)," _
                & "Received_Qty Number(DOUBLE)," _
                & "Qty_Instock Number(DOUBLE) )")