Select Options Value And Text To JSON Format?
Mar 16, 2010How can i convert select options elements to JSON text.
[code]...
I want to set options belong to select which is not runat=server to the And I want to split string to array.
How can i convert select options elements to JSON text.
[code]...
I want to set options belong to select which is not runat=server to the And I want to split string to array.
I'm using jquery autocomplete to call a .aspx page which returns some matching words.
The jQuery stuff relies on a JSON feed to work. Currently, in my C# I'm formatting the output as a string, which ouputs something like this:
{ query:'aa','aardvark','aardvarks']}
I was hoping that because the string is formatted in the JSON format, that would be good enough for the Javascript to process but it appears not.
how to format this text in C# into proper JSON format which JavaScript can deal with properly?
I have a Default.aspx program that contains a Treeview with a SiteMapDataSource. I also have a web.sitemap loaded up with urls. When I run the deafult app I get the tree layout that matches the numbers of options but no text on any of the options to click.
View 1 RepliesI 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]....
I want to display the data in the format that is represented in the screenshot. All the data that is shown is retrieved from Sql Server-2005 Database. Which is the best option for such kind of data representation? I have read in the forums, from them I could not get a clear perspective. Some were suggesting listview others nested datagrid, some repeater control. which one would be a proper and accurate way to go forward ?? Along with some reasons (if possible). And I'm using visual studio 2008, .net Framework 3.5, asp.net with c# and I'm NOT using LINQ in my project and it is a web application. The same picture can also be found at [URL]
View 4 RepliesI'm writing a simple C# Windows Form app, I send it to a website, and on the website there is a Drop Down menu with options. I want to extract those options and add it to my own drop down menu on my app.
So far, I've written something like this:
[code]....
Here is the URL to the Screen shot [URL] I want to display the data in the format that is represented in the screenshot. All the data that is shown is retrieved from Sql Server-2005 Database. Which is the best option for such kind of data representation? I have read in the forums, from them I could not get a clear perspective. Some were suggesting listview others nested datagrid, some repeater control. which one would be a easier, proper and accurate way to go forward ?? Along with some reasons (if possible !!). And I'm using visual studio 2008, .net Framework 3.5, asp.net with c# and I'm NOT using LINQ in my project and it is a web application. URL Screen Shot: [URL]
View 2 RepliesI have a objectdatasource control with a field of date and time and I was wanting to know how you format the date to uk format with the select statement through my objectdatasource. And what type of integer is bigint in SQL?
View 3 RepliesIn Crystal Reports Viewer (2008) for ASP.Net, when you click on the Export button, the Export dialog shows up with File Format options:
[code]...
how to remove some of these options so that end users wouldn't see it?
i've gridview and sqldatasource bind,i got 2 field in gridview start date and end date,actual problem : both dates coming in format -11/4/2010 12:00:00AMi want 11-04-2010
View 4 RepliesI have a drop down list with two options Score and status. On selecting score select score i display a MultihandleSliderExtender to select the score range ex: 10 to 20 and on selecting status i display dropdown list . On displaying one option i make the other as not visible.
Now comes the problem in Firefox (works properly in IE) when i select score and then try to change my option to status it does not allow me to do so i.e the mouse over event on the dropdownlist is not working.
The question is in the title but to make it clearer when you use a normal server control like
<asp:textbox />
<CC1:CtrlArticleList SortBy="Title" ID="compositeControlArticleList" runat="server" />
the properties of textbox allow you to select from a dropdown list (eg visibility=...true or false). How do I replicate this in composite control?
Added code since question asked:
[code]....
I am using a listbox
<asp:ListBox ID="ListBox1" runat="server" DataSourceID="_dsOccTypes" DataTextField="ListDisplay"
DataValueField="ListValue" Rows="6" SelectionMode="Multiple" Width="450"></asp:ListBox>
There are 10 options in the list box but I want the user only to select a maximum of 4. If user selects more then 4 then I want to display a message to user that they cannot select more then 4 options.
How can I achieve the above using some custom validator control?
My approach in reading a json format is parsing into an array. My question is this the right way of reading json format?
View 5 RepliesI'm working with big blobs of JSON. These blobs change slightly over time and a revision history is kept. I'd really like to be able to do a visual diff on them, but my problem is they're being stored without any formatting at all - everything is on one line, so that makes it a little hard to see what changed.
View 3 RepliesI have a text field that users enter information into a database (SQL Server). They are entering as little as a few sentances to multiple paragraphs. I can successfully display the data on my webpage, but the text field is not formatted very nicely. The output is all smashed together like one big paragraph. Ironically, when I also display the text as a tool tip it outputs as multiple paragraphs like it was entered. How can I format the output in the datalist to create a more readable text field? My datalist field is as follows:
<asp:Label id="WebDescriptionLabel" runat="server" Text='<%# Eval("WebDescription") %>' ForeColor="Brown" />
How to return values from Webmethod to the client in JSON format? There are two static int values that i want to return.Do I need to create new object with those 2 properties and return it?The GetStatus() method is called frequently and i don't like the idea of creating a special object each time just for json formatting...
[WebMethod]
public static int GetStatus()
{
int statusProcess,statusProcessTotal;
Status.Lock.EnterReadLock();
statusProcess=Status.Process; //Static field
statusProcessTotal=Status.ProcessTotal; //Static field
Status.Lock.ExitReadLock();
return ...
}
On client side I catch the return value in :
function OnSucceeded(result, userContext, methodName)
(PageMethods.GetStatus(OnSucceeded, OnFailed);)
I was using Extjs to send a json object to my asp.net webservice/Update method , but I find the following error in firebug reseponse.
[Code]....
I have a simple webservice that I would like to upload a file to. The problem is that I need the response in json.
Form my experience in order to get a response in Json my request has to have a content-type of 'application/json'. But ofcourse this cannot be the case with a file upload since the content type will have to be 'multipart/form-data'.
In my Json i want to return a value showing whether successful and a filename.
[code]...
i Declare in.cs file
TextBox tb=new TextBox();
and how to get aspx when page is load
<input type="Text" runat="server"/>
using jquery json
I have the following web method , no success on return a correct Json format.
[Code]....
GetAll() return list of type "Company" POCO classes.
The web method complaint type "Company" could not cast to object. However I could not just return the Company type because client side Json only accept its 2 properties -"CompanyName", "ID" and I want to keep it that way.
Of cause, I had tried create a CompanyDTO which only have those two properties, but same error - "Unable to cast object of type..."
How should I modify in my web method to make it able to return a list of partial "Company" type in Json format?
how would i go about returning a generic list in json format, can anyone point me to any good examples.
View 2 RepliesI'm completely new to both VB.NET and JSON, and I'm trying to figure out how to do SQL queries towards an SQL 2005 Express server and format the return value to JSON. I got the queries working using this (perhaps very newbie-like) code;
Imports System
Imports System.Data
Imports System.Data.SqlClient
Imports System.Web.UI
Imports System.Web.UI.WebControls
Partial Public Class SQLConnect
Inherits System.Web.UI.Page
'Defines SQL variables
Dim con As New SqlConnection
Dim cmd As New SqlCommand
Dim dr As SqlDataReader
Dim ReadData As String
Dim i As Integer
Sub Click(ByVal s As Object, ByVal e As EventArgs)
'Define SQL address, database, username and password
con.ConnectionString = "Data Source=localhostSQLEXPRESS;Initial Catalog=tempdb;User ID=tesst;Password=test"
Try
'Initialize connection
con.Open()
'Specify SQL query
cmd = New SqlCommand("SELECT * FROM Member", con)
'Execute query, dump result array into variable
dr = cmd.ExecuteReader()
messageLabel.Text = "<br />Connection established<br />"
While (dr.Read)
i = 0
For i = 0 To dr.FieldCount - 1
'Dump query results into a variable
ReadData += dr.Item(i).ToString
Next
End While
'Print query results
messageLabel2.Text = ReadData
'Close connection
con.Close()
Catch ex As Exception
messageLabel.Text = "<br />Connection failed<br />"
End Try
End Sub
End Class
I have been looking at this, and I would love to see some code examples using this class or any other good method.
How can we consume a web service using asp.net out put in json formate?
View 1 RepliesI'm using a book to create a shopping site and need to change the following code so that the current dropdown list, of colour options, is replaced by just read only text. I'm a novice and despite best efforts I can't fathom it out. If anyone can change the code for me I would be extremely grateful.
The code below is the code-behind page for a Product List page where I want each product displayed to also display its colour options as just text (I don't need the shopper to select a colour choice until they click through to the detail page)
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
public partial class UserControls_ProductsList : System.Web.UI.UserControl
{
protected void Page_Load(object sender, EventArgs e)
{
PopulateControls();
}
private void PopulateControls()
{
// Retrieve DepartmentID from the query string
string departmentId = Request.QueryString["DepartmentID"];
// Retrieve CategoryID from the query string
string categoryId = Request.QueryString["CategoryID"];
// Retrieve Page from the query string
string page = Request.QueryString["Page"];
if (page == null) page = "1";
// Retrieve Search string from query string
string searchString = Request.QueryString["Search"];
// How many pages of products?
int howManyPages = 1;
// pager links format
string firstPageUrl = "";
string pagerFormat = "";
// If performing a product search
if (searchString != null)
{
// Retrieve AllWords from query string
string allWords = Request.QueryString["AllWords"];
// Perform search
list.DataSource = CatalogAccess.Search(searchString, allWords,
page, out howManyPages);
list.DataBind();
// Display pager
firstPageUrl = Link.ToSearch(searchString, allWords.ToUpper() == "TRUE", "1");
pagerFormat = Link.ToSearch(searchString, allWords.ToUpper() == "TRUE", "{0}");
}
// If browsing a category...
else if (categoryId != null)
{
// Retrieve list of products in a category
list.DataSource =
CatalogAccess.GetProductsInCategory(categoryId, page, out howManyPages);
list.DataBind();
// get first page url and pager format
firstPageUrl = Link.ToCategory(departmentId, categoryId, "1");
pagerFormat = Link.ToCategory(departmentId, categoryId, "{0}");
}
else if (departmentId != null)
{
// Retrieve list of products on department promotion
list.DataSource = CatalogAccess.GetProductsOnDeptPromo
(departmentId, page, out howManyPages);
list.DataBind();
// get first page url and pager format
firstPageUrl = Link.ToDepartment(departmentId, "1");
pagerFormat = Link.ToDepartment(departmentId, "{0}");
}
else
{
// Retrieve list of products on catalog promotion
list.DataSource =
CatalogAccess.GetProductsOnFrontPromo(page, out howManyPages);
list.DataBind();
// have the current page as integer
int currentPage = Int32.Parse(page);
}
// Display pager controls
topPager.Show(int.Parse(page), howManyPages, firstPageUrl, pagerFormat, false);
bottomPager.Show(int.Parse(page), howManyPages, firstPageUrl, pagerFormat, true);
}
// Executed when each item of the list is bound to the data source
protected void list_ItemDataBound(object sender, DataListItemEventArgs e)
{
// obtain the attributes of the product
DataRowView dataRow = (DataRowView)e.Item.DataItem;
string productId = dataRow["ProductID"].ToString();
DataTable attrTable = CatalogAccess.GetProductAttributes(productId);
// get the attribute placeholder
PlaceHolder attrPlaceHolder = (PlaceHolder)e.Item.FindControl("attrPlaceHolder");
// temp variables
string prevAttributeName = "";
string attributeName, attributeValue, attributeValueId;
// current DropDown for attribute values
Label attributeNameLabel;
DropDownList attributeValuesDropDown = new DropDownList();
// read the list of attributes
foreach (DataRow r in attrTable.Rows)
{
// get attribute data
attributeName = r["AttributeName"].ToString();
attributeValue = r["AttributeValue"].ToString();
attributeValueId = r["AttributeValueID"].ToString();
// if starting a new attribute (e.g. Color, Size)
if (attributeName != prevAttributeName)
{
prevAttributeName = attributeName;
attributeNameLabel = new Label();
attributeNameLabel.Text = attributeName + ": ";
attributeValuesDropDown = new DropDownList();
attrPlaceHolder.Controls.Add(attributeNameLabel);
attrPlaceHolder.Controls.Add(attributeValuesDropDown);
}
// add a new attribute value to the DropDownList
attributeValuesDropDown.Items.Add(new ListItem(attributeValue, attributeValueId));
}
}
}