sql语句错误吗？asp.net插入新记录问题

来源：百度知道编辑：UC知道时间：2024/05/30 20:14:00

<%@ Page Language="VB" MasterPageFile="MasterPage.master"
Title="add.aspx" %>
<%@ Import Namespace="System.Data" %>
<%@ Import NameSpace="System.Data.OleDb" %>
<script Runat="server">
Sub add(ByVal Sender As Object, ByVal E As EventArgs)
Dim objCon As OleDbConnection
Dim objCmd As OleDbCommand
Dim strSQL, strDbCon, idno As String
' OLEDB提供者字符串
strDbCon = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Server.MapPath("products.mdb")

objCon = New OleDbConnection(strDbCon)
objCon.Open() ' 打开数据库连接
' 建立添加订单的SQL命令
strSQL = "SELECT Count(*) FROM products"
objCmd = Ne

strSQL = "INSERT INTO products (id,name,type,color,weight,price,information) VALUES (5, 'name.Text','type.Text','color.txt','weight.txt','price.txt','information.txt')"

这里问题很严重

改成
strSQL = "INSERT INTO products (id,name,type,color,weight,price,information) VALUES (5, '" + name.Text + "','" + type.Text + "','" + color.txt + "','" + weight.txt + "','" + price.txt + "','" + information.txt + "')"

你把这条sql语句直接在query analizer 里边执行一下，如果出现错误它会给出详细的解释的

asp中的sql语句错误 sql语句错误吗？asp.net插入新记录问题 asp高手进来，sql语句中update错误！~ ！！！asp网页中Vbscript中sql语句的错误！！！ asp语句和SQL语句 asp..............sql语句？？？ asp中的sql语句? ASP的SQL语句 asp sql语句 ASP简单SQL语句