太平桥小学戴志泉:.net高手请帮忙

来源:百度文库 编辑:杭州交通信息网 时间:2024/04/28 22:40:21
请各位高手帮我看一下以下代码错在什么地方?多谢

Public Class write
Inherits System.Web.UI.Page

#Region " Web 窗体设计器生成的代码 "

'该调用是 Web 窗体设计器所必需的。
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()

End Sub
Protected WithEvents TextBox1 As System.Web.UI.WebControls.TextBox
Protected WithEvents TextBox2 As System.Web.UI.WebControls.TextBox
Protected WithEvents TextBox3 As System.Web.UI.WebControls.TextBox
Protected WithEvents Button1 As System.Web.UI.WebControls.Button
Protected WithEvents Button2 As System.Web.UI.WebControls.Button
Protected WithEvents Button3 As System.Web.UI.WebControls.Button

'注意: 以下占位符声明是 Web 窗体设计器所必需的。
'不要删除或移动它。
Private designerPlaceholderDeclaration As System.Object

Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
'CODEGEN: 此方法调用是 Web 窗体设计器所必需的
'不要使用代码编辑器修改它。
InitializeComponent()
End Sub

#End Region

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'在此处放置初始化页的用户代码
End Sub

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
TextBox1.Text = ""
TextBox2.Text = ""
TextBox3.Text = ""
End Sub

Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Response.Redirect("look.aspx")
End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
If TextBox1.Text = "" Or TextBox2.Text = "" Or TextBox3.Text = "" Then
Response.Write("<script language=vbscript>alert ""请将内容填写完整后再提交""</script>")
Else
Dim mycon As New OleDb.OleDbConnection
Dim mycmd As New OleDb.OleDbCommand
mycon.ConnectionString = "provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("luntan.mdb")
mycon.Open()
mycmd.Connection = mycon
mycmd.CommandText = "insert into table1(name,title,content,time_) values " & " ( '" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "','" & TextBox3.Text & "')"
mycmd.ExecuteNonQuery()
'mycmd = Nothing
'mycon.Close()
Response.Redirect("look.aspx")
End If
End Sub
End Class

我也不知道