I want to get data from below mentioned url and get value from it and update into database.
[URL] ....
output from url :
{"tcount":6801}
I want it update number 6801 in database every one minute.
I have a text file named gisQuery129.json that is created using Json.NET - [URL] There is an example on how to create a JSON file and I have done that successfully, but I want to read the file on a page load event and add the values to .NET textbox controls for input values in a query. The created file looks like the following:
{
"myData": {
"randomNumber": "129",
"Application": "MyMapApp",
"FeatureId": "ALL",
"Feature": "ALL",
"spatialQuery": "FEATURE_ID= '11111' AND REQ_SEQ_NUM= 1 AND RAND_PARAM= 129 OR FEATURE_ID= '22222' AND REQ_SEQ_NUM= 2 AND RAND_PARAM= 129"
}
}
I want to read the data in the above sample JSON data and then populate my textboxes something like this:
txtRandParam.text = "129"
txtApplication.text = "MyMapApp" and three more text boxes after that.
I'd like to read data server-side from a web service that outputs in json format. I haven't found any good examples that don't use jquery and are server-side.
Specifically I'm looking at the "weight" field from this api:
[URL]
PS: this is a spin off of another post at: [URL]
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]?
I have read about desearlizing a json file into class fields which I understand. But what I cannot find in a tutorial is how to read in the json data. Everyone just adds the data to a variable and uses it. I will be passing in a json file from a mobile app. I know I should use a web service but for now I want to use an asp.net ASPX page to do this. I will be using the newtonking json control.
View 1 Replieshave 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() {
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": "??" } } }
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]....
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 RepliesIn 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.
I've been tasked with implementing a JSON feed on an asp.net website that will be consumed by 3rd party apps (such as IPhone, Android, etc) and I'd like to follow best practices.
An example of what I'd like to achieve would be something similar to: [URL]
I've chosen the JSON.net api as this seems to be highly recommended.
My Google-fu must be failing me as I can't find a single full example code for an Asp.net web application with JSON.net implemented on it, so I've no real concept of where to begin.
My question is fairly simple:
Should I create this sort of feed as an ASPX, or ASHX file? Or even a .NET Web Service? (Remember that the tools that will be using this feed are on external apps like IPhones, etc)
I created a test feed in both ASHX and ASPX format ... here is the code (I'm using Subsonic to populate the collection) ... are either of these along the correct lines?
ASPX:
[Code]...
I have an Infragistics WebDataGrid on a user control. I add that user control programmatically to an UpdatePanel on a Content Form. Everything works great. I get data in the grid just fine. However, when I go to click any of the grid functions (Sort, Filter, Page, etc.) it throws a Sys.ArgumentException in one of the ScriptResource.axd dynamic files.
Here is the error:
"Microsoft JScript runtime error: Sys.ArgumentException: Cannot deserialize. The data does not correspond to valid JSON. Parameter name: data"
It stops in the following function:
[Code]....
I read about other people having this issue and they said it was due to dates or due to double quotes ("") being in strings? I am binding this datagrid to an Entity Data Framework object query like this.
[Code]....
Read Receipt And Read Outlook Inbox for the same
View 2 RepliesI am displaying selectable rows in a gridview. The selected row uses a stored procedure to display all the fields in a formview when the Select button is clicked.
Only a small subset of the fields in the selected row are editable. When I click the Edit button only the EditItemTemplate fields show up, the read-only fields from the ItemTemplate disappear. I want the read-only rows to remain visible with the editable rows.
If I include the read-only fields in the EditItemTemplate, I get an error when I click Update on the FormView. The error states that there are too many parameters being passed to the stored procedure to update fields. How can I continue to show the read-only fields with the editable fields on the FormView and avoid getting the input parameter error on the stored procedure for the Update command?
i am having my text file data as follows
101011111111101111111111007060540A0941
I would like read this data and place it to the Corresponding cell in data grid.
I am reading data from Excel file using oledbdataadapter and binding to gridview.Every thing working fine.but if the cell is having some text along with bar sysmol ( | ) [Ex : 12345 | 789123] that cell data is not reading from excel file.All fileds in excel sheet is text format only.Some times it's reading correctly & some times it not reading(empty).Is there any problem with bar symbol ( | )
View 1 RepliesMr requirement is i am uploading a .txt file and read that .txt file and bind that data to ASP.NET Gridview control. My .txt file is look like below:
% Compressor type: GT12 C224(38) 55 Trim 0.38 A/R
% Turbine type: GT12 T202(35.5) 72 Trim 0.39 A/R
% Initial data file name:20050669-02.cdt
% Polar inertia: [kg.m2]
% Comment:DATA REDUCTION CODE REV 2.04 RELEASE 03-OCT-2004 (REFERENCE: REPORT 99-0145. REPORT 03-0901. TI-056)
% P reference: 100000Pa - T reference: 298 K
% NC WC PRC ETAC
% RPM KG/S T-T ----
115030.5714 0.0170 1.3398 0.5698
115030.5714 0.0239 1.3209 0.6155
115030.5714 0.0291 1.3020 0.6282
115030.5714 0.0339 1.2822 0.6377
115030.5714 0.0380 1.2576 0.6209
115030.5714 0.0416 1.2311 0.5955
134956.4286 0.0405 1.4045 0.6852
How to read this file and bind data to gridview control.
Right now i am using the following code but it stores whole data in a single column and a single row but i need it in four columns named NC, WC, PRC,ETAC and it's values in respected columns.
Code:
protected void Button1_Click(object sender, EventArgs e)
{
String ext = System.IO.Path.GetExtension(FileUpload1.FileName).ToUpper();
if (ext == ".TXT")
{
String content = System.Text.Encoding.ASCII.GetString(FileUpload1.FileBytes);
String[] ar = content.Split(';');
GridView1.DataSource = ar;
GridView1.DataBind();
}
}
how to get data in four columns in Gridview as a tabular format. I am using technologies Visual Studio 2005, ASP.NET 2.0,C#.NET 2.0 and Windows Xp Operating system.
how can we read all rows data in rowcommand event of gridview?
View 2 RepliesI have a database containing a table with about 700,000 images so I recently enabled Filestream. However, I can't figure out how to render the images.
I have an Imagefield control within a Detailsview which is using an .aspx file to render the image through the DataImageUrlFormatString (which is typical). In my select statements I tried changing the binary field containing the image from objectdata to objectdata.PathName() per the Microsoft documentation but this does not work. I get the red X image box.
I have a ListView which is filled by generic list of type MyClass. I can easily bind data from this list into ListView. But I have problems with reading data in opposite direction. This is my class:
[Code]....
I have also generic list of type MyClass:
[Code]....
Finally I bind data to ListView this way:
[Code]....
My ListView template:
[Code]....
How can I read data from ListView into my List list?
The operation of reading ListView data into List generic list should begin after clicking the button "GetData".
I saw the following advice:
[Code]....
but it does not work - the DataItem property of each Item of ListView has null value. The point is that I have generic list with data. I am binding this data into ListView which can be edited by user. After that after click Save or GetData data from ListView is read into generic list of MyClass type.
I need to read a table from a dtgrid there is one code for example?
View 5 Replieshere, i want to read the data for sql table, but there has error occur. "Invalid attempt to read when no data is present."
protected void DropDownListSelectDateYYYY_SelectedIndexChanged(object sender, EventArgs e)
{
Session["selectDate"] = Session["month"].ToString() + '/' + Session["day"].ToString() + '/' + DropDownListSelectDateYYYY.SelectedValue.ToString();
System.Diagnostics.Debug.Print(Session["selectDate"].ToString());
}
string sqlstr = "select * from ATTENDANCE where staff_Name = '" + LabelEmpSelected.Text.Trim() + "'and attendance_Date = '" + Session["selectDate"] + "' ";
whic session["selectDate"] cann't match to the database column data which is mm/dd/yyyy
If I have in my db a table called User with name, Id, age fields and I want to get these data and put it in a var as a JSON serialize, then I want to send it to javascript page to reform it as I want . I need to know how to put these data in a var as a JSON, how to read the data in the javascript file (how to deal with each one. for example : array[name]?
which thing is more better to deal with these data in asp.net code then send it in the javascript or to send it to the javascript and then to deal with ?
I have an object datasource which is using Business object as a myconnection
The method i have defined under myconnection is
Publicstatic
DataTable getfn(String dtype,
String did,
String dprefix,
String dname)
{
datable table = new datatable(); then declared stored proceedure and defined parameters and assighned values
In the stored proceedure it has a query like select column1,coloumn2,coloumn3 As Call from table where
I need to take data from Call and display it to the gridview through object datasource .
I want to read the data from the grid view(Default1.aspx) for a particular row. How do I achieve this?
After that I want to redirect to another page(Default2.aspx) and display the data for that row in different controls of another page(Default2.aspx). how do I achieve this?