MVC :: Filling JqGrid With JSON String From ViewData In MVC3?

Jan 12, 2011

We are trying to fill JqGrid in ASP.NET MVC3 application where datatype is set to 'jsonstring' and in it's action controller, we set the json data string in ViewData and retrieve the same in javascript function where we used it to fill the Jqgrid.

// Action code

[Code]....

// Javascript code to fill Jqgrid
[Code]....

[Code]....

There is an error while filling grid and when i alert the data it shows " in place of " in data, as below.

{{"total":2,"page":1,"records":2,"rows":[{"RequestID":"1","cell":["CPU","DELL OptiPlex 745","DELL","OptiPlex 745","5"]},{"RequestID":"2","cell":["CPU","TOSHIBA Tablet Portege 3500","TOSHIBA","Tablet Portege 3500","10"]}]}

[data displays fine on this post :) ]

The decodeURI function do not work on strData and it always show " in place of " in the data. We do not want to replace the " with " in a loop as it slow the page with large data.

View 2 Replies


ADVERTISEMENT

C# - ViewData Set In An ActionFilter Is Coming Out Null On Master Page MVC3?

Feb 15, 2011

My Original Issue here:Help! I've got repository access in my MVC master page! Refactor time!What originated as a re factoring job to improve performance has revealed new issues. If I should keep this in my original question - feel free to delete this one, and rename the old one to something more relevant. I'm using an ActionFilter applied to a base controller to load some user-customized settings. My issue is that I save these settings in the filterContext.Controller.ViewData object but its coming through as null on my master page. Here is the relevant code:

Action Filter
[AttributeUsage(AttributeTargets.Class, AllowMultiple = false)]
public class StoreSettingsActionFilter : ActionFilterAttribute

[code]...

View 1 Replies View Related

Jqgrid Using Json Datatype?

Jul 23, 2010

i am jqgrid which is binded dynamically using json datatype.my problem is with pageing.

I wrote the script for jqgrid in AddCategory.aspx and redirected this page to AddCategoryGrid.aspx where i wrote the code for binding jqGrid data.

It is displaying all records in one page but not allowing the pagging.

[code]....

View 1 Replies View Related

Json - JqGrid Doesn't Work In MVC2?

Apr 11, 2010

I have a project in ASP.NET MVC1 using VB.NET controlers and JqGrid. it works fine under MVC1. After migrating the project to ASP.NET MVC2, the grid is no longer populated. It seems that there is some new restrictions on returned Jsonresult in MVC2. How to solve this in VB.NET. Controler function populating the jqgrid is something like this :

Function GetGridRecordset(ByVal qry As String) As JsonResult
Dim result = New JsonResult()
...
...
Return result
End Function

View 3 Replies View Related

MVC :: JSON Object - Grid Is Not Filling Properly

Feb 25, 2011

I've created a simple (or what I thought was simple!) search form using Razor, MVC3 and the webgrid from the web helpers. I enabled paging, used a great article I found here to get that working... or so I thought. Basically what happens is that when I click the page buttons at the bottom of the grid it does something that I didn't expect, and creates a JSON object, then the browser prompts me to try and save it, and not as I expected to refill the grid. I can't see what I'm doing wrong, and before I break my monitor by throwing it onto the railway line!

[Code]....

My jQuery code

