i am searching for a way to create a grid (from some kind of jquery grid plugin didnt choose one yet)
anyway i want to call a webmethod and return a json serialized from a List of an object i created.
today i just use a regular grid view inside an iframe
but i want to eliminate that iframe and create those grids with ajax requests.
I've been following tutorials. I got a problem while attempting to try your sample,
Here is the sql syntax that i emulated from one of your tutorials
USE [arrestedpersonsdb]GO/****** Object: StoredProcedure [dbo].[stnencodedtodisplay]
Script Date: 08/10/2013 15:57:50 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- =============================================--
Author: <Author,,Name>-- Create date: <Create Date,,>--
Description: <Description,,>-- =============================================
CREATE PROCEDURE [dbo].[stnencodedtodisplay]
( @PageIndex INT = 1 ,@PageSize INT = 10 ,@RecordCount INT OUTPUT ,@id int ,
[Code] ....
If I use the first two parameter namely stnid and type it returns as expexted but when i try to add another parameter sample below:
USE [arrestedpersonsdb]GO
DECLARE @return_value int, @RecordCount int
EXEC @return_value = [dbo].[stnencodedtodisplay] @PageIndex = 1, @PageSize = 10, @RecordCount = @RecordCount OUTPUT, @id = 1599, @fname = 'ALDRIN', @lname = ''
SELECT @RecordCount as N'@RecordCount'
SELECT 'Return Value' = @return_value
GO
it doesn't return anything is it because the data being returned is a single row or this type of query doesn't allow multiple parameters...
var OrderInfo = {
"ProductID": "ProductIDValue",
"ProductName": "ProductName",
"Quantity": 1,
"Amount": 9999,
"SLQuantity": 9999,
"SLDate": "08/03/2010"
};
var DTO = { 'OrderInfo': OrderInfo };
$.ajax({
type: "POST",
contentType: "application/json; charset=utf-8",
url: "JasonHandler.ashx",
data: JSON.stringify(DTO),
dataType: "json"
});
I'm trying to retrieve posted JSON data on server side in an ASHX file via this code string strrequest = context.Request["OrderInfo"]; but it always return null. What Am I doing wrong?
I'm new to Jquery, JSON and MVC, and am trying to create a json object that contains AD info from an AD query. The ad query is working fine and returning data and I have 2 overloaded implementations of it.
#1 is a method from an older .net app that builds and returns a datatable that we bound to a grid view control
#2 was a modification of #1 that returns a System.Collections.Generic.List<> type. #2 returns data ok and i can display a table in the MVC view
however, I'd like to get the data results into a json object so i can bind it to a jqGrid object that has similar functionality to the old .Net server controls (Delete, Update, Sort) Here's the new method that's part of a C# static class:
[Code]....
Like I said...I'm new to this way of doing web development, so I'm not sure how to even approach getting this data into a json object.
I am working on ASP MVC 2 application. I have used the following jquery plugin & css
<link href="../../Content/ui.jqgrid.css" rel="stylesheet" type="text/css" />
I was trying to send a Batch request with O-data framework given below is the code sequence.
updateService = new Sys.Data.OpenDataServiceProxy("http://localhost/myservice.svc");
actionSequence = updateService.createActionSequence();
actionSequence.addUpdateAction(newWr, workRequest.__metadata.uri);
try {
actionSequence.execute(
function () {
alert("Success");
},
function (error) {
alert(error._message);
}
);
}
catch (e) {
}
but this is failing because on response in the end i am geting some extra sections such as undefined ..given below is the response that i am geting in the end u can find the last 3-4 lines and junk data. which is
undefined undefined HTTP/1.1
Host: localhost
Accept: application/json
Accept-Charset: utf-8
The RESPONSE DATA
**************************
--batch_5d5c-5276-934b
Content-Type: multipart/mixed;boundary=changeset_ef52-ebe1-2137
--changeset_ef52-ebe1-2137
Content-Type: application/http
Content-Transfer-Encoding: binary
MERGE http://localhost/myservice.svc/data('Document_dd879945-cdd8-4336-95d3-365c52c617bd') HTTP/1.1
Host: localhost
Accept: application/json
Accept-Charset: utf-8
Content-Type: application/json;charset=utf-8
{"__metadata":{"uri":"http://localhost/myservice.svc/data('Document_dd879945-cdd8-4336-95d3-365c52c617bd')","type":"Accelrys.Services.DataContracts.WorkRequest"},"VaultId":"Document_dd879945-cdd8-4336-95d3-365c52c617bd","WorkRequestId":"WR.fee0a427-0652-4493-a785-d4b81f26549c","Title":"TEst
WR from Arun PP - Modified By Arun","Project":null,"CreatedBy":"sqalab\vault.admin","VaultPath":"","CreatedOn":"Mar 27,2011","ModifiedOn":"Mar 27,2011","ModifiedBy":"sqalab\vault.admin","Status":"Not Started","NeededBy":"Dec 31,2000"}
--changeset_ef52-ebe1-2137
Content-Type: application/http
Content-Transfer-Encoding: binary
undefined undefined HTTP/1.1
Host: localhost
Accept: application/json
Accept-Charset: utf-8
--changeset_ef52-ebe1-2137--
--batch_5d5c-5276-934b--
how to save multile rows in grid view using jqery json
View 4 RepliesI am facing an error when requesting to WEBPageMethod using jquery and get 401 Unauthorized response and here is code for that
[code]....
i have few textbox on the form and when the user submit i want to capture the data and insert into db
here is what my code looks like
beforeSubmit: function(data)
{ // called just before the form is submitted
var item = $("[id$='item']");
var category = $("[id$='category']");
var record = $("[id$='record']");
[Code].....
I want to send single json object with nested arrays through jquery ajax method.
In Code
In jquery ajax i am passing LeaveRuleMaster a single json object which holds some properties (Leavetypeid, Leavename, Leavestatus and nested array LeaveRulespecific.
In vb.net code i can receive the value of properties(Leavetypeid,Leavename,Leavestatus)
but i am receiving the LeaveRuleSpecific as nothing.
Based on the following link i tried this [URL] .....
I need to display the data as pie chart,bar charts(2D,3D) here data is JSON data. any nice articles using jquery or java script free plugins ?
View 1 RepliesHow to create the JSON data...I want to display the data's from JSON and Display in the HTML format...
1) Images
2)Name
3)Phone Number etc
I am binding Gridview using json (first Gridview),which have some column with linkbutton. I want to bind other gridview(second Gridview) using json on click of Linkbutton inside first gridview . how to fire json on linkbutton click event ?
View 1 Repliesfor SEO purposes, instead of refreshing the page every click of a product, is it possible to click on the product and when the server comes back with the response, to change the URL of the page to reflect the new link to information currently on page?
point is to have ajax redraw the product details portion of the page but have SEO friendly url's displayed so if people want to bookmark the currently selected product, it will bookmark the right url instead of the generic one to access the products page..
For example... here's my entry point:
Products.aspx
product1product2product3 If I were to click product1, the request goes to the server with roducts.aspx?id=product1 but the url is still products.aspx on the response meaning that when people bookmark the product1 item, and they send the link to a friend, the friend always gets the generic product.aspx page.
I'm trying to get around this without refreshing the full page (postback).
While click next page, and while back page is error ... See images.
View 1 RepliesIf I use jQuery AJAX to call a specific ASP.NET page method how to have that method return a value back to the AJAX method that called it?
Update
My situation is I have an existing web application with many existing methods. I would like to be able to use jQuery to execute some of these methods and then update the UI with the results. My mandate is to stay away from ASP.NET AJAX and stick with jQuery. Management is concerned about continued development and support with ASP.NET AJAX from Microsoft. I agree with them.
I have the following code where the function codeaddress geocodes the text feild value and returns geocoded value , geocoded value is stored in variable example ,how will i return the variable v2 to the function call and post to asmx webservice.
[code]....
client code:
<script src="../Scripts/jquery-1.4.1.min.js" type="text/javascript"></script>
<script type="text/javascript" language="javascript">
$("#send").click(function () {
$.ajax({
url: "../JqueryAjax/JqueryAjaxServer.aspx",
type: 'get',
contentType: "application/json; charset=utf-8",
dataType: "json",
timeout: 30000,
data: "{}",
success: function (data, textStatus) {
alert("success");
},
error: function (XMLHttpRequest, textStatus, errorThrown) {
alert("error");
alert(textStatus);
alert(errorThrown.toString());
}
});
});
</script>
server code:
Response.ContentType ="application/json";
string json = "{"username":"test"}";// ,"content":"test"
Response.Write(json);
when i click the post request button the result is shown like this Invalid Json,the browser alert this.
We have an exisiting Web Service which receives SOAP requests and returns the data accordingly. However, we have a new project which requires the same information but the Android SDK doesn't support SOAP so we need to use JSON. As JSON is just a data container format, I need to write a new module to replace the SOAP WSDL which receives a querystring from the Android app and then processes the data and returns it in a JSON packet. The problem is that having never used JSON I'm unsure as to how I return the data to the app in JSON format. Does anyone have any examples I can look at in VB.Net or C#?
View 2 RepliesLots of people recommend to wrap the MVC JsonReturn result in a textarea to play nicely with jquery forms etc.
That part makes sense but how do I get the json object back in my client jquery code?
The client jquery plugin should look something like this:
// Doesn't work since data is "<textarea>{"error":true,"msg":"foo"}
I'm doing an jQuery AJAX POST call to a webmethod, which is working fine. If I'm passing data from the AJAX call, I normally get the data in the webmethod via webmethod parameters.
JavaScript Code:
$.ajax({"dataType": "json","contentType": "application/json","type": "POST","url": "Default.aspx/GetStuff","data": JSON.stringify({"a":"data1","b":2}),"success": function (msg) { console.log(msg.d);}});
C# Code:
[WebMethod]public static object GetStuff(string a, int b){ }
Is there any way I can get the data as a Dictionary or some other object, instead of having to put in individual parameters to the GetStuff() web method for each data param? It's a POST request so nothing is in Request.QueryString, and Request.Params/Request.Form doesn't contain it either.
As it is now I create a JavaScript object and then stringify it, put it in a hidden textbox and my code behind can read this string. I then use JSON.NET to parse the string which works fine. I now try to use ajax to post it to my web service but have some issues with how to send the string. I have tried many ways but gets the common errors like
Invalid JSON primitive: myString.
So I checked this out [URL] and it works with hard coded values but I want to use a variable.
JavaScsript to create the object:
for (var i = 0; i < results.rows.length; i++) {
var row = results.rows.item(i);
var customer = new Object();
customer.id = row['id']
customer.name = row['name']
var customerString = JSON.stringify(customer);
$.ajax({
type: "POST",
url: "synchronise.asmx/synchroniseCustomers",
data: "synchroniseCustomers: " + customerString,
contentType: "application/json; charset=utf-8",
dataType: "json",
error: function (xhr, status) {
alert("An error occurred: " + status);
},
success: function (msg) {
alert("success");
}
});
}
WebMethod:
public void synchroniseCustomers(string customerString)
{
JObject o = JObject.Parse(customerString);
string id = (string)o["id"];
string name = (string)o["name"];
If I use data: '{ FirstName: "Dave", LastName: "Ward" }'
in the example above it works but I wish to pass on a string instead.
I try lots. we can bind asp.net gridview many ways but datalist i not able to bind. How can I bind asp.net datalist using jquery/json and webservice.
View 1 RepliesI'm trying to save some content whenever a button/hyperlink is clicked using jquery.ajax (Using Asp.net 3.5). The logic is as follows:
Through .bind in jquery I bind my own method(MakeLog) to a button click or hyperlink click. The click events of button/hyperlink contain nothing, I need to use .bind for selective controls.Now we have a button whose click event will fire a method, say MakeLog.Code snippet for MakeLog is as follows:
var xhr = jQuery.ajax({
url: "/Logger.aspx",
data: { content: logContent }, [code]....
This works fine in IE but in Firefox this is not sending the data back as expected.I tried to identify the issue and came across the following: http://stackoverflow.com/questions/3522944/jquery-ajax-calls-async-false-vs-async-true .What I understand is that, whenver page is redirecting/reloading due to button click or hyperlink click the async call is not working properly.
Actually I am trying to learn jQuery Ajax calls to asp.Net webservices.
I have been trying to call the webmethod below:
[code]....
Do I need to serialize my object in some way before setting the 'data' attribute, so that I can call $.ajax() function?
