public void sortByDept(string column, string key) { SqlCommand cmd = new SqlCommand("SELECT dbo.Department.DeptName, dbo.AcademicAdviser.AAdviserId, dbo.AcademicAdviser.LName + ', ' + dbo.AcademicAdviser.FName + ' (' + dbo.AcademicAdviser.MName + ')' as [FullName], dbo.AcademicAdviser.Status, dbo.AcademicAdviser.DateRegistered FROM dbo.AcademicAdviser INNER JOIN dbo.Department ON dbo.AcademicAdviser.DeptId = dbo.Department.DeptId WHERE Status = 'ACTIVE' and " + column + " LIKE '%" + key + "%'"); ListViewAAdvisers.DataSource = Class2.getDataSet(cmd); ListViewAAdvisers.DataBind(); }
public void populateLView() { SqlCommand cmd = new SqlCommand("SELECT dbo.Department.DeptName, dbo.AcademicAdviser.AAdviserId, dbo.AcademicAdviser.LName + ', ' + dbo.AcademicAdviser.FName + ' (' + dbo.AcademicAdviser.MName + ')' as [FullName], dbo.AcademicAdviser.Status, dbo.AcademicAdviser.DateRegistered FROM dbo.AcademicAdviser INNER JOIN dbo.Department ON dbo.AcademicAdviser.DeptId = dbo.Department.DeptId"); ListViewAAdvisers.DataSource = Class2.getDataSet(cmd); ListViewAAdvisers.DataBind(); }
public void sortByDept(string column, string key) { string act; if (Session["AArchive"] == "NO") { act = "ACTIVE"; } else { act = "INACTIVE"; } SqlCommand cmd = new SqlCommand("SELECT dbo.Department.DeptName, dbo.AcademicAdviser.AAdviserId, dbo.AcademicAdviser.LName + ', ' + dbo.AcademicAdviser.FName + ' (' + dbo.AcademicAdviser.MName + ')' as [FullName], dbo.AcademicAdviser.Status, dbo.AcademicAdviser.DateRegistered FROM dbo.AcademicAdviser INNER JOIN dbo.Department ON dbo.AcademicAdviser.DeptId = dbo.Department.DeptId WHERE Status = '" + act + "' and " + column + " LIKE '%" + key + "%'"); ListViewAAdvisers.DataSource = Class2.getDataSet(cmd); ListViewAAdvisers.DataBind(); }