cm d.Com mandText = "ins ert in to 回答明细(openid,题目序号,题目id,题目类型,题目分数,题目内容,选项A,选项B,选项C,选项D) Sel ect '" & OpenidA & "',100+Row_Number() Over(Order by uid) As RowNum,Row_Number() Over(Order by uid) As RowNuma,DisplayValue,branch,subject,AnswerA,AnswerB,AnswerC,AnswerD fro m 练习题 WH ERE id='" & pageA & "'"
Dim oip As String = cmd.ExecuteNonQuery()
这种SqlServer语句如何向项目这种方式写
Dim cmd As new SQLCommand
cmd.ConnectionName = "orders"
cmd.CommandText = "Insert Into 员工 (姓名, 年龄, 学历, 照片) Values(?,?,?,?)"
cmd.Parameters.Add("@姓名",Name)
cmd.Parameters.Add("@年龄",Age)
cmd.Parameters.Add("@学历",XueLi)
cmd.Parameters.Add("@照片",Files)
cmd.ExecuteNonQuery()