Manually Converting Result Dataset To JSON?
Mar 3, 2011
I have DataReader that holds the results from a stored procedure caal. The results consist of two fields ...
UserID
UserName
Normally I bind these results to an ASP.NET dropdownlist control ...
ddlUserList.DataSource = rdr // rdr is the DataReader
ddlUserList.DataTextField = "UserName"
ddlUserList.DataValueField = "UserID"
ddlUserList.DataBind()
However I am now trying to accomplish the same thing using jQuery AJAX. What I am stuck on is how to manually convert the dataset held in the DataReader to JSON. How are multiples values separated? Does this look correct?
{{"UserID":1, "UserName":"Bob"}, {"UserID":2, "UserName":"Sally"},{"UserID":3, "UserName":"Fred"}}
I realize there are libraries out there such as JSON.NET to handle the serialization but I am in the learning stage now and want to make sure I understand everything from the bottom up.
View 1 Replies
Similar Messages:
Feb 1, 2010
I want to retreive the data from database and assign it to dropdownlist. For that I'm using the following jquery in the onclick event
[Code]....
View 1 Replies
Apr 4, 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
Jan 9, 2011
Till now I used to design RDLC file before and assigned typed dataset table columns.Report processing mode is local. But now my stored procedure returns different columns based on condition i.e columns are not fixed every time. Now I need to add that columns to typed dataset and dataset is assigned to RDLC file. So dataset and RDLC files are create dynamically based on stored procedure result set columns.
View 1 Replies
Feb 5, 2010
I am working on writing some code to scrub user input to my ASP.NET site. I need to scrub input to remove all references to ASCII characters 145, 146, 147, 148 which are occasionally getting input from my mac users who are copying and pasting content they write in a word processor on their macs.
My issue is the following three strings I am led to believe should output the same text.
string test1 = Convert.ToChar(147).ToString();
string test2 = String.Format("'{0}'", Convert.ToChar(147));
char[] characters = System.Text.Encoding.ASCII.GetChars(new byte[] { 147 });
string test3 = new string(characters);
Yet when I set an ASP TextBox to equal the following
txtShowValues.Text = test1 + "*" + test2 + "*" + test3;
I get a blank value for test1, test2 works correctly, and test3 outputs as a '?'.
Can someone explain what is happening differently. I am hoping this will help me understand how .NET is using ASCII values for characters over 128 so that I can write a good scrubbing script.
EDIT
The values I mentioned (145 - 148) are curly quotes. So single left, single right, double left, double right.
By "works correctly" I mean it outputs a curly quote to my browser.
SECOND EDIT
The following code (mentioned in an answer) outputs the curly quotes as well. So maybe the problem was using ASCII in test 3.
char[] characters2 = System.Text.Encoding.Default.GetChars(new byte[] { 147 });
string test4 = new string(characters2);
THIRD EDIT
I found a mac that I could borrow and was able to duplicate the problem. When I copy and paste text that has quote symbols in them from Word into my web app on the mac it pastes curly quotes (147 and 148). When I hit save curly quotes are saved to the database, so I will use the code you all helped me with to scrub that content.
FOUTH EDIT
Spent some time writing more sample code based on the responses here and noticed it has something to do with MultiLine TextBoxes in ASP.NET. There was good info here, so I decided to just start a new question: http://stackoverflow.com/questions/2215547/asp-net-multiline-textbox-allowing-input-above-utf-8
View 3 Replies
Mar 31, 2011
I have a webservice which retrieves data from another external service. The data is already in JSON Format. So I retrieve it and set it to the return value (type: string) of my webservice. But according to firebug the webservice then encapsulates the provided JSON-Data with a backslash, e.g. it returns:
[Code]....
instead of
[Code]....
But the JSON provided by the external service is correct. So how could I provide the correct string to jTemplate from my Webservice?
View 4 Replies
Feb 2, 2010
I've created a Web User Control that is placed on the page at design time. It's purpose is to pop up with a grid of items the user is to choose from. So I've got a gridview on it. And this code in the usercontrol:
Public Property DataTable() As Data.DataTable
Get
If Not IsNothing(ViewState("_SelectGridDataTable")) Then
Return ViewState("_SelectGridDataTable")
Else
Return Nothing
End If
End Get
Set(ByVal value As Data.DataTable)
ViewState("_SelectGridDataTable") = value
End Set
End Property
So when the user clicks on a button on the page, I put this in the code on the page:
SelectGrid2.DataTable = GetContacts().Tables(0)
SelectGrid2.Show()
And this works fine. The grid pops up (using jQuery) and the grid is shown. The problem is, that when the user clicks the "OK" button on the UserControl, the ViewState("_SelectGridDataTable") is always nothing. And I don't get it, since it's in the viewstate.. ?!? So does viewstate here not REALLY mean viewstate?
View 1 Replies
Feb 4, 2011
I have a controller that uploads a file. I would like to return a json result with bool success (if successfully uploaded otherwise false) and message (this could be error message that occured OR link to a file OR link to an image, depending on what was uploaded).What's the best way to approach thisI have this
public class UploadedFile
{
public bool Success { get; set; }
public string Message { get; set; }
}
then In my controller I would set Success to true/or/false and Message to <a href OR <img am i on the right track?How would i then parse this in the view so that when image it will show an image, if link show a link, if error simply alert error.
View 2 Replies
Apr 19, 2010
I am unable to convert JSON string to .net object in asp.net. I am sending JSON string from client to server using hidden field (by keeping the JSON object.Tostring() in hidden field and reading the hidden field value in code behind file)
Json string/ Object:
[[{"OfferId":"1","OrderValue":"11","HostingTypeID":"3"},
{"OfferId":"1","OrderValue":"11","HostingTypeID":"3"},
{"OfferId":"1","OrderValue":"11","HostingTypeID":"3"},
{"OfferId":"1","OrderValue":"2","HostingTypeID":"3"},
[Code]....
While converting i am getting following error:
Expecting element 'root' from namespace ''.. Encountered 'None' with name '', namespace ''.
View 3 Replies
Oct 24, 2010
I'm creating an inbox system for my website which allows basic communication between users. I'm fetching the results with jquery calling a webservice. Then I'm using a jquery template engine to render the results to the screen. So far this all works good. but now I want to add some click functions on certain parts of inbox messages. For example I want the title of the message to be clickable so it will expand/collapse the fulltext which is hidden in a div beneath it.
But I can't seem to use the jquery selectors on this dynamic json result. It works when I put the function in the href tag itself but I don't really want to. I also tried adding the function after the success function but no luck either. Is it possible at all to use selectors with a template engine? I hope I made myself clear otherwise feel free to ask more information.
View 3 Replies
Feb 8, 2011
I have the following actionresult in my controller;
[Code]....
and this jquery script to print values pass from controller in textboxes.
[Code]....
View 8 Replies
Feb 12, 2010
I have been at this for hours and am pretty stuck. I am using MVC2 with VS2010 Beta 2.
Here is my javascript from the view:
[Code]....
Here is my controller code:
[Code]....
I can set a breakpoint in the GetMember method and it does receive the Member_ID parameter correctly. It also correctly returns a member object from my repository (dpR). The function in $.getJSON call that is supposed to receive this result does nothing however. There are no exceptions or javascript errors. It is just silently dying.
View 7 Replies
Jun 5, 2010
I have a client side code that creates an AJAX request to the server (using jquery). My problem is that one of the json results called 'name' gets spaces appended to the value.
For example: In the DB the value is "Hello" but when i get the request back using ajax it comes out as "Hello "
It is ALWAYS the one value that gets spaces appended, even on calls to different functions in the web service. Ive tried changing its name on the AJAX response, but the same thing happened.
Ive gone and ran queries directly against the web service by navigating to its address using my browser, and executed the query manually, and it comes back properly ("Hello").
Ive also tested this in IE, FF, Opera, Chrome and using different computers with the same results.
View 4 Replies
Aug 22, 2010
have this site that has an api that can provide city name if I send my zip code as a parameter. http://www.postnummersok.se/api?q=16447the result is returned as a json object. Now i just want to read the result in my js function.I have tried the following but it always returns null:
function postnr() {
View 9 Replies
Mar 9, 2011
In my project, i have a DBML file which is acting as a Data Access Layer. There one more utility method that is converting the existing result into dataset. Below is my method:
[code]....
View 1 Replies
Mar 21, 2011
The following code works fine for converting an XML data set to be enumerable for Linq.
'Query webservice for data
Dim propertyInfo As String = myService.GetProperty(userName, password, Acct)
' Create a new DataSet.
[code]...
However, it does not retain the xml tags in the Linq enumerablerable dataset ('newDataSet2"). I don't think I can rely on the array index order as being the same everytime, so this would obviously cause a problem if I'm trying to align the array items up to my database fields. How can I make newDataSet2 retain the XML tags (column headings) to insure I know what data field each array item belongs to?
View 1 Replies
Dec 7, 2010
What's the best way to go from a dataset to the body of an email?
I have a .net console app to send email notification based on results of a stored proc and wanted to know how best to go from SQL data to Email body?
html body with colors and fonts would be best but plain text is also fine.
View 2 Replies
Jan 12, 2011
I have a gridview which I am using to display a dataset result. The problem is I am using paging in it. But when I click on the page # it says that I haven't handled the event. Do I need to rebind the dataset?
View 1 Replies
Jan 1, 2010
I am using membership functions like
Roles.GetAllRoles()
or
Membership.FindUsersByName();
I want to assign the result of these fucntions to a dataset or datatable and not directly to a GridView.
View 3 Replies
Aug 10, 2010
I have a GridView ,I enabled Paging.I want to convert the current page of gridview into DataTable.Is there any extension method or techniques available to convert the current page contents of a gridview into DataTable?
View 1 Replies
Apr 12, 2010
I have a dataset.table which has some null values. am trying to trasform this using xslt to display like excel. If the value is null, then that node is ommitted by the xml. i tried deafulting the null values from the database itself and thats not generic. Handling null values is troublesome. I tried couple of methods to default null values by looping and thats not optimal solution. I used LINQ to handle null values but couldnt comeup with a neat solution. what am looking for is a generic optimal solution to handle these values.
View 2 Replies
Jul 14, 2010
I am having a problem with this code, i had a post on this however this code is slightly different to that so i thought i would post a spearate thread.
Anyway, what i am trying to do is display job vacancies by the result of a DropDownList value. Now each job name has a description. The problem i am having is i need to display the results in this logic:
Job nameJob descriptionJob location. But what is happening is the job description (body) is repeating the more vacancies there are. This is the page:
http://kidsunlimited.co.uk/vacancies_test_two.aspx
If you select Deputy Nursery Manager from the DropDown and hit the Search button you will see the results. After listing the first two locations the description is repeated and then the 3rd location is shown after this. This is my code:
[Code]....
View 7 Replies
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
Jul 1, 2010
I have this ListView that has a Drop Down List.Everything works fine (I think/hope) except that the drop down list are not showing its result correctly.This is the code.
Front-End
[Code]....
The code behind consist of the page_load and the ItemDataBound
[Code]....
View 3 Replies
Mar 1, 2011
I'm having a problem with my Linq to XML query. I'm getting the result data I want, but it's nested so deep that there must be a better way.Here is my XML:
[Code]....
I'm trying to get a list (simple string[]) of all Item IDs where Category Names contains "Other".Here is my Linq:
[Code]....
[Code]....
Here is a snapshot of my result from Visual Studio:The results I want are there ("item100", "item400", "item500"), but buried so deeply in the results var.
How can I get the query to return a simple
string[] = { "item100", "item400", "item500" }
View 4 Replies
