首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 网站开发 > asp.net >

file附近有语法异常?

2012-04-11 
file附近有语法错误??Dim cmd As SqlCommandmyconn New SqlConnection(serverlocalhostdatabasedata

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>")

[解决办法]
[file] 试试
[解决办法]
sql关键字加 []
sqlstr = "insert into [file](score) values('" + TextBox2.Text + " ')"
[解决办法]

SQL code
insert into [File](score) values('ss')
[解决办法]
SQL code
INSERT INTO [file]([score])VALUES('123') 

热点排行