[Code]....

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using MvcApplication1.Models;
using System.Configuration;
using System.Web.Helpers;
namespace MvcApplication1.Controllers
{
public class SearchController : Controller
{
//
// GET: /Search/
Entities t = new Entities(ConfigurationManager.ConnectionStrings["Entities"].ConnectionString);
public ActionResult Details(int id)
{
Tender_Question q = (from x in t.Tender_Questions where x.Unique_ID_number == id select x).SingleOrDefault();
Customer c = (from cu in t.Customers where cu.CustomersID == q.Company select cu).SingleOrDefault();
ViewBag.Customers = c.CompanyName;
Panel_type pan = (from pa in t.Panel_types where pa.ID == q.Panel_type select pa).SingleOrDefault();
ViewBag.Panel = pan.Panel_type1;
return View(q);
}
[HttpGet]
public ActionResult Edit(int id)
{
Tender_Question q = (from x in t.Tender_Questions where x.Unique_ID_number == id select x).SingleOrDefault();
List<Customer> c = (from cu in t.Customers select cu).ToList();
ViewBag.Customers = c;
return View(q);
}
[HttpPost]
public ActionResult Edit(Tender_Question model)
{
if (ModelState.IsValid)
{
Tender_Question q = (from x in t.Tender_Questions where x.Unique_ID_number == model.Unique_ID_number select x).SingleOrDefault();
q.Answer = model.Answer;
q.Company = model.Company;
q.Customer = model.Customer;
q.Date = model.Date;
q.Page_Question_Ref = model.Page_Question_Ref;
q.Panel_type = model.Panel_type;
q.Question = model.Question;
q.Type_of_tender = model.Type_of_tender;
//add update code
t.SaveChanges();
return RedirectToAction("Index");
}
else
{
return View(model);
}
}
[HttpGet]
public ActionResult Search(int? page)
{
if (page.HasValue)
{
return RedirectToAction("EfficientPaging", new { page = page });
}
else
{
return View();
}
}
[HttpPost]
public ActionResult Search(int? page, FormCollection collection)
{
TempData.Clear();
IEnumerable<Tender_Question> q = getSearch(collection);
TempData.Add("Results", q);
return View(q);
}
private IEnumerable<Tender_Question> getSearch(FormCollection collection)
{
string question;
string answer;
IEnumerable<Tender_Question> q = t.Tender_Questions;
question = collection["Question"];
answer = collection["Answer"];
if (!string.IsNullOrEmpty(question))
{
if (question.EndsWith(","))
{
question = question.Substring(0, question.Length - 1);
} if (question.Length > 0)
{
if (question.Contains(","))
{
string[] questioned = question.Split(',');
foreach (string s in questioned)
{
q = q.Where(m => m.Question.Contains(s));
}
}
else
{
q = q.Where(m => m.Question.Contains(question));
}
}
}
if (!string.IsNullOrEmpty(answer))
{
if (answer.EndsWith(","))
{
answer = answer.Substring(0, answer.Length - 1);
}
if (answer.Length > 0)
{
if (answer.Contains(","))
{
string[] answered = answer.Split(',');
foreach (string s in answered)
{
q = q.Where(m => m.Answer.Contains(s));
}
}
else
{
q = q.Where(m => m.Answer.Contains(answer));
}
}
}
return q;
}
[HttpGet]
public ActionResult EfficientPaging(int? page)
{
IEnumerable<Tender_Question> q = (IEnumerable<Tender_Question>)TempData["Results"];
int skip = page.HasValue ? page.Value - 1 : 0;
q = q.OrderBy(o => o.Unique_ID_number).Skip(skip * 10).Take(10).ToList();
var grid = new WebGrid(q);
var column = new WebGridColumn();
column.CanSort = false;
column.ColumnName = "Unique_ID_number";
column.Header = "Edit";
column.Format = (item) =>
{
return new HtmlString("<a href="/Home/Edit/" + column.ColumnName + "">Edit</a> ");
};
var detcolumn = new WebGridColumn();
detcolumn.CanSort = false;
detcolumn.ColumnName = "Unique_ID_number";
detcolumn.Header = "Details";
detcolumn.Format = (item) =>
{
return new HtmlString("<a href="/Home/Details/" + column.ColumnName + "">Details</a> ");
};
var htmlString = grid.GetHtml(htmlAttributes: new { id = "DataTable" }, columns: grid.Columns(
column, detcolumn,
grid.Column("Question"),
grid.Column("Answer"),
grid.Column("Company"),
grid.Column(columnName: "Type_of_tender", header: "Type of Tender"),
grid.Column(columnName: "Panel_type", header: "Panel type"),
grid.Column(columnName: "Page_Question_Ref", header: "Page Question Ref"),
grid.Column("Date")
));
return Json(new
{
Data = htmlString.ToHtmlString(),
Count =q.Count() / 10
}, JsonRequestBehavior.AllowGet);
}
}
}

View 4 Replies View Related

MVC :: Accessing ViewData In JSON Callback?

Mar 11, 2011

How can I access ViewData from JSON callback. The following is my code:

