I have Master Details JQGrid.My details JQGrid have Edit,Add,Del options. my problem is when I click on submit button to add data or edit data I faced with this error: "500 Internal Server Error" and it's response is
[Code]....
I am new to jqGrid and I have found it difficult to follow the documentation jqGrid Documentation / I cannot figure out how to call a WebMethod when setting up the JQGrid. I have been successful in making an Ajax call to get the data and then setting up the JQGrid with local data. I think its an extra step in the setup process and that I should be able to provide the path to the webmethod using the url property. The editurl property is the same way. I am never actually receiving the post to the server. Attempted JQGrid Setup
function GetData()
{
$('#list').jqGrid({
type: "POST",
url: "Default.aspx/GetUsersJSON",
datatype: "json",
height: 250,
colName: ['Username', 'Email'],
colModel: [
...
}).jqGrid(
'navGrid',
'#pager',
{
edit: true,
add: true,
del: true
});
}
WebMethod
[WebMethod]
public static string GetUsersJSON()
{
var users = new List();
using(UserAdministrationSandboxDataContext uasd = new UserAdministrationSandboxDataContext())
{
users = uasd.GetUserList();
}
JavaScriptSerializer serializer = new JavaScriptSerializer();
return serializer.Serialize(users);
}
Current Code I got it working correctly now, but I still have one final question. Why did I have to set the 'repeatitems: false' in order to display the content? Some of the caveats to get this to work include the different ways to setup the ajax request. (Ajax: type) is (jqgrid : mtype) (Ajax: contentType) is (jqgrid : ajaxGridOptions: { contentType: })
And finally understanding the documentation from the documentation on how to setup the JSONReader.
function GetUserDataFromServer()
{
$('#list').jqGrid({
url: "Default.aspx/GetUsersJSON",
mtype: 'POST',
ajaxGridOptions: { contentType: "application/json" },
datatype: "json",
serializeGridData: function (postData)
{
return JSON.stringify(postData);
},
jsonReader: {
root: function (obj) { return obj.d; },
page: function (obj) { return 1; },
total: function (obj) { return 1; },
records: function (obj) { return obj.d.length; },
id:'0',
cell:'',
repeatitems: false
},
datatype: "json",
height: 250,
colName: ['Username', 'Email'],
colModel: [
{
name: 'Username',
index: 'Username',
width: 100,
editable: true
},
{
name: 'Email',
index: 'Email',
width: 220,
editable: true
},
{
name: 'IsLockedOut',
index: 'IsLockedOut',
width: 100,
editable: true,
edittype: 'checkbox'
}
],
caption: "Users"
})
}
Web Method
[WebMethod]
[ScriptMethod(ResponseFormat = ResponseFormat.Json)]
public static List GetUsersJSON()
{
using (UserAdministrationSandboxDataContext uasd = new UserAdministrationSandboxDataContext())
{
return uasd.GetUserList();
}
}
One JSON Object from the List
{"__type":"UserAdministrationSandbox.UserData","PKID":"00000000-0000-0000-0000-000000000001","Username":"TestUser","ApplicationName":"Test","Email":"TestUser@test.com","Comment":"TestUser","Password":"D41D8CD98F00B204E9800998ECF8427E","PasswordQuestion":"Is this a blank Password?","PasswordAnswer":null,"IsApproved":true,"LastActivityDate":"/Date(1298869200000)/","LastLoginDate":"/Date(1298869200000)/","LastPasswordChangedDate":"/Date(1298869200000)/","CreationDate":"/Date(1298869200000)/","IsOnLine":false,"IsLockedOut":false,"LastLockedOutDate":"/Date(1298869200000)/","FailedPasswordAttemptCount":0,"FailedPasswordAttemptWindowStart":null,"FailedPasswordAnswerAttemptCount":null,"FailedPasswordAnswerAttemptWindowStart":null}
My WCF service has a method that retruns json string now i need to bind this json string to my jqgrid by consuming the WCF service. Has any one done this
View 2 RepliesIn a web page, I call a web service (located in the sub folder WebServices) with ajax asp.netHere my aspx code:
[Code]....
My web site uses integrated windows authentication and all works fine.However, my web service doesn't need authentication and in order to not have 2 requests (because of http code 401), I've allowed anonymous access on the WebServices folder. Doing this, I get the folowing error message when I call a web method: "Invalid web service call, missing value for parameter: user"When I look at my body request with Web Development Helper, I can see {"user":"toto"}. So, I don't understand why it's not working.Another weird thing: when I run Fiddler2 instead of Web Development Helper, every thing works fine. I turn off Fiddler2, and it doesn't work any more.
I was doing the MusicStore Tutorial, I finished it and now I am trying to improve the tables with the jqgrid, that seems to be great. I found the
Phil Haack blog's post about how to use it.
[URKL]
But I couldn't do a mix of this, I tried to make the storemanager page with the grid of jqgrid instead of the simple table, but doesn't work. This is what I did:
[Code]....
And in the aspx I have the following js code:
[Code]....
So all the javascript loads fine except for the jqGrid. It's giving me this error: jQuery("#resultsGrid").jqGrid is not a function Which I'm assuming means it can't find the .js source. However, it is in my main Js folder along with all the other goodies, and everything else seems to work fine. Plus, none of the other javascript needs to reference the grid stuff as a source, so if I reference it in the script tag, it will break everything else right?
<script>
$(document).ready(function () {
$("#prepaymentTable").bubble({ width: 400, title: 'Prepayment' });
$("#exposureTable").bubble({ width: 400, title: 'Exposure' });
$('#calculateButton').live('click', function () {
alert('Calculating Prepayment Analysis...');
});
$('#exposureButton').live('click', function () {
alert('Calculating Exposure Analysis...');
});
jQuery("#resultsGrid").jqGrid({
datatype: "local",
height: 250,
colNames: ['Inv No', 'Date', 'Client', 'Amount', 'Tax', 'Total', 'Notes'],
colModel: [
{ name: 'id', index: 'id', width: 60, sorttype: "int" },
{ name: 'invdate', index: 'invdate', width: 90, sorttype: "date" },
{ name: 'name', index: 'name', width: 100 },
{ name: 'amount', index: 'amount', width: 80, align: "right", sorttype: "float" },
{ name: 'tax', index: 'tax', width: 80, align: "right", sorttype: "float" },
{ name: 'total', index: 'total', width: 80, align: "right", sorttype: "float" },
{ name: 'note', index: 'note', width: 150, sortable: false }
], multiselect: true,
caption: "Manipulating Array Data"
});...........................................
I have created an WCF data service in a new asp.net web application and i want to call this web service from another web application using jquery, but it always returns null.
My jquery call looks like this:
[code]....
Note that [URL] works in the browser but since the jquery call is from localhost:3410 i assume its a problem with cross domain.
I have been reading that i should use jsonp for this, but i have a hard time figuring it out.
I'm trying to call a web service and the passed string may have punctuation, depending on what the user types in.I currently have an HTML textbox and a jQuery call to the .NET web service. I definitely think the string with punctuation fails because jQuery will send the string wrong, so I tried a few different javascript encoding functions I could find. I was never able to encode it successfully and decode it in .NET, saving the string with punctuation.
Basically I have a textbox that a user can update their status in. If the user wants to use punctuation, I'd like them to be able to. How can I accomplish this with jQuery and .NET?
I have this Aja.svc in my root folder
[ServiceContract(Namespace = "")]
[AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Allowed)]
public class Aja
{
[WebGet]
[OperationContract]
public string Hi()
{
return "hi world!";
}
}
and I'm trying to do this: $.get('Aja.svc?method=Hi', function(d) { alert(d.d); }); In firebug I see that the result is HTTP Error 404.17 - Not Found The requested content appears to be script and will not be served by the static file handler. I use .net 3.5, jquery 1.4.4
I am trying to use the below code to call a wcf service method for Autocomplete functionality in a TextBox. I have written the following query:
$(document).ready(function () {
$("#<%= txtCompany.ClientID %>").autocomplete [URL], {
dataType: 'json',
parse: function (data) {
var items = data.d;
var parsed = [];
for (var i = 0; i < items.length; i++)
parsed[i] = {
data: [items[i]],
value: items[i],
result: [items[i]]
};
return parsed;
}
});
});
The same query works if I pass a Java Script array variable instead of the wcf service method. The wcf service method contract is:
[OperationContract]
[WebInvoke(Method = "GET", BodyStyle = WebMessageBodyStyle.WrappedRequest, ResponseFormat = WebMessageFormat.Json)]
string[] GetTestCompanyList(string prefixText, int count);
I created a number of standard WCF Services (Service Contract and Host (svc) are in separate assemblies). I fired up a Web Site in IIS to host the Services (i.e., address is [URL]). Then in my Web Site project I added the reference. I am able to call the services normally. I am needed to call some of the services client side. Not sure if I should be looking at articles calling WCF services through AJAX, JQuery, or JSON enabled WCF Services. Some of the changes I made was adding the following to the Operation Contract:
[OperationContract]
[WebInvoke(Method = "POST", UriTemplate = "SetFoo")]
void SetFoo(string Id);
Then this above the implementation of the interface:
[AspNetCompatibilityRequirements(RequirementsMode =
AspNetCompatibilityRequirementsMode.Allowed)]
Then in the service webconfig I have this (parens are angle brackets):
<serviceHostingEnvironment aspNetCompatibilityEnabled="true">
<baseAddressPrefixFilters>
<add prefix=[URL]>>
</baseAddressPrefixFilters>
</serviceHostingEnvironment>
<serviceHostingEnvironment multipleSiteBindingsEnabled="false" />
Then in the client side I attempted this:
<asp:ScriptManagerProxy ID="ScriptManagerProxy1" runat="server">
<compositeScript>
<Scripts>
<asp:ScriptReference
Path=[URL]/>
</Scripts>
</CompositeScript>
</asp:ScriptManagerProxy>
I am attempting to call the service like this in javascript: wcfservices.SetFoo(string Id); Nothing is working. If it is idea or a better solution to call JSON enable, JQuery, etc.... I am willing to make any changes.
I'm fairly new to ASP.Net MVC 2 and understand the MVC pattern in itself. But my question is what's the best way to populate dropdownlists in the UI sticking to the MVC pattern. Should I be going through the controller? Every article I've seen to do this shows how to do it using javascript and jquery. I have a test application that I'm re-writing in MVC2 I have my dropdowns working with jquery basically calling a WCF Data Service that returns JSON which populates the dropdowns. Seems to me though that this is bypassing the controller and going straight to the model therefore strictly violating the MVC pattern. Or am I missing something obvious here. You thoughts or best practices would be greatly welcome here.
View 3 RepliesI have this method in asp.net ajax enabled mvc service
[OperationContract]
public TestRun GetTestSuite(string testSuitName) {
TestRun testRun =
AdapterFactory.CreateTestRunAdapter().GetByTestSuiteName("testSuit");
return testRun;
}
Where TestRun is Created using entities framework against TestRun table. I am using following ajax method
function getTestSuite() {
$.ajax({
type: "POST",
url: "Services/TestRunService.svc/GetTestSuite",
data: '{"testSuitName" : "' + testSuiteName + '"}',
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (response) {
},
//If the call fails
error: function (xhr, textStatus, errorThrown) {
alert(errorThrown);
}
})
}
I get undefined error. If I return string from service it works. Do I need to change dataType: "json" to something else?
I have a web service with the following contract:
POST /Service/service.asmx HTTP/1.1
Host: xxx.xxx.xxx
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "xxx.xxx.xxx/Service/Method"
<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Header>
<Request xmlns="xxx.xxx.xxx/Service/">
<transactiontype>string</transactiontype>
<username>string</username>
<password>string</password>
</Request>
</soap:Header>
<soap:Body>
<Method xmlns="xxx.xxx.xxx/Service/">
<xml>xml</xml>
</Method>
</soap:Body>
</soap:Envelope>
And I am trying to call the service using jquery. This is my code:
$.ajax({
url: serverUrl + 'Method',
type: "POST",
dataType: "xml",
data: { xml: "xml" },
beforeSend: function (req) {
req.setRequestHeader('Header', '<Request xmlns="xxx.xxx.xxx/Service/">'
+'<transactiontype>4</transactiontype>'
+'<agencyName>name</agencyName>'
+'<username>user</username>'
+'<password>pass</password>'
+'</Request>');
},
success: function (data) {
alert(data.text);
},
error: function (request, status, errorThrown) {
alert(status);
}
});
However, the header content is not passed to the web service? How would I go about passing the header credentials to my web service call?
Iīm using jQuery to make the ajax calls to web services. Iīm not using json, I want the information in XML. If I donīt pass parameters and I make the WS parameter less it works but if I want to pass a value as parameter (I tried int and string) it doesnīt work. Here is my code:
jQuery: [Code]....
The web service
[Code]....
The error that I get from firebug is an exception System.InvalidOperationException and it says that the parameter region_id is missing.It canīt be very difficult because it works without parameters but all the information I find in internet
When I was reading the blog Using jQuery to Consume ASP.NET JSON Web Services
I have seen this argument:
"By using jQuery to call the web service directly, we've eliminated over 100 KB of JavaScript and three extra HTTP requests. "
Why does the ASP.NET AJAX call to a .NET Web-Service needs 3 extra HTTP requests? What are those requests? (I wonder how jQuery manages the call with lesser HTTP requests in this case).
I have a simple web service that isn't working with a standard jQuery call. The code is below. The jQuery will execute and succeed, but on debugging, the service argument is always null. I've had it separated as 4 string params in a json string and that didn't work either. I must be missing something on the config side, but I can tell what it is.
[Code]....
I want to call .asmx service from jquery
.asmx service will return multiple data from database.
I need to get those data to jquery on client side
and then i need to put each data into their respective textfield on the client side
how to use jqgrid in .net , C#
View 3 RepliesI am using JQuery & JSON (POST) to call webmethod. However I can call only webmethod located at aspx file but not in asmx file Below are sample codes
CustomValidate.asmx
Imports System.Web.Services
Imports System.Web.Services.Protocols
Imports System.ComponentModel
Public Class CustomValidate
Inherits System.Web.Services.WebService
'ACCESS VIA JSON
<System.Web.Services.WebMethod()> _
Public Shared Function AJAX_Test(ByVal date1) As Boolean...
Return True
End Function
End Class
Javascript: JQuery JSON
function isDates(source, arguments) {
var isValidDate;
$.ajax({
type: "POST",
contentType: "application/json; charset=utf-8",
url: "CustomValidate.asmx/AJAX_Test",
data: '{date1: "' + arguments.Value + '"}',
dataType: "json",
async: false,
success: function(result) {
isValidDate = result;
},
error: function(httpRequest, textStatus, errorThrown) {
alert("status=" + textStatus + ",error=" + errorThrown);
}
});
arguments.IsValid = isValidDate;
}
It always return javascript undefined error. But if I put the AJAX_Test webmethod in aspx page and replace the url: "CustomValidate.asmx/AJAX_Test" to "mypage.aspx/AJAX_Test". It works fine.
I am new to using Jqgrid and jquery.I am not able to bind my json data which I retrive from the webmethod onto the jqgrid.I have also used firebug to cross verify and i am receiving data from it. Some help regarding this will be great. I would aslo like to know if any other references needs to be added.
[WebMethod]
public static string GetData()
Custome Customer Ctwo = new Customer();
Cone.CustomerID = "100";
Cone.CustomerName = "abc";
[code]...
I downloaded the samples for jqGid and they are all *.js files like the one below.
[Code]....
I know this should be put around a <script> tag inside my .aspx file but what should my markup look like. I assume that "#grid1" is wraped within a html <table> but what would the pager: '#pgrid3' be? jQuery will do the replacement on the client side here.
full example(visual studio project) of using the jqgrid under asp.net web form that contain paging and sorting
View 6 RepliesI have a jqgrid and I want to connect to database in c# (Webforms) and I write below code,but it doesn t show any data in my jqgrid
would you please check my code and tell me what should I do?
<!------Gridpage.aspx-----------!>
[Code]....
i put jqgrid in usercontrol and i load this dynamically.But can not show jqgrid.
how to load jqgrid i usercontrol.