public override void DataBind() { string StrSql = "Select a.ProjectsCode, a.ProjectsName, b.ActivityCode, b.ActivityName, b.SDate , b.EDate, '' As DeptName, b.Status, b.Df, IsNull(b.ApproveFlag, 0) ApproveFlag, " + " b.CostsType, IsNull(b.TotalAmount, 0) TotalAmount, IsNull((Cast(b.Term As nVarChar) + '/' + Cast(b.YearB As nVarChar)), '') Term, 0 As ConnectInd, 0 As ConnectEva " + " From Projects a, Activity b " + " Where a.ProjectsCode = b.ProjectsCode And b.DelFlag = 0 " + " And a.StudyYear = '" + ddlYearB.SelectedValue + "' And b.SchoolID = '" + CurrentUser.SchoolID + "' "; DataView dv = Conn.Select(string.Format(StrSql + " Order By b.CreateDate Desc ")); for (int j = 0; j < dv.Count; j++) { dv[j]["DeptName"] = btc.getAcDeptName(dv[j]["ActivityCode"].ToString()); dv[j]["ConnectInd"] = btc.getAcIndicators2(dv[j]["ActivityCode"].ToString()); dv[j]["ConnectEva"] = btc.getAcEvaluation(dv[j]["ActivityCode"].ToString()); } GridView1.DataSource = dv; lblSearchTotal.InnerText = dv.Count.ToString(); GridView1.DataBind(); }