62,267
社区成员
发帖
与我相关
我的任务
分享file附近有语法错误？？
Dim cmd As SqlCommand
myconn = New SqlConnection("server=localhost;database=database;uid=sa;pwd=sa")
Dim sqlstr As String = ""
sqlstr = "insert into file(score) values('" + TextBox2.Text + " ')"
myconn.Open()
cmd = New SqlCommand(sqlstr, myconn)
cmd.ExecuteNonQuery()
cmd.Dispose()
myconn.Close()
sqlstr = ""
Response.Write("<script>alert('添加成功！');location.href='teacher5.aspx';</script>")
myconn = New SqlConnection("server=localhost;database=database;uid=sa;pwd=sa")
Dim sqlstr As String = ""
sqlstr = "insert into file(score) values('" + TextBox2.Text + " ')"
myconn.Open()
cmd = New SqlCommand(sqlstr, myconn)
cmd.ExecuteNonQuery()
cmd.Dispose()
myconn.Close()
sqlstr = ""
Response.Write("<script>alert('添加成功！');location.href='teacher5.aspx';</script>")
...全文
请发表友善的回复…
发表回复
Im_Sorry 2012-04-01
- 打赏
- 举报
哦买噶，你们老师没教你们 不要使用关键字么？
全局变量 2012-04-01
- 打赏
- 举报
INSERT INTO [file]([score])VALUES('123')
人生难得一只鸡 2012-04-01
- 打赏
- 举报
insert into [File](score) values('ss')全局变量 2012-04-01
- 打赏
- 举报
INSERT INTO file(score)VALUES('123')
EnForGrass 2012-04-01
- 打赏
- 举报
sql关键字加 []
sqlstr = "insert into [file](score) values('" + TextBox2.Text + " ')"
sqlstr = "insert into [file](score) values('" + TextBox2.Text + " ')"
bdmh 2012-04-01
- 打赏
- 举报
[file] 试试
