ASP.NET

 Protected Sub LogonBtn_Click(sender As System.Object, e As System.EventArgs) Handles LogonBtn.Click

        Try

            Using conn As OleDbConnection = New OleDbConnection(System.Configuration.ConfigurationManager.ConnectionStrings("students").ConnectionString)

                conn.Open()

                Dim strEmailValue As String = strEmail.Text
                Dim passwordValue As String = password.Text
                Dim MSAccess As String = "Provider=Microsoft.Jet.OleDb.4.0; Data Source=|DataDirectory|students.mdb;"
                Dim ConnectionString As String = "SELECT * FROM university WHERE strEmail = '" & strEmailValue & "' AND [password] = '" & passwordValue & "'"

                Dim cmd As New OleDbCommand

                Dim reader As OleDbDataReader = cmd.ExecuteReader

                Dim strEmailFound As Boolean = False

                Dim passwordFound As Boolean = False

                'if in database:

                While reader.Read

                    strEmailFound = True

                    strEmailValue = reader("strEmail")

                    passwordFound = True

                    passwordValue = reader("password")

                End While

                conn.Close()

                'check result

                If strEmailFound = True And passwordFound = True Then

                    Dim target = String.Format("~/userpage.aspx?strEmail={0}", strEmailValue)

                    Response.Redirect(target, True)

                End If

            End Using

        Catch ex As Exception

            Console.WriteLine(ex.Message)

            Dim MessageBox As String

            MessageBox = "Sorry, email or password not found"

        End Try

    End Sub

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

        'Dim strEmailValue As String = ""

        'Dim strEmailValue As String = strEmail.Text

        If Not IsPostBack Then

            strEmail.Text = String.Format("{0}", Request.QueryString("strEmail"))

        End If

        LblDate.Text = ReturnDate()

        strEmail.Focus()

    End Sub

End Class

    Mapper.CreateMap<Student, Student1>();
    var dbContext = new WorkTraningEntities();
    StudentCRUD stud = new StudentCRUD();
    var students = stud.SelectAll();
    List<Student1> stud1 = Mapper.Map<List<Student1>>(students);
  return View(stud1);

}

Index

@Html.ActionLink("Create New", "Create")