public ActionResult DynamicGridData(string sidx, string sord, int page, int rows)
{
Fast.IMS.Search.Search mySearch = new Fast.IMS.Search.Search(session["strText"]);
myResults = mySearch.ExecuteSearch();

[Code]....

View 2 Replies View Related

C# - Object Unidentify When Using Jqgrid.jqGridExport() - How To Use It For Exporting The Grid In Json

Mar 3, 2011

This is the javascript code i tried to export my grid data in json. it throws an exception and i can't figure out why. when i downloaded the jqgrid i checked the import/export module. I want to insert the json in a hidden field in order to get the data on the server side for validating and saving.

$('#proveObjekt2').val(JSON.stringify($("#rowed5").jqGridExport("jsonstring")));
...
<asp:HiddenField ID="proveObjekt2" runat="server" />

View 1 Replies View Related

How To Convert JSON String To JSON Object Using JavaScript

Jan 21, 2011

I use the JavaScriptSerializer class of ASP.net to serialize my object and return it to the client side. How can I deserialize the string using JavaScript?

View 4 Replies View Related

C# - Converting Json String Into Json On Client Side?

Apr 3, 2011

In my javascript code I am getting json string from cs file

var tmpString="<%=resultset2%>";

In cs I am concatenating strings to build json string. Here is an issue the json string is returned as a string and it has " with it.

"[{id:'1',name:'Aik'},{id:'2',name:'Aik or Aik'}]"

Because of " in beginning and end javascript code treat it as a string.

View 2 Replies View Related

MVC3 - ActionResult Rendering DotNetOpenAuth WebResponse As String?

Nov 12, 2010

I've just updated my MVC2 project to run MVC3 (RC). Everything is working as expected except for one problem.

I'm running DotNetOpenAuth, but when I go to authenticate, my page renders the string

DotNetOpenAuth.Messaging.OutgoingWebResponseActionResult

instead of authenticating (which worked in the MVC2 app)

I found this question elsewhere on SO, and I did what was suggested, but to no avail.

Here is a clip of my Web.Config

</configSections>
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>

[Code]....

View 1 Replies View Related

MVC :: Passing String Array To The View Using ViewData?

Dec 28, 2010

on the controller, i am passing my string array to the view using ViewData.

[Code]....

on the view, i cated the viewdata to string array, and made a select list.

[Code]....

but if i run the website, i get this error :

[Code]....

View 5 Replies View Related

MVC :: JQuery JQGrid - Make The Storemanager Page With The Grid Of Jqgrid?

Dec 13, 2010

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]....

View 15 Replies View Related

C# - Serialize .NET Dictionary<string, String> Into JSON Key Value Pair Object

Feb 26, 2011

public class Package
{
public Package()
{
name = "";
type = new List<Dictionary<string, string>>();
}
public string name { get; set; }
public List<Dictionary<string, string>> type { get; set; }
}
[code]...

View 2 Replies View Related

Get Selected Value From Rowlist And Pass It To Query String Laong With Page Number In JqGrid

Sep 24, 2010

I have a row list as [10,20,30] i want to pass the selected row list ie if (20 is selected ill pass that 20 as query string and retrieve the value). and also i want to select the page number too. What are the possible ways to achieve the selected value from row list and current page number and then pass the value to query string.

I tried var Page=$(".ui-pg-input").val()
but it is not firing i think i am missing something out here.

View 1 Replies View Related

Context Menu In Jqgrid On Row Click In Jqgrid?

Nov 17, 2010

I am using Jqgrid 3.6 beta version with asp.net and i wanna add dynamic context menu on row selection.When ever user rightclick a row in jqgrid he wants to see some menu like file,edit and other menus. I have completed using single page i.e. both the jqgrid and its parent(JS files) are in single page . But in my main Application I have one master page in which ill define all the JS and seperate page for the content(Jqgrid). So what happens is the same code which is running in single page application is not working in the master detail page.

View 1 Replies View Related

Javascript - How To Make Json Child Nodes (JSON Inside JSON)

Aug 11, 2010

I try to use the jquery + json to get all elements in form and build a JSON var to post in a ASP.NET MVC method.

[Code]....

It method get all fields in a form and build a JSON, but it dont put JSON inside JSON.

Example:

If i have the follow form:

<input name="person.name"><input name="person.age"><input name="person.address.street">

The serialized string build a JSON like this

{ "person.name": "??", "person.age": "??", "person.address.street": "??" }

I need a plugin or some function to generate like this:

