vb.net对数据库操作没效果求解
Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
If Session("DN") = "电脑,价格1998" Then
Dim myconn As New OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|数据表.accdb;")
myconn.Open()
Dim sql As String = "INSERT INTO 表2 (SN,SJ) VALUES ('电脑','1998')"
End If
If Session("DS") = "液晶电视,价格2888" Then
Dim sql1 As String = "INSERT INTO 表2 (SN,SJ) VALUES ('液晶电视','2888')"
End If
If Session("KZ") = "裤子,价格199" Then
Dim sql1 As String = "INSERT INTO 表2 (SN,SJ) VALUES ('裤子','199')"
End If
Response.Redirect("tiandizhi.aspx")
End Sub
这样写为什么数据库里没有数据???求解语法错了还是怎么了???