skillilea
asked on
Web timeout: Need to understand what the page is waiting for and if I can stop it.
Running Win Server.
Sql: 2012
My Ajax call is called this way:
param ={....all the fields};
My web service is called this way:
The Stored procedure runs between 7-20seconds but has no return to the page.
How can I get the page[POST] to not wait for it's return. (Sorry if that's a dumb question but, I want the AJAX to fire off the update and not care about the return).
tnx in advance
Sql: 2012
My Ajax call is called this way:
param ={....all the fields};
$.ajax({
type: 'POST',
url: 'HandleSettingFieldCRUD',
dataType: 'json',
contentType: 'application/json; charset=utf-8',
data: param
});
My web service is called this way:
[WebMethod]
[ScriptMethod(ResponseFormat = ResponseFormat.Json)]
public bool HandleSettingFieldCRUD(string UserGUID, int LangID, int RegionID, string EGUID, string UpdateValue)
{
InnoFinanceDataContext db = new InnoFinanceDataContext();
db.ps_0XW_HandleSettingFieldCRUD(UserGUID, LangID, RegionID, EGUID,UpdateValue);
return true;
}
The Stored procedure runs between 7-20seconds but has no return to the page.
How can I get the page[POST] to not wait for it's return. (Sorry if that's a dumb question but, I want the AJAX to fire off the update and not care about the return).
tnx in advance
ASKER
In the code above I get a "SQL timeout error". From what I understand the AJAX should not be looking for any response.
I think then the page is timing out but...that makes no sense.
Any ideas?
tnx sk
I think then the page is timing out but...that makes no sense.
Any ideas?
tnx sk
Where are you seeing the error?
ASKER
A timeout error happens (SQL timeout) on my web service and visual studio pops open the linq call behind the WS.
does that help?
does that help?
ASKER
From the designer...it fails on something like this.
[global::System.Data.Linq. Mapping.Fu nctionAttr ibute(Name ="dbo.ps_S NP_HandleS napshotCRU D")]
public int ps_SNP_HandleSnapshotCRUD( [global::S ystem.Data .Linq.Mapp ing.Parame terAttribu te(DbType= "VarChar(5 0)")] string userGUID, [global::System.Data.Linq. Mapping.Pa rameterAtt ribute(DbT ype="Int") ] System.Nullable<int> langID, [global::System.Data.Linq. Mapping.Pa rameterAtt ribute(DbT ype="BigIn t")] System.Nullable<long> snapshotID, [global::System.Data.Linq. Mapping.Pa rameterAtt ribute(DbT ype="NVarC har(200)") ] string snapshotName, [global::System.Data.Linq. Mapping.Pa rameterAtt ribute(DbT ype="Int") ] System.Nullable<int> typeID, [global::System.Data.Linq. Mapping.Pa rameterAtt ribute(DbT ype="Int") ] System.Nullable<int> dataTag)
{
IExecuteResult result = this.ExecuteMethodCall(thi s, ((MethodInfo)(MethodInfo.G etCurrentM ethod())), userGUID, langID, snapshotID, snapshotName, typeID, dataTag);
return ((int)(result.ReturnValue) );
}
[global::System.Data.Linq.
public int ps_SNP_HandleSnapshotCRUD(
{
IExecuteResult result = this.ExecuteMethodCall(thi
return ((int)(result.ReturnValue)
}
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
So I make it void instead of bool (which I am doing nothing with anyway)...correct?
ASKER
Thanks for the help