ASP.NET

    var st = stud.SelectById(id);
   // if (st == null)
   // {
   //     return HttpNotFound();
   // }
    if (st != null)
    {
        student1.First_Name = st.First_Name;
        student1.Middle_Name = st.Middle_Name;
        student1.Last_Name = st.Last_Name;
        student1.Contact_No = st.Contact_No;
        student1.Email_ID = st.Email_ID;
        student1.Temp_Address = st.temp_Address;
        student1.Permanant_Address = st.permanant_address;
        student1.CountryName = st.CountryName;
        student1.StateName = st.StateName;
        student1.CityName = st.CityName;
    }

    ViewBag.CityID = new SelectList(db.Cities, "CityID", "CityName", student1.CityID);
    ViewBag.CountryID = new SelectList(db.Countries, "CountryID", "CountryName", student1.CountryID);
    ViewBag.StateID = new SelectList(db.States, "StateID", "StateName", student1.StateID);
    return View(student1);
}

 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")