UC知道sql 插入数据行
来源：百度知道 编辑：UC知道 时间：2024/05/28 18:31:21
dim conn as sqlconnection
dim cmd as sqlcommand
conn=new sqlconnection("server=localhost;uid=sa;pwd=123456;database=user")
conn.open()
cmd=new sqlcommand("insert into us(name,secr) values(request.form.nam.text,request.form.pw.text)",conn)
conn.close()
请问是哪里错了,请各位高手指教,谢谢!!!
改了还是不行,详细代码如下:
<%@ import namespace="system.data" %>
<%@ import namespace="system.data.sqlclient" %>
<html>
<head>
<title>注册用户名</title>
<script runat="server">
sub button_click(sender as object, e as eventargs)
dim conn as sqlconnection
dim cmd as sqlcommand
conn=new sqlconnection("server=localhost;uid=sa;pwd=123456;database=user")
conn.open()
cmd=new sqlcommand("insert into us(name,secr) values('"&request.form.nam.text&"','"&request.form.pw.text&"')",conn)
dim cmd as sqlcommand
conn=new sqlconnection("server=localhost;uid=sa;pwd=123456;database=user")
conn.open()
cmd=new sqlcommand("insert into us(name,secr) values(request.form.nam.text,request.form.pw.text)",conn)
conn.close()
请问是哪里错了,请各位高手指教,谢谢!!!
改了还是不行,详细代码如下:
<%@ import namespace="system.data" %>
<%@ import namespace="system.data.sqlclient" %>
<html>
<head>
<title>注册用户名</title>
<script runat="server">
sub button_click(sender as object, e as eventargs)
dim conn as sqlconnection
dim cmd as sqlcommand
conn=new sqlconnection("server=localhost;uid=sa;pwd=123456;database=user")
conn.open()
cmd=new sqlcommand("insert into us(name,secr) values('"&request.form.nam.text&"','"&request.form.pw.text&"')",conn)
dim conn as sqlconnection
dim cmd as sqlcommand
conn=new sqlconnection("server=localhost;uid=sa;pwd=123456;database=user")
conn.open()
cmd=new sqlcommand("insert into us(name,secr) values('"&request.form.nam.text&"','"&request.form.pw.text&"')",conn)
conn.close()
密码和用户名一般是字符，注意要加''
cmd=new sqlcommand("insert into us(name,secr) values(request.form.nam.text,request.form.pw.text)",conn)
改成
cmd=new sqlcommand("insert into us(name,secr) values("+request.form.nam.text+","+request.form.pw.text+")",conn)