tijiaozuoye.aspx.vb

教务选课系统 教务选课系统 教务选课系统

Imports System.Data
Imports System.Data.OleDb
Partial Class tijiaozuoye
    Inherits System.Web.UI.Page

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Label1.Text = Session("yonghuming")
    End Sub

    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim MyCon As New OleDbConnection()
        Dim cmd As New OleDbCommand()

        cmd.Connection = MyCon
        cmd.CommandType = CommandType.Text
        MyCon.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("db1.mdb")
        MyCon.Open()
        cmd.CommandText = "update xskc set 作业='" & TextBox1.Text & "' where yonghuming = '" & Session("yonghuming") & " '"
        cmd.ExecuteNonQuery()
        cmd.Cancel()
        MyCon.Close()
        Response.Redirect("xuesheng.aspx")
        Session("yonghuming") = Label1.Text
    End Sub

    Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click
        Session("yonghuming") = Label1.Text
        Response.Redirect("xuesheng.aspx")
    End Sub
End Class