{ "person": { "name" : "??", "age" : "??", "address":{ "street": "??" } } }

View 1 Replies View Related

How To Read This JSON String

Nov 3, 2010

I am getting this JSON string from an ASP.Net webservice:

{"d":{"Table":[{"col1":123,"col2":"name","col3":"name","col4":100,"col5":"/Date(1153033200000)/"},{"col1":123,"col2":"name","col3":"name","col4":101,"col5":"/Date(1153033200000)/"},{"col1":123,"col2":"name","col3":"name","col4":102,"col5":"/Date(1153033200000)/"}]}}

In my jQuery how do I reference the Table code so I can loop through the data?

msg.d[i].col1
What am I missing? msg.d.table[i]?

View 4 Replies View Related

MVC ::name Each Linein C# A Json String?

May 23, 2010

have to create, in c#, a json string, something like that:

[Code]....

Mymajor problem is that I don't know how to name each line,what I get is that?

View 2 Replies View Related

How To Convert JSON String To Object In C#

Oct 7, 2010

If I have a string containing valid JSON

how can I convert to an obect in c#?

View 2 Replies View Related

Get Only JSON String As Output Without Any Html

Jan 22, 2011

I am developing a webiste in ASP.NET. On one of the pages page named menu.aspx, with the help of a certain login, I am getting the output in this format

foo({"1":"Jeff","2":"Mik","5":"Tom"});

I am using this code to get the output on the JSON form.

[Code]....

However, I must get the output only in simple JSON on the page without any HTML.

For eg: Here's the screenshot showing the source of the output page. [URL]

Notice that it has only the JSON string as the output.

And here's the screenshot showing the output page source (with HTML). [URL] .This HTML is what I have to remove. How can do I do this? The full code of menu.aspx.cs is putup here. [URL]

View 3 Replies View Related

MVC :: Casting A String As A Json Result?

May 20, 2009

I'm building up a string that will be returned as json from an ActionResult. The code looks something like this:

string blah = "{total = 1,page = 1,records = 3,rows = new[]{new {id = 1, cell = new[] {'1','','dude','bob ',...";
var jsonData = new { blah };
return Json(jsonData);

The response is not properly encoded, so the quotes are being escaped. Is there another way to do this that won't escape the quotes?

View 2 Replies View Related

C# - Create JSON String From SqlDataReader?

Apr 3, 2011

I'm using Json.NET and I'm trying to create a JSON string representing a row from a database table to return in an HTTP response. I'm not sure how to do this while I'm reading from the database.The problem is marked by the obnoxious comments /******** ********/

// connect to DB
theSqlConnection.Open(); // open the connection
SqlDataReader reader = sqlCommand.ExecuteReader();

[code]...

View 1 Replies View Related

C# - Escaping Quotes In Json String?

Aug 12, 2010

System.Web.Script.Serialization.JavaScriptSerializer s = new System.Web.Script.Serialization.JavaScriptSerializer();
result = s.Deserialize<Hashtable>(data);
Error is thrown if data is "{a:""test" 123",b:"hello" }"
No error is thrown if data is "{a:"test 123",b:"hello" }"

How do I adjust the data string so that no error is thrown even when there are quotes?

View 1 Replies View Related

JSON Serialization Of C# Enum As String?

Mar 14, 2010

I have a class that contains an enum property, and upon serializing the object using JavaScriptSerializer, my json result contains the integer value of the enumeration rather than its string "name". Is there a way to get the enum as a string in my json without having to create a custom JavaScriptConverter? Perhaps there's an attribute that I could decorate the enum definition, or object property, with?As an example:

