Question

在asp.net中如何插入带有条件的sql语句

Dim insertstr As String = "insert into tb_Exam(CourseID,ExamName,TeacherNum,CreationTime,LimitedTime,Pass) values(" & CInt(ddlCourseID.SelectedValue) & ",'" & txtTitle.Text & "','" & Me.txtTeacherID.Text.Trim & "','" & Me.txtCreationTime.Text.Trim & "'," & Me.txtLimitedTime.Text.Trim & "," & Me.txtPass.Text.Trim & ") select @@IDENTITY as id"
如何添加判断语言 ExamID='"&id&"'

Answer 1

你可以用存储过程去做那样简单 声明一个变量接收@@IDENTITY然后给参数赋值