Hi arie.keren,
Refer the below sample for multiple record returned by the json string.
HTML
<asp:GridView ID="grdView" runat="server" AutoGenerateColumns="true">
</asp:GridView>
VB.Net
Protected Sub Page_Load(sender As Object, e As System.EventArgs) Handles Me.Load
Dim dt As New DataTable()
dt.Columns.AddRange(New DataColumn(14) {New DataColumn("nid", GetType(Integer)), New DataColumn("vid", GetType(Integer)), New DataColumn("type", GetType(String)), New DataColumn("language", GetType(String)), New DataColumn("title", GetType(String)), New DataColumn("uid", GetType(Integer)), _
New DataColumn("status", GetType(Integer)), New DataColumn("created", GetType(String)), New DataColumn("changed", GetType(String)), New DataColumn("comment", GetType(Integer)), New DataColumn("promote", GetType(Integer)), New DataColumn("sticky", GetType(Integer)), _
New DataColumn("tnid", GetType(Integer)), New DataColumn("translate", GetType(Integer)), New DataColumn("uri", GetType(String))})
Dim url As String = New System.Net.WebClient().DownloadString("http://kn.tokonusaria.com/testpoint/node.json")
Dim jsonArray As JArray = JArray.Parse(url)
For i As Integer = 0 To jsonArray.Count - 1
Dim isiData As Infos = (New JavaScriptSerializer()).Deserialize(Of Infos)(jsonArray(i).ToString())
Dim dr As DataRow = dt.NewRow()
dr("nid") = isiData.nid
dr("vid") = isiData.vid
dr("type") = isiData.type
dr("language") = isiData.language
dr("title") = isiData.title
dr("uid") = isiData.uid
dr("status") = isiData.status
dr("created") = isiData.created
dr("changed") = isiData.changed
dr("comment") = isiData.comment
dr("promote") = isiData.promote
dr("sticky") = isiData.sticky
dr("tnid") = isiData.tnid
dr("translate") = isiData.translate
dr("uri") = isiData.uri
dt.Rows.Add(dr)
Next
If dt.Rows.Count > 0 Then
'Bind DataTable to your GridView
grdView.DataSource = dt
grdView.DataBind()
End If
End Sub
Public Class Infos
Public Property nid() As String
Get
Return m_nid
End Get
Set(value As String)
m_nid = value
End Set
End Property
Private m_nid As String
Public Property vid() As String
Get
Return m_vid
End Get
Set(value As String)
m_vid = value
End Set
End Property
Private m_vid As String
Public Property type() As String
Get
Return m_type
End Get
Set(value As String)
m_type = value
End Set
End Property
Private m_type As String
Public Property language() As String
Get
Return m_language
End Get
Set(value As String)
m_language = value
End Set
End Property
Private m_language As String
Public Property title() As String
Get
Return m_title
End Get
Set(value As String)
m_title = value
End Set
End Property
Private m_title As String
Public Property uid() As String
Get
Return m_uid
End Get
Set(value As String)
m_uid = value
End Set
End Property
Private m_uid As String
Public Property status() As String
Get
Return m_status
End Get
Set(value As String)
m_status = value
End Set
End Property
Private m_status As String
Public Property created() As String
Get
Return m_created
End Get
Set(value As String)
m_created = value
End Set
End Property
Private m_created As String
Public Property changed() As String
Get
Return m_changed
End Get
Set(value As String)
m_changed = value
End Set
End Property
Private m_changed As String
Public Property comment() As String
Get
Return m_comment
End Get
Set(value As String)
m_comment = value
End Set
End Property
Private m_comment As String
Public Property promote() As String
Get
Return m_promote
End Get
Set(value As String)
m_promote = value
End Set
End Property
Private m_promote As String
Public Property sticky() As String
Get
Return m_sticky
End Get
Set(value As String)
m_sticky = value
End Set
End Property
Private m_sticky As String
Public Property tnid() As String
Get
Return m_tnid
End Get
Set(value As String)
m_tnid = value
End Set
End Property
Private m_tnid As String
Public Property translate() As String
Get
Return m_translate
End Get
Set(value As String)
m_translate = value
End Set
End Property
Private m_translate As String
Public Property uri() As String
Get
Return m_uri
End Get
Set(value As String)
m_uri = value
End Set
End Property
Private m_uri As String
End Class
C#
protected void Page_Load(object sender, System.EventArgs e)
{
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[15] {
new DataColumn("nid", typeof(int)),
new DataColumn("vid", typeof(int)),
new DataColumn("type", typeof(string)),
new DataColumn("language", typeof(string)),
new DataColumn("title", typeof(string)),
new DataColumn("uid", typeof(int)),
new DataColumn("status", typeof(int)),
new DataColumn("created", typeof(string)),
new DataColumn("changed", typeof(string)),
new DataColumn("comment", typeof(int)),
new DataColumn("promote", typeof(int)),
new DataColumn("sticky", typeof(int)),
new DataColumn("tnid", typeof(int)),
new DataColumn("translate", typeof(int)),
new DataColumn("uri", typeof(string))
});
string url = new System.Net.WebClient().DownloadString("http://kn.tokonusaria.com/testpoint/node.json");
JArray jsonArray = JArray.Parse(url);
for (int i = 0; i < jsonArray.Count; i++)
{
Infos isiData = (new JavaScriptSerializer()).Deserialize<Infos>(jsonArray[i].ToString());
DataRow dr = dt.NewRow();
dr["nid"] = isiData.nid;
dr["vid"] = isiData.vid;
dr["type"] = isiData.type;
dr["language"] = isiData.language;
dr["title"] = isiData.title;
dr["uid"] = isiData.uid;
dr["status"] = isiData.status;
dr["created"] = isiData.created;
dr["changed"] = isiData.changed;
dr["comment"] = isiData.comment;
dr["promote"] = isiData.promote;
dr["sticky"] = isiData.sticky;
dr["tnid"] = isiData.tnid;
dr["translate"] = isiData.translate;
dr["uri"] = isiData.uri;
dt.Rows.Add(dr);
}
if (dt.Rows.Count > 0)
{
//Bind DataTable to your GridView
grdView.DataSource = dt;
grdView.DataBind();
}
}
public class Infos
{
public string nid { get; set; }
public string vid { get; set; }
public string type { get; set; }
public string language { get; set; }
public string title { get; set; }
public string uid { get; set; }
public string status { get; set; }
public string created { get; set; }
public string changed { get; set; }
public string comment { get; set; }
public string promote { get; set; }
public string sticky { get; set; }
public string tnid { get; set; }
public string translate { get; set; }
public string uri { get; set; }
}
Screenshot
Note: Need to select only required column as per your requirement.
