Mám problém, pokiaľ ide Zoradenie v Gridview. Nie som odborník v vb.net ale musím vyriešiť tento problém. Chcem vysvetliť, ako sa moje údaje prichádza v GridView.
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
//also there is some logic in there but I think that part of the code will not effect
loadgrid()
End Sub
loadgrid()
načíta sa na dotaz údajov prechádzajú niektoré kroky
//Táto funkcia sa používa pre niektoré logika
Private Sub loadgrid() Handles B_SEARCH.Click, chkLegacy.CheckedChanged, gvEmployer.PageIndexChanged
GridDataLoader()
End Sub
eEmployer
bude mať všetky údaje na dotaz pre gridView
Public Sub GridDataLoader()
//some code was there because of searching
Dim dataTable = Employer.getEmployers(eEmployer, chkLegacy.Checked)
gvEmployer.DataBind()
End Sub
Public Function GetEmployers(ByVal eEmployer As tblEmployer, ByVal All As Boolean, Optional ByVal sortExpression As String = Nothing) As DataTable
Dim query = ""
query =
"select employer.EmployerID as EmployerId,
employer.Employer_Name as EmployerName,
// the query is so large so i delete all for better understanding
on (employer.Modified_by=tum.UserID)
where employer.LegacyID IS NULL and address.ValidityTo is null"
'End If
Dim params = ""
If All = False Then
query += " AND employer.ValidityTo is null"
End If
If (params.Trim() IsNot "") Then
query = query & params
End If
data.setSQLCommand(query, CommandType.Text)
Return data.Filldata
End Function
napokon, dáta sa vracia do mriežke. ale môj problém je, že nie som pochopiť, ako môžem vykonávať triedenie vec. zmenil som niečo, čo je zobrazenie AllowSorting="true"
SortExpression="EmployerName"
a ja neviem, čo by som mal robiť ďalej. Bol som po tejto Articel