Hi Developers,
In my project i got this error .
There is 180729 coming from db. when i am try to bind in gridview using websevice i got the "The function evaluation was disabled because of an out of memory exception" error
my webservice code : .asmx.cs
public string GetClassWiseInventoryBasicDetails(string RequestData) { string lstrReturn = string.Empty; string consumerKey = string.Empty; Models.CP.Inventory.Tag.GetBasicDetailsRequest objRequest = new Models.CP.Inventory.Tag.GetBasicDetailsRequest(); try { RequestData = clsCommonCryptography.StringDecrypt(RequestData); clsErrorLog.WriteAppLogFiles(string.Format("Request :- {0}", RequestData), DateTime.Now, System.Reflection.MethodBase.GetCurrentMethod().Name, (this.GetType().Name + "/" + System.Reflection.MethodBase.GetCurrentMethod().Name), GetDeviceInfo()); string message = "Oops server down!"; using (TextReader sr = new StringReader(RequestData)) { var serializer = new System.Xml.Serialization.XmlSerializer(typeof(Models.CP.Inventory.Tag.GetBasicDetailsRequest)); objRequest = (Models.CP.Inventory.Tag.GetBasicDetailsRequest)serializer.Deserialize(sr); } var validationResult = DataAnnotation.ValidateEntity<Models.CP.Inventory.Tag.GetBasicDetailsRequest>(objRequest); if (Providers.DataMemberValidation.Validation.VerifyEntity(validationResult, ref message)) lstrReturn = mobjIMPS.GetClassWiseInventoryBasicDetails(objRequest); else lstrReturn = "<?xml version='1.0' encoding='utf-8' standalone='no'?><Response><STATUSCODE>1</STATUSCODE><STATUS>" + message + "</STATUS></Response>"; //clsErrorLog.WriteAppLogFiles(string.Format("Request:- {0}, Response :- {1}", RequestData, lstrReturn), DateTime.Now, this.GetType().Name, System.Reflection.MethodBase.GetCurrentMethod().Name, "", 1); lstrReturn = clsCommonCryptography.StringEncrypt(lstrReturn); return lstrReturn; } catch (Exception ex) { clsErrorLog.WriteErrLogFiles(string.Format("Request:- {0}, Response :- {1}, Error :- {2}", RequestData, lstrReturn, ex.Message), this.GetType().Name, System.Reflection.MethodBase.GetCurrentMethod().Name, "", 1, ex); clsErrorLog.WriteAppLogFiles(string.Format("Request:- {0}, Response :- {1}, Error :- {2}", RequestData, lstrReturn, ex.Message), DateTime.Now, this.GetType().Name, System.Reflection.MethodBase.GetCurrentMethod().Name, "", 1); lstrReturn = "<?xml version='1.0' encoding='utf-8' standalone='no'?><Response><STATUSCODE>1</STATUSCODE><STATUS>PLEASE TRY AGAIN</STATUS></Response>"; lstrReturn = clsCommonCryptography.StringEncrypt(lstrReturn); return lstrReturn; } finally { if (objRequest != null) objRequest = null; } }
webservice code : cls.cs
public string GetClassWiseInventoryBasicDetails(Models.CP.Inventory.Tag.GetBasicDetailsRequest objRequest) { string lstrReturn = ""; string lstrParam = ""; StringBuilder lstrXmlString = new StringBuilder(); try { string[] lstrInputArray = new string[] { "AGENTID|INT|" + objRequest.AgentId, "VEICLEID|VARCHAR|" + objRequest.VehicleId, "FLAG|INT|" + objRequest.Flag }; string[] lstrOutputArray = new string[] { "cv_1" }; lstrParam = string.Join(",", lstrInputArray); DataSet ldstDataset = mobjBusiness.Mth_withParamBankAdmin("ADM_GET_CLASSWISEINVENTORYDETAILS", lstrInputArray, lstrOutputArray); if (ldstDataset != null) { if (ldstDataset.Tables.Count > 0) { if (ldstDataset.Tables[0].Rows.Count > 0) { lstrXmlString.Append("<?xml version='1.0' encoding='utf-8' standalone='no'?><Response><STATUSCODE>0</STATUSCODE><STATUS>SUCCESS</STATUS>"); if (ldstDataset.Tables[0].Rows.Count > 0) { for (int i = 0; i <= ldstDataset.Tables[0].Rows.Count - 1; i++) { lstrXmlString.Append("<GetBasicDetails>"); foreach (DataColumn column in ldstDataset.Tables[0].Columns) lstrXmlString.AppendFormat("<{0}>{1}</{0}>", column.ColumnName, ldstDataset.Tables[0].Rows[i][column.ColumnName]); lstrXmlString.Append("</GetBasicDetails>"); } } lstrXmlString.Append("</Response>"); lstrReturn = lstrXmlString.ToString(); } else lstrReturn = "<?xml version='1.0' encoding='utf-8' standalone='no'?><Response><STATUSCODE>1</STATUSCODE><STATUS>Data Not Available</STATUS></Response>"; } else lstrReturn = "<?xml version='1.0' encoding='utf-8' standalone='no'?><Response><STATUSCODE>1</STATUSCODE><STATUS>Please try again</STATUS></Response>"; } else lstrReturn = "<?xml version='1.0' encoding='utf-8' standalone='no'?><Response><STATUSCODE>1</STATUSCODE><STATUS>Please try again</STATUS></Response>"; } catch (Exception ex) { clsErrorLog.WriteErrLogFiles(string.Format("Request:- {0}, Response :- {1}, Error :- {2}", lstrParam, lstrReturn, ex.Message), this.GetType().Name, System.Reflection.MethodBase.GetCurrentMethod().Name, "", 1, ex); clsErrorLog.WriteAppLogFiles(string.Format("Request:- {0}, Response :- {1}, Error :- {2}", lstrParam, lstrReturn, ex.Message), DateTime.Now, this.GetType().Name, System.Reflection.MethodBase.GetCurrentMethod().Name, "", 1); lstrReturn = "<?xml version='1.0' encoding='utf-8' standalone='no'?><Response><STATUSCODE>1</STATUSCODE><STATUS>PLEASE TRY AGAIN</STATUS></Response>"; } finally { lstrXmlString = null; } string test = ""; return lstrReturn; }
If there is any possible to fix this error , kindly suggest me.
Thanks and Regards,
Paul.S