更新时间: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) )")