用vb实现数据库的隔离级别
比如下面这个例子,在更新考试成绩的时候,想设置READ COMMITTED应该怎么写
Sub changeExamResult()
Dim str As String
'Dim frmName As String = "欢迎您"
str = "Data Source=localhost;Initial Catalog = Student;integrated Security=true"
Dim con As New SqlConnection(str)
con.Open()
Dim sql As String = "select * from result_Info where exam_No='" & TextBox1.Text.ToString().Trim() & "' "
'and user_Des='" & sMenuText & "'
Dim sql2 As String = "update result_Info set student_ID='" & TextBox2.Text.ToString().Trim() & "',student_Name='" & TextBox3.Text.ToString.Trim() & "',term='" & ComboBox1.Text.ToString.Trim() & "',class_No='" & TextBox5.Text.ToString.Trim() & "',course_Name='" & TextBox6.Text.ToString.Trim() & "',result='" & TextBox7.Text.ToString.Trim() & "' where exam_No='" & TextBox1.Text.ToString().Trim() & "' "
'director='" & TextBox2.Text.ToStr
相关问答:
为什么工具栏按扭的宽度改变不了,在属性里改了又变成原来的数值了
大胡子真厉害,回答基本都是爆料级的
大胡子升级真快啊,这才几天就5条短裤外加月排名第一了
想想我这5个短裤混了差不多8年才得到的。
回复 ......
帮我改改 我总觉得有问题
Type ID
number As Single
score As Integer
name As String * 6
End Type
Dim personl As ID, i%
Private Sub Command1_Click()
i = 0
&nbs ......
第一次接触CrystalReport
急寻找Vb.net Access 通过查询出的数据输出到CrystalReport的例子.
有的朋友麻烦发来学习.多谢!
跟你的要求差不多,参考一下:
http://topic.csdn.net/u/20090823/21/87af02d3-f4ca-480 ......
报这个错:
compile Error
sub or function not defined
和我引用这个库函数有关系吗?
Private Declare Function GetPrivateProfileString Lib "kernel32" Alias _
"GetPrivatePr ......