I'm Working in grid-view.
I have to Bind data from list to grid-view i have tried it , but it is getting Exception that "A field or property with the name 'UM_Employee_Number' was not found on the selected data source" could you please help me on this
.CS
protected void btnSrchBox_Click(object sender, EventArgs e)
{
string srchEmpID = txtSrchEmpID.Text;
string srchEmpName = txtSrchEmpName.Text;
// Users UserControllerObjct = new Users();
//List<users> UserControllerObjct = new List<users>();
var lstSrchEmp = new List<user>();
//lstSrchEmp = UserControllerObjct.SearchEmployeeDetails();
TCSRR.DMTController.Users UserControllerObjct = new TCSRR.DMTController.Users();
// TCSRR.DMTBusinessEntity.User lstSrchEntityObj = new TCSRR.DMTBusinessEntity.User();
lstSrchEmp = UserControllerObjct.SearchEmployeeDetails(srchEmpID, srchEmpName);
if (lstSrchEmp.Count > 0)
{
gridView1.DataSource = lstSrchEmp;
// gridView1.DataSource = UserControllerObjct.SearchEmployeeDetails(srchEmpID, srchEmpName);
gridView1.DataBind();
}
}
Controller
public List<user> SearchEmployeeDetails(string srchEmpID, string srchEmpName)
{
UserData UserModelObj = new UserData();
List<user> UserEntityObj = new List<user>();
// TCSRR.DMTModel.Users UserControllerObjct = new TCSRR.DMTController.Users();
// TCSRR.DMTBusinessEntity.User lstSrchEntityObj = new TCSRR.DMTBusinessEntity.User();
// UserData srchusers = new UserData();
// List<user> SrchLstUser = new List<user>();
// TCSRR.DMTBusinessEntity.User SrchLstUser = new TCSRR.DMTBusinessEntity.User();
try
{
UserEntityObj = UserModelObj.SearchEmployeeDetails(srchEmpID, srchEmpName);
//return (srchusers.SearchEmployeeDetails(srchEmpID, srchEmpName));
return UserEntityObj;
}
catch (Exception ex)
{
//SrchLstUser.Add(new User());
ex.CustomException("1", "User Details can't be retrived");
}
return null;
}
}
Model
public List<user> SearchEmployeeDetails(string srchEmpID, string srchEmpName)
{
DataSet ds;
User SrchUser;
List<user> SrchLst = new List<user>();
//TCSRR.DMTBusinessEntity.User SrchLst =new TCSRR.DMTBusinessEntity.User();
try
{
object[] arParms = new object[2];
arParms[0] = srchEmpID;
arParms[1] = srchEmpName;
ds = SqlHelper.ExecuteDataset(FileManager.GetSettingsValue("DBConnection"), "spmt_SearchEmployee", arParms);
if (ds != null)
{
// return ds;
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
SrchUser = new User();
SrchUser.EmployeeNo = ds.Tables[0].Rows[0]["UM_Employee_Number"].ToString();
SrchUser.FirstName = ds.Tables[0].Rows[i]["UM_FirstName"].ToString();
SrchLst.Add(SrchUser);
return SrchLst;
}
}
}
}
catch (Exception ex)
{
}
return null;
}
}
Please it is urgen