Imports System.Data
Imports System.Data.SqlClient

Public Class InquiryWithButton
    Inherits System.Web.UI.Page
    Protected WithEvents Label1 As System.Web.UI.WebControls.Label
    Protected WithEvents StudentNameToLookup As System.Web.UI.WebControls.TextBox
    Protected WithEvents Button1 As System.Web.UI.WebControls.Button
    Protected WithEvents DataGrid1 As System.Web.UI.WebControls.DataGrid

#Region " Web Form Designer Generated Code "

    'This call is required by the Web Form Designer.
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()

    End Sub

    Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
        'CODEGEN: This method call is required by the Web Form Designer
        'Do not modify it using the code editor.
        InitializeComponent()
    End Sub

#End Region

    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        'Put user code to initialize the page here
    End Sub

    Private Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim sDSN As String
        sDSN = "server=student.bus.olemiss.edu;uid=dbdemo;pwd=dbpass;database=EmailDemo"

        Dim DS As DataSet
        Dim MyConnection As SqlConnection
        Dim MyCommand As SqlDataAdapter

        Dim MySQL As String
        If UCase(StudentNameToLookup.Text) = "ALL" Then
            MySQL = "SELECT * FROM Students"
        Else
            MySQL = "SELECT * FROM Students WHERE StudentName='" & StudentNameToLookup.Text & "'"
        End If
        MyConnection = New SqlConnection(sDSN)
        MyCommand = New SqlDataAdapter(MySQL, MyConnection)

        DS = New DataSet()
        MyCommand.Fill(DS, "Students")

        DataGrid1.DataSource = DS.Tables("Students").DefaultView
        DataGrid1.DataBind()

        MyCommand.Dispose()
        MyConnection.Dispose()
        DS.Dispose()

    End Sub
End Class