user.aspx.vb

该学生信息管理系统是我自己写的

Imports System.Data
Imports System.Data.SqlClient
Imports System
Imports System.Collections
Imports System.Web.UI.WebControls
Imports System.Web.UI.HtmlControls
Public Class User
    Inherits System.Web.UI.Page

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

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

    End Sub

    '注意: 以下占位符声明是 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
        Dim conn As New SqlConnection
        Dim i, j As Integer
        Dim DS As New DataSet
        Dim SqlStr As String
        conn.ConnectionString = "Data Source=MY-TOMATO;Initial Catalog=Student;User ID=sa;Password=sa"
        conn.Open()
        Dim objAdpt As New SqlDataAdapter("Select *from student,course,score", conn)
        SqlStr = "Select A.studentID,studentname,B.coursename,coursetime,grade,学分,got_学分 from student A,course B,score C where A.studentID=@studentID and A.studentID= C.studentID and B.coursename=C.coursename"
        objAdpt.SelectCommand.CommandText = SqlStr
        objAdpt.SelectCommand.Parameters.Add("@studentID", SqlDbType.VarChar, 10)
        objAdpt.SelectCommand.Parameters("@studentID").value = Session("usrname")
        objAdpt.Fill(DS, "student")

        Response.Write("<h2 align=center>查询学生信息如下</h2>")
        Dim stuTable As DataTable = DS.Tables("student")
        Response.Write("<table align=center border=2><tr align=center>")
        For i = 0 To stuTable.Columns.Count - 1
            Response.Write("<td>" & stuTable.Columns(i).Caption & "</td>")
        Next
        Response.Write("</tr>")
        For i = 0 To stuTable.Rows.Count - 1
            Response.Write("<tr>")
            For j = 0 To stuTable.Columns.Count - 1
                Response.Write("<td>" & stuTable.Rows(i).Item(j) & "</td>")
            Next
            Response.Write("</tr>")
        Next
        Response.Write("</table>")
        conn.Close()        '在此处放置初始化页的用户代码
    End Sub

End Class