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);
    }

Protected Sub DDLbuilding_SelectedIndexChanged(sender As Object, e As EventArgs) Handles DDLbuilding.SelectedIndexChanged
        'Create DataTable
        Dim dtRooms As New DataTable() ' - Room Numbers
        dtRooms.Columns.Add("Room", Type.GetType("System.String"))

        'Get Buildings for this campus
        RoomTable = RoomAdapter.GetRooms(DDLbuilding.SelectedValue)

        'Fill DataTable
        For Each RoomRow In RoomTable
            dtRooms.Rows.Add()
            dtRooms.Rows(dtRooms.Rows.Count - 1)("Room") = RoomRow.Room
        Next

        'bind DDLroom to datatable
        DDLroom.DataSource = dtRooms
        DDLroom.DataBind()
    End Sub

Protected Sub cbEQName_SelectedIndexChanged(sender As Object, e As EventArgs)

     'Get row index of selected comboBox
     Dim gvRow As GridViewRow = CType(CType(sender, Control).Parent.Parent, GridViewRow)
     Dim index As Integer = gvRow.RowIndex

     'Get selected value of selected comboBox
     EQname = TryCast(GVnewEquipment.Rows(index).FindControl("cbEQname"), AjaxControlToolkit.ComboBox).Text

     'Get new values of next comboBox from selected value of selected comboBox
     EquipmentTable = EquipmentAdapter.GetMfg(EQname)

     'Create DataTable
     Dim dtMfgs As New DataTable() ' - mfgs that are used by Equiptment name
     dtMfgs.Columns.Add("mfg", Type.GetType("System.String"))

     'Fill DataTable
     For Each EquipmentRow In EquipmentTable
         dtMfgs.Rows.Add()
         dtMfgs.Rows(dtMfgs.Rows.Count - 1)("mfg") = EquipmentRow.mfg
     Next

     'create ComboBox which will represent GVnewQuipment cbMfg comboBox
     Dim CB = DirectCast(GVnewEquipment.Rows(index).FindControl("cbMfg"), AjaxControlToolkit.ComboBox)

     'bind cbMfg to datatable
     CB.DataSource = dtMfgs
     CB.DataBind()

 End Sub