谁来帮我讲一下insert,delete,update的语法问题嘛,实在是搞不清楚,尤其是那些标点符号

问题就是每个值后面那个标点符号之类的东西该怎么用啊?

Dim conn As OleDbConnection
Dim str As String
conn = New OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=" & Server.MapPath("test.mdb"))
str = "select count(*) from admin where adminname='" + TextBox1.Text + "'and adminpassword='" + TextBox2.Text + "'"
Dim cmd As New OleDbCommand(str, conn)

Try
conn.Open()

Dim count As String

count = cmd.ExecuteScalar
If count <> 0 Then
Dim str1 As String
str1 = "update admin set adminpassword='" + TextBox3.Text + " '"

Label1.Text = "密码修改成功"

TextBox1.Text = ""
TextBox2.Text = ""
TextBox3.Text = ""
TextBox4.Text = ""
Else
Label1.Text = "用户名或者原密码错误"

End If
conn.Close()

Catch ex As Exception
Response.Write(ex.Message)
End Try



结果是提示了修改成功!但是数据库里面就是没改!

这个好象不是问题,因为我其它也有类似的操作也没问题，去掉try也没问题的,逐程序也是正常的,但是他显示了修改成功数据库也没改,我就想可能是update语句是不是有什么问题?

谢谢版主,很齐全,慢慢学习!

select * from table1 where que like '%"&amp; textbox1.text&amp;"%'这句有问题吗，为什么我怎么都查不出结果来？

啊我就是用的ACCESS

还是不行
帮我看看是不是程序有问题啊！！！
Dim conn As OleDbConnection
Dim str As String
conn = New OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=" & Server.MapPath("test.mdb"))
str = "select * from selecting where question like '%% TextBox1.Text %%'"

Dim dt As New DataTable

Dim cmd As New OleDbCommand(str, conn)
Dim da As New OleDbDataAdapter(cmd)

Try
conn.Open()
da.Fill(dt)

Dim count As String

count = cmd.ExecuteScalar

If count = 0 Then
Label2.Text = "对不起，没有符合条件的题目！"
Return
Else
DataGrid1.DataSource = dt
DataGrid1.DataBind()

End If
conn.Close()

Catch ex As Exception
Response.Write(ex.Message)

End Try