public DataTable Fetch_PATIENT_name(string pATIENT_SYS_ID)
{
//EXEC dbo.USP_GENERAL_MANAGEMENT @OPERATION_ID = 6, @PATIENT_SYS_ID = 4
_dtObj = new DataTable();
_param = new SqlParameter[] {
new SqlParameter("@OPERATION_ID", 6)
{
SqlDbType = SqlDbType.Int, Direction = ParameterDirection.Input
},
new SqlParameter("@PATIENT_SYS_ID", pATIENT_SYS_ID)
{
SqlDbType = SqlDbType.Int, Direction = ParameterDirection.Input
}
};
_dtObj = _dbObj.Select("USP_GENERAL_MANAGEMENT", _param);
var abc = _dbObj.ErrorList();
return(_dtObj);
}