I'm trying to use the JavaScriptSerializer to work with this code. However it crashes when it reaches the last line;
Dim json As New String(sr.Serialize(dt))
I get this error message;
A circular reference was detected while serializing an object of type 'System.Reflection.Module'.
I want to be able to turn a datatable or dataset or the results of my SQL queries into JSON - purpose is for a WCF service which will not do it.
View 2 RepliesI would like to send json data from a HTML table to the ASP.NET code-behind and update the data in and SQL Server database. The code and JSON for the TableProductToUpdate() is below.
function UpdateProductTable() {
$.ajax({
type: "POST",
[code].....
I am having a heck of a time with some very simple json. I have a very basic VB.NET webform which which writes out the contents of a datatable serizlized with JavaScriptSerializer.
CODE:
On the jquery side I am doing this.
CODE:
This is returning "invalid json"
Here is the output
CODE:
I need help converting DataTable to XML. I have done it using LINQ but I can't get exactly as I have to. I made a picture so that you can easily understand. The XML needs to be in certain format like below so I can't just use dt.writexml(). Artist ID needs to auto number. Songs are groupped by Artist. Prefer a solution in Linq coz that's what I have used throughout the project but I coundn't manage to get what I want here. The columns names are known so you can use something like this in the code. row.Field(Of String)("title")[code] i also have some more code that will query first created xml and do the grouping but still having album="albumname" in the song element as attribute. And it should be just one query from datatable to xml.i hate having to query against xml again to just refomat it.[code]
View 2 RepliesI am been stuck on this for 3 days now...I have been accessing the twitter api to pull a user_timeline for a list of users and the json that comes back is impossible to work with. I tried to deserialize it using javascriptserializer and get an error:invalid object passed in , ':' or '}'
Now this is frustrating since I expect the json being returned to be error free. Then I tried json.net and split the posts using string.split and tried to convert each post to Jobject or jarray. for Jarray I get
'unexpected end of content while loading jArray
[Code]...
Now I have formatted the code here and not pasted the whole file but it does look like valid json to me and I do not alter anything after receiving the stream from the twitter api. Can someone please point me in the right direction? I really need to get this stuff parsed?
I'm strugling the whole day with the next JSON string
{
"0":{"link":"afbeeldingenplaatje1.jpg"},
"1":{"link":"afbeeldingenplaatje2.jpg"},
"2":{"link":"afbeeldingenplaatje3.jpg"}
}
How can i deserialize this? What's wrong with the next code (vb.net)
Public Class DataString
Private m_link As String
Public Property link() As String
Get
[CODE]...
It returns always an empty result.
how to receive and send back json. Hope someone can help me on this. I understand by examples.
On my clientside, I am sending a ajax json string "name":"theName" to the server side and would like the server side to return a string saying "welcome &name ".
Client-side code
<!DOCTYPE html>
<html>
[Code]....
I need help converting datatable to xml using Linq. I could do it with hardcoded column names as you can see in my code .. but i need it without hardcoding it ..Example datatable ..My linq query ..
Dim xmlDoc As New XDocument(
From row In dt.AsEnumerable()
From row In dt.AsEnumerable()[code]......
I am trying tomodify the following code from a datagrid to a datagridview but I'm not sure about how to do the conversion. The problem lies with theDataGrid.TableStyles.A dgv does not have that property.
Function
GetColumnHeadingText(ByVal
Column As
[code].....
Below is my JSON formated String
{"AliasName": "ysiCountryInfo", "DataClass": {"Description":"United States 111","Code":"usa","WriteOffTaxPointAdjustment":0,"IndexationRounding":6}}
I would like to deserialize object into below class
[code].....
I am having some trouble with creating a simple function that converts a column of a datatable to an array (containing all numbers). Upon running it, it says "Index was outside the bounds of the array"; however, I couldn't understand why my function would create this problem.Also since I do not usually program using VB.Net, I am not sure if my function has other errors (like syntax errors).
View 2 RepliesI have a "result" which is DataTable and I like to get the x distinct values(City) and convert it back to DataTable how do I do this the code below gives me an error
Dim query = (From x In results.AsEnumerable()
Select (x.Field(Of String)("City"))).Distinct().CopyToDataTable()
so what I want is records of distinct cities I can get that but the problem I am having is converting it back to Datable.
Edited:I am using "where" in this statement and it does convert to Table(works fine) but not on "select"
Dim results = (From myRow In ds.Tables(1).AsEnumerable()
Where (myRow.Field(Of String)("xxxx") = xxxx)
Select myRow).Distinct().CopyToDataTable()
I have a JSON response from a web service that I need to be converted to an object then to an array. My response is similar to the one below:
{"status":{"error":"NO","code":"200","description":"none","message":"Request ok"},"geolocation":{"lat":"38.89515","lng":"-77.0310"},"stations":[{"country":"United States","regPrice":"0.00","midPrice":"0.00","prePrice":"0.00","streetAddress":"1401, I St[code]....
I am doing this is VB.NET within a console for now. Basically I am trying to create a simple way to test my API calls and output the information. What I am trying to accomplish is having to loop through the JSON array and list the stations.
I am currently writing unit tests for an application near completion (before management looks at it and turns it inside out). I am testing the business layer and a method is set to return a datatable of all "GroupID"s, which are simply an integer to represent the group that a user belongs to.
I'm assuming the best way to assert on this unit test would be to assert that the correct groupIDs are being returned from a controlled test database. However, I'm not sure how to assert on a datatable. Is the only (and best) possible way to accomplish this to simply loop through the datatable until it's empty and add each value to an array of integers? How would one go about asserting on this test?
How can I convert a JSON string to an array OR a JSON string to XML in VB.NET? I know how to do this in C#, as I have read dozens of articles on it, however, I am unable to figure out how to achieve the same result in VB.NET.
I'm using the System.Web.Script namespace via System.Web.Extensions.dll (from Microsoft).
I'm willing to use an additional DLL file if needed.
I'm sure this has been asked before but I'm not finding quite the information I'm needing so I thought I'd post this.
I've written a PHP script that returns a simple JSON object that looks like this:
{"status":"success","level":"admin"}
I'm doing a standard web request that submits the required data to the script over the internet and that's working fine.
Now, I want to use JSON.NET to pull out the individual variables so I can know what the values of "status" and "level" are. The problem is, I have no idea where to start.
I'm doing this in VB.NET (on the .NET Compact Framework).
I am accessing the facebook api and using the json.net library (newtonsoft.json.net)I declare a Jobject to parse the content and look for the specific elements and get their values. Everything works fine for the first few but then I get this unexplained nullexception error " (Object reference not set to an instance of an object)Now I took a look at the declaration but cannot see how to change it. Dim jobj as JObject = JObject.Parse(responseData) message = jobj("message").tostring
The error occurs at the last line above.I check to see if message is null and then look for the next desired field as follows
[Code]...
This is one example where "message" does not appear in the first few lines but appears later. So what I do is look for position of message and description and which ever is first go and get that and if I get an error or the fields do not return anything, I try and parse by regex and even that is not working right.
I have two experimental web services. One is an asmx contained within a .net web application. The other is a WCF service library being invoked from the web application.The asmx basically does everything I need, but I think WCF would be better, except that it doesn't do anything as I would expect after fiddling with the asmx service.For example, the same method behaves differently in each:
' ASMX
<WebMethod(BufferResponse:=True, EnableSession:=False)>
Function Test(aObject as Object) as Object
' object will have been successfully serializaed into a dictionary
[code]...
my goal is to
1.Take an file(exe,dll,etc)
2.Convert it into hex
3.place that hex values in a stack
4.Execute the values inside the stack to its original form(i.e. take the elements out of stack and then convert it to a compile format)
Imports System.IO
Sub Main()
Dim fileName As String = "ABC.exe"
[code]....
I have to send a request to Webservice and I have a working PHP solution, that I have to translate in VB.net
Here's the code working in PHP
//fill in the details of the contacts.userId is obtained from loginResult.
$contactData = array('lastname'=>'Valiant', 'assigned_user_id'=>$userId);
//encode the object in JSON format to communicate with the server.
[code]....
Naturally I imported a reference to a Json library and Imported (Imports Newtonsoft.Json)?
I am trying to display value of the field ("UserID") for every row exists in datatable to checkboxlist(make the checkboxlist item selected).
I used for loop, but only the field value from last row of RoleUsers table is selected in the checkboxlist.
Here is my code
Private Sub DisplayRoleUser()
Dim conn As SqlConnection
Dim cmd As SqlCommand
[Code].....
I have a datatable and I apply a filter to the defaultview.rowfilter property of that datatable. If I then loop through the rows collection of the datatable, will I only be able to see those rows that the filter applies to, or will it loop through all the rows?
View 6 RepliesI am working on a project that takes an xml schema and xml data files and places them into a DataTable, the 2 files are generated from a working table that i have written to disk. I wish to load these 2 files into a DataTable. Here is What i have
vb.net
Friend Function CreateTable(ByVal tableName As String) As Boolean
Dim table As New DataTable(tableName)
table.ReadXmlSchema(tableName & ".xsd")
[code]....
this however produces the following error on line 3
Quote:
System.ArgumentException was unhandled Message=DataTable 'get_item_list' does not match to any DataTable in source.
get_item_list is the parameter passed into this function (tableName)
I have a datagridview bound to a datatable setting its datasource property to the datatable. I would like to have a child form that contains a list of columns associated with the datatable that contains a checkbox that will allow the user to hide and show the columns ( I do not know the best control to use here) (I assume this is the easy part as All i need to do is loop through each of the datatable's columns to get the column name)
now I would like save these visible columns on some event like form_closing so that the next time the user opens the form up it will remember the settings
I came across a problem with using a BindingSource as my DataGridViews.DataSource. Whenever I applied a filter to a column in the BindingSource and the user makes changes that don't match the column filter the DataGridViewRows would automatically disappear. A similar thing would happen when applying a Sort to a column. If the user made any changes the DridGirdViewRows would automatically sort causing rows to be moved around. This was not ideal for my application and there isn't anyway to stop this from happening with the BindingSource.
To correct this issue I have to use subsets of data. I use a DataView to apply the filter and sort to the main DataTable, which creates the subset DataTable.The problem is when I use the DataView.ToTable method I loose the Primary Key and RowError information. So I have to reapply this information everytime the user filters or sorts the DataGridView.Is there a better way to get a subset DataTable?[code]...
I have a datatable that has a resource in one field and hours used in another, it looks like this -
Resource Hours Used
Manager 1
Accountant 1
Field Staff 2
Accountant 3
Manager 4
Manager 1
Administrator 6
Field Staff 4
Manager 0.5
Administrator 1
What I want to do is be able to create a summary of the data table above that groups multiple occurrences of a resource and adds up the hours used for that resource, creating a summary that looks like this -
Resource Hours Used
Manager 6.5
Accountant 4
Field Staff 6
Administrator 7
Is there a simple way to assign a populated datatable's columns to another empty datatable? That is, I want to copy a datatable's structure only but not its data.
View 6 RepliesI'm using vb.net 2010.I have a DataSet with a Table and data. MyDataSet1 which contains Table1 I want to create another table that is the same as the Table1 but without data, but it should have the columns, etc.
View 1 RepliesI am getting array of selected datarows from a datatable.select.I use the commands below to get that array or datarows
Dim foundRows() As DataRow
strExpression =
Here is what I tried.I have looked at examples by MS but they all just write to the screen and I have no interest in that.
For Each rowWork In foundRows
dtWork.Rows.Add(rowWork)
Next[code]....
"LineOfBusiness = 'CPP'"
foundRows = modXchange.pdtWork.Select(strExpression)
Now, I want to place the rows from foundrows into an empty data table.I did what I thought was the obvious but that only returns a bunch of rows with no data