Load data table to array and return array using Jquery

Dinesh Santhalingam

9y1.3kVisual Basic .NET

[System.Web.Services.WebMethod]
public Array loaddata()
string sql = "SELECT Name,Time,Inuse FROM table4";
using (SqlConnection Connection = new SqlConnection((@"Data Source)))
{
using (SqlCommand myCommand = new SqlCommand(sql, Connection))
{
Connection.Open();
using (SqlDataReader myReader = myCommand.ExecuteReader())
{
DataTable dt = new DataTable();
dt.Load(myReader);
Connection.Close();
DataView dv = new DataView(dt);
dv.RowFilter = (("Name='ACVX'"));
var tableEnumerable = dv.ToTable().AsEnumerable();
var tableArray = tableEnumerable.ToArray();
return tableArray ;
}
}
}
}

//Front End
<html>
<head/>
<script>
PageMethods.loaddata(LoadSucc, LoadFail);
function LoadSucc(obj) //obj is array returned from back end{obj-tablearray]
{
var goog = [];
goog = Object.values(obj);
//I want load the obj into my array goog.
}
function LoadFail() {
alert("Data missing");
}
script>
<body/>
html>

I want to Load my data table content to array and return array to front end using page methods..Suggest me some ideas..

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Midhun Tp9y ago
Hi,

Try below code -

var tableArray = dt.Rows.Cast().Select(r => r.ItemArray).ToArray();
return tableArray;

function OnSuccess(obj) {
var goog = [];
goog = obj;
}
sudipta sanyal9y ago
Hi
I am sending you full project, Its works fine for me. I am using 2013 and version 4.0
Dinesh Santhalingam9y ago
Yea am using that name space but the error populating..
sudipta sanyal9y ago
You Need To used
```
using System.Linq;
```
Dinesh Santhalingam9y ago
Error 'System.Data.DataRowCollection' does not contain a definition for 'Cast' and no extension method 'Cast' accepting a first argument of type 'System.Data.DataRowCollection' could be found (are you missing a using directive or an assembly reference?)
@
sudipta sanyal
sudipta sanyal9y ago
Try this

[System.Web.Services.WebMethod]
public static Array loaddata()
{
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[3] { new DataColumn("Id", typeof(int)),
new DataColumn("Name", typeof(string)),
new DataColumn("Country",typeof(string)) });
dt.Rows.Add(1, "John Hammond", "United States");
dt.Rows.Add(2, "Mudassar Khan", "India");
dt.Rows.Add(3, "Suzanne Mathews", "France");
dt.Rows.Add(4, "Robert Schidner", "Russia");
var arr = dt.Rows.Cast().Select(r => r.ItemArray).ToArray();
return arr;
}
Chetan Ranpariya9y ago
Hi Dinesh,

To me it looks like the JSON Serialization of Array of DataRow is not happening.

I tried replicating this use case at my end and it gave me following exception

A circular reference was detected while serializing an object of type 'System.Reflection.RuntimeModule'.
My recommendation would be to create a custom class with properties Name, Time and InUse to store the data which you want to return to UI. Create object of that classe and populate the properties of that object from the data rows and create array of those objects and return them as JSON object from the server to the UI.
Thanks and regards,
Chetan Ranpariya

Load data table to array and return array using Jquery

sudipta sanyal

A circular reference was detected while serializing an object of type 'System.Reflection.RuntimeModule'.