ASP.NET

Hi Sir,

Need help, i noob in Asp.net. Using VB for my coding;

Situation :-

a) Using Master Page 
b) Got 3 web Form ( Staff.aspx,student.aspx,external.aspx)
c) Every form have Search Textbox

In Staff.aspx, search Textbox working great when connecting to Oracle Database and appear the data holder in other textbox.
But when using Student.aspx or External.aspx, the Search Textbox will appear No Data / Cardholder , in database the data is exist.
the Sql query it ok when i direct include the User ID but when keep in in textbox cannot appear the data.

Plz guide me

Tq

Protected Sub WriteToExcelFile(dt As DataTable)
    'This method exports the resulting query datatable to an instance of Excel using StringWriter
    If Not dt Is Nothing Then
        Dim sw As New StringWriter()
        'Loop through the column names and output those first
        For Each datacol As DataColumn In dt.Columns
            sw.Write(datacol.ColumnName + vbTab)
        Next
        Dim row As DataRow
        'Loop through the datatable's rows
        For Each row In dt.Rows
            'Newline between the previous row and the next row
            sw.Write(vbNewLine)
            Dim column As New DataColumn()
            'Loop through each column and write the cell the the stringwriter
            For Each column In dt.Columns
                'If the cell isn't empty write it, else write an empty cell
                If Not row(column.ColumnName) Is Nothing Then
					sw.Write("=""" & row(column).ToString().Trim() & """" & vbTab)
                    Else
                        sw.Write(String.Empty + vbTab)
                    End If
                Next column
            Next row
            'create an instance of Excel and write the data
            Response.Clear()
            Response.ContentType = "application/vnd.ms-excel"
            Response.AddHeader("Content-Disposition", "attachment;filename=GridViewExport.xls")
            Response.Output.Write(sw.ToString())
            Response.Flush()
            System.Web.HttpContext.Current.Response.Flush()
            System.Web.HttpContext.Current.Response.SuppressContent = True
            System.Web.HttpContext.Current.ApplicationInstance.CompleteRequest()
        End If
End Sub

ViewData["sentResponseType"] = new SelectList(_context.EntityType.Where(g => g.EntityKey == "sentResponseType")
        .Include(x => x.ApiApplicantHistoryLastReqStatusNavigation).ToList(), "ID", "name");

ViewBag.sentResponseType

public async Task<IActionResult> Edit(int id, ApplicantViewModel applicant)
    {
        var formerApplicantType = await _context.Applicant
            .Include(a => a.ApplicantTypeNavigation)
            .FirstOrDefaultAsync(m => m.ApplicantId == id);

        if (id != applicant.applicantvm.ApplicantId)
        {
            return NotFound();
        }

        if (ModelState.IsValid)
        {
            try
            {
                if (applicant.applicantvm.ApplicantType == 1)
                {
                    var UpdQuery = from a in _context.Applicant
                                   join p in _context.PersonApplicant on a.ApplicantId
                                   equals p.ApplicantId
                                   where applicant.applicantvm.ApplicantId == a.ApplicantId && applicant.applicantvm.ApplicantType == a.ApplicantType
                                   select new { a, p };

                    if (formerApplicantType.ApplicantType == 2)
                    {
                        Debug.WriteLine("opposite applicantType");

                        var legalApplicantForDelete = await _context.LegalApplicant.FindAsync(id);
                        _context.LegalApplicant.Remove(legalApplicantForDelete);

                        //?????
                        var pa = new PersonApplicant()
                        {
                            BirthCertificateNo = applicant.personapplicantvm.BirthCertificateNo,
                            IssuePlace = applicant.personapplicantvm.IssuePlace,
                            NationalCode = applicant.personapplicantvm.NationalCode,
                            Username = applicant.personapplicantvm.Username,
                            Applicant = applicant.applicantvm
                        };
                        using (var context = new CSSDDashboardContext())
                        {
                            context.PersonApplicant.Add(pa);
                            context.SaveChanges();
                        }
                    }
                    else
                    {


                        //----------------------------------------------
                        foreach (var x in UpdQuery.ToList())
                        {
                            x.a.ApplicantType = applicant.applicantvm.ApplicantType;
                            x.a.Address = applicant.applicantvm.Address;
                            x.a.Description = applicant.applicantvm.Description;
                            x.a.Name = applicant.applicantvm.Name;
                            x.p.BirthCertificateNo = applicant.personapplicantvm.BirthCertificateNo;
                            x.p.NationalCode = applicant.personapplicantvm.NationalCode;
                            x.p.IssuePlace = applicant.personapplicantvm.IssuePlace;
                            x.p.Username = applicant.personapplicantvm.Username;

                        }
                    }

                await _context.SaveChangesAsync();

            }
            catch (DbUpdateConcurrencyException)
            {
                if (!ApplicantExists(applicant.applicantvm.ApplicantId))
                {
                    return NotFound();
                }
                else
                {
                    throw;
                }
            }
            return RedirectToAction(nameof(Index));
        }
        ViewData["ApplicantType"] = new SelectList(_context.EntityType, "Id", "Id", applicant.applicantvm.ApplicantType);
        return View(applicant);
    }