enum Gender { Male, Female }
class Person
{

[code]...

View 2 Replies View Related

Convert A JSON String Into JsonResult?

Apr 21, 2010

I have some stored JSON strings stored in the DB which I want to return to the client as JsonResult . I know that Json(object) turns an object into JsonResult but what if I already have the result in a string ? can I cast it to JsonResult

View 2 Replies View Related

Generate Only JSON String In Output Without Html

Jan 22, 2011

I am developing a webiste in ASP.NET. On one of the pages page named menu.aspx, with the help of a certain login, I am getting the output in this format

foo({"1":"Jeff","2":"Mik","5":"Tom"});

I am using this code to get the output on the JSON form.

[Code]....

However, I must get the output only in simple JSON on the page without any HTML. For eg: Here's the screenshot showing the source of the output page.[URL] Notice that it has only the JSON string as the output. And here's the screenshot showing the output page source (with HTML). [URL] .This HTML is what I have to remove. How can do I do this? The full code of menu.aspx.cs is putup here.[URL]

View 1 Replies View Related

How To Pass A JSON Object Into A String Or Constant

Oct 19, 2009

I need to set up a small driver to work with some json objects but when I goto set it up a constant, I get syntax error....ie

Const JString = "{"title":"Back Safety","Status":{"url":"http://slxpdev03","LearnerStatus": [{ "LearnerName": "SAM1", "CompletionStatus": "Completed", "AttemptStatus": "Completed"}], "CompletionStatusValues":
["Completed", "Incomplete", "NotAttempted", "Unknown"], "AttemptStatusValues": ["Active", "Abandoned", "Completed", "Suspended"]}}"

View 2 Replies View Related

C# - Deserialize Json String For Multiple Results?

Mar 2, 2011

I am using Json.Net however when I go to deserialize the following json I get that Json cannot deserialize to type List.

Json:

{"postalCodes":[{"adminName2":"New York","adminCode2":"061","adminCode1":"NY","postalCode":"10001","countryCode":"US","lng":-73.996705,"placeName":"New York City","lat":40.74838,"adminName1":"New York"},{"adminName2":"New York","adminCode2":"061","adminCode1":"NY","postalCode":"10019","countryCode":"US","lng":-73.985834,"placeName":"New York City","lat":40.765069,"adminName1":"New York"},{"adminName2":"New York","adminCode2":"061","adminCode1":"NY","postalCode":"10021","countryCode":"US","lng":-73.958805,"placeName":"New York City","lat":40.768476,"adminName1":"New York"},{"adminName2":"New York","adminCode2":"061","adminCode1":"NY","postalCode":"10022","countryCode":"US","lng":-73.965703,"placeName":"New York City","lat":40.757091,"adminName1":"New York"},{"adminName2":"New York","adminCode2":"061","adminCode1":"NY","postalCode":"10036","countryCode":"US","lng":-73.991826,"placeName":"New York City","lat":40.759724,"adminName1":"New York"},{"adminName2":"New York","adminCode2":"061","adminCode1":"NY","postalCode":"10065","countryCode":"US","lng":-73.96379,"placeName":"New York City","lat":40.76507,"adminName1":"New York"},{"adminName2":"New York","adminCode2":"061","adminCode1":"NY","postalCode":"10003","countryCode":"US","lng":-73.989223,"placeName":"New York City","lat":40.731253,"adminName1":"New York"},{"adminName2":"New York","adminCode2":"061","adminCode1":"NY","postalCode":"10010","countryCode":"US","lng":-73.981328,"placeName":"New York City","lat":40.737476,"adminName1":"New York"},{"adminName2":"New York","adminCode2":"061","adminCode1":"NY","postalCode":"10011","countryCode":"US","lng":-73.99963,"placeName":"New York City","lat":40.740225,"adminName1":"New York"},{"adminName2":"New York","adminCode2":"061","adminCode1":"NY","postalCode":"10012","countryCode":"US","lng":-73.998284,"placeName":"New York City","lat":40.72553,"adminName1":"New York"}]}

code:

[code]....

View 2 Replies View Related

Javascript - Tuple<string, Int> JSON To Pass To Wcf?

Mar 29, 2011

how to pass this via Json.Tried doing something like

var data = { Item1: "test", Item2: 5 };
var JSONdata = $.toJSON(data);

However that did not work. Although simply changing wcf to expect an object with two properties such as Item1 and Item2 will work. Here is example I'm using... I'll trim it a bit to make it easier to read:

function Post(data, url)
{
$.ajax({
type: 'POST',[code].....

View 1 Replies View Related

MVC :: Obtain Url Query String During Json Request?

Sep 16, 2010

So I'm writing an MVC application, and have a JsonResult post back to obtain some item information for scanned items on a warehouse application I am writing. I'm trying to obtain a URL query string value though, and cannot seem to obtain one via the normal 'Request.QueryString['variable']' way... Is there a way to do this? I also thought about just passing the parameter into my post, but I already have a single value on my jquery post, and I am unsure if I can tack on more values to this.

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved