public List <LeaveType> getLeaveType(string cleaveType) { List <LeaveType> leaveTypeList = new List <LeaveType>(); string sql = "SELECT * FROM hr_tm_LeaveType WHERE cCode='" + cleaveType + "'"; DataSet ds = db.Query(sql); if (ds != null) { foreach (DataRow dr in ds.Tables[0].Rows) { LeaveType leaveType = new LeaveType(); PropertyInfo[] propertys = leaveType.GetType().GetProperties(); int i = 0; foreach (PropertyInfo prop in propertys) { string filename = ds.Tables[0].Columns[i].ColumnName; if (prop.Name.ToLower().Equals(filename.ToLower())) { var x = dr[filename] == null ? "" : dr[filename].ToString(); prop.SetValue(leaveType, x, null); } i++; } leaveTypeList.Add(leaveType); } } return(leaveTypeList); }