public static List <DepartmentInfo> ShowRecord() { DBCommunicator db = new DBCommunicator(); DataTable dt = db.ExecuteProcedureSelect("spPageDepartmentLoad"); List <DepartmentInfo> lst = new List <DepartmentInfo>(); foreach (DataRow row in dt.Rows) { DepartmentInfo d = new DepartmentInfo(); d.ID = row[0].ToString(); d.Title = row["Title"].ToString(); d.Abbreviation = row["Abbreviation"].ToString(); d.FarsiTitle = row["FarsiTitle"].ToString(); d.Edit = true; d.Delete = true; lst.Add(d); } return(lst); }
private void FillGrid() { GridView1.DataSource = db.ExecuteProcedureSelect("spPageAcademicYearLoad"); GridView1.DataBind(); }