public void fillLView()
{
SqlCommand cmd = new SqlCommand("SELECT dbo.PeerAdviser.TeachingSubject, dbo.PeerAdviser.PAdviserId, dbo.PeerAdviser.StudentNumber, dbo.Student.StudentName, dbo.PeerAdviser.OrganizationId, dbo.PeerAdviser.Status, CONVERT(date, dbo.PeerAdviser.DateRegistered) AS DateReg, dbo.PeerAdviser.Contact FROM dbo.Student INNER JOIN dbo.PeerAdviser ON dbo.Student.StudentNumber = dbo.PeerAdviser.StudentNumber WHERE STATUS = 'ACTIVE'");
ListViewPAdvisers.DataSource = Class2.getDataSet(cmd);
ListViewPAdvisers.DataBind();
}
public void sortBySubject(string column, string key)
{
SqlCommand cmd = new SqlCommand("SELECT dbo.PeerAdviser.TeachingSubject, dbo.PeerAdviser.PAdviserId, dbo.PeerAdviser.StudentNumber, dbo.Student.StudentName, dbo.PeerAdviser.OrganizationId, dbo.PeerAdviser.Status, CONVERT(date, dbo.PeerAdviser.DateRegistered) AS DateReg, dbo.PeerAdviser.Contact FROM dbo.Student INNER JOIN dbo.PeerAdviser ON dbo.Student.StudentNumber = dbo.PeerAdviser.StudentNumber WHERE STATUS = 'ACTIVE' AND " + column + " LIKE '%" + key + "%'");
ListViewPAdvisers.DataSource = Class2.getDataSet(cmd);
ListViewPAdvisers.DataBind();
}
