How to load Arraylist

Here I load array from data table to array list

public static ArrayList LoadView()
{
DataTable dt = new DataTable();
DataView view = new DataView(dt);
view.RowFilter = (("Name='AD'"));
DataTable dtcopy = view.ToTable("Selected", false, "Row1", "Row2");
var arr = dtcopy.Rows.Cast<DataRow>().Select(r => r.ItemArray).ToArray();
ItemList.Add(arr1);
DataView view2 = new DataView(dt);
view2.RowFilter = (("Name='ProE'"));
DataTable dtcopy2 = view2.ToTable("Selected", false, "Row1", "Row2");
// remove some column from datatable
var arr2 = dtcopy2.Rows.Cast<DataRow>().Select(r => r.ItemArray).ToArray();//Convert datatable to array
//return arr2;
ItemList.Add(arr2);
return Itemlist;
}

Here i have two arrays in my array list.Now i want to append it in a particular array in javascript

Javascript:
PageMethods.LoadView();
function LoadSucc(obj,obj1)//Retur arraylist
{
var goog = [];
goog = obj;
var goog1 = [];
goog1 = obj1;
}

Hope you undestand my problem .Suggest me some ideas to solve my issue

Hi Dinesh,

I am not sure what exactly you are trying to achieve.

I tried to make your code working and tries to serialize the ArrayList to JSON.

I have a table with two columns Code and Name and I added 3 rows to the table. I converted the table to Array and added to ArrayList.

Next I filtered the table and converted the filtered result to Array and added to ArrayList.

var itemList = new ArrayList();
DataTable table = new DataTable();
var column = new DataColumn("Code", typeof(string));
table.Columns.Add(column);
column = new DataColumn("Name", typeof(string));
table.Columns.Add(column);
table.Rows.Add("CH", "Chetan");
table.Rows.Add("RA", "Raj");
table.Rows.Add("PA", "Parth");
var arr1 = table.Rows.Cast().Select(r => r.ItemArray).ToArray();
itemList.Add(arr1);
DataView view2 = new DataView(table);
view2.RowFilter = "Name='Chetan'";
DataTable dtcopy2 = view2.ToTable("Selected", false, "Code", "Name");
// remove some column from datatable
var arr2 = dtcopy2.Rows.Cast().Select(r => r.ItemArray).ToArray();//Convert datatable to array
//return arr2;
itemList.Add(arr2);
var returnValue = JsonConvert.SerializeObject(itemList);

Following is the JSON representation of containing item arrays created from datarows.

[
[
["CH", "Chetan"],
["RA", "Raj"],
["PA", "Parth"]
],
[
["CH", "Chetan"]
]
]

As you notice here it comes as multi- dimensional array and it does not have any column name in it.

IF you are OK with this kind of JSON value then in your JS code you can expect an Array coming from the server and you access the items of the array by using index as following.

function loadSucc(responseObj)
{
responseObj.forEach(function(x, index) {
x.forEach(function(y, index) {
var code = y[0];
var name = y[1];
});
});
}

I hope this will give you some direction around how to approach your problem and solve it.

Thanks and regards,

Chetan Ranpariya

1 Reply

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

Chetan Ranpariya9y ago
Hi Dinesh,

I am not sure what exactly you are trying to achieve.

I tried to make your code working and tries to serialize the ArrayList to JSON.
I have a table with two columns Code and Name and I added 3 rows to the table. I converted the table to Array and added to ArrayList.
Next I filtered the table and converted the filtered result to Array and added to ArrayList.
var itemList = new ArrayList();

DataTable table = new DataTable();
var column = new DataColumn("Code", typeof(string));
table.Columns.Add(column);
column = new DataColumn("Name", typeof(string));
table.Columns.Add(column);

table.Rows.Add("CH", "Chetan");
table.Rows.Add("RA", "Raj");
table.Rows.Add("PA", "Parth");
var arr1 = table.Rows.Cast().Select(r => r.ItemArray).ToArray();
itemList.Add(arr1);

DataView view2 = new DataView(table);
view2.RowFilter = "Name='Chetan'";
DataTable dtcopy2 = view2.ToTable("Selected", false, "Code", "Name");
// remove some column from datatable
var arr2 = dtcopy2.Rows.Cast().Select(r => r.ItemArray).ToArray();//Convert datatable to array
                                                                            //return arr2;
itemList.Add(arr2);

var returnValue = JsonConvert.SerializeObject(itemList);
Following is the JSON representation of containing item arrays created from datarows.
[
    [
        ["CH", "Chetan"],
        ["RA", "Raj"],
        ["PA", "Parth"]
    ],
    [
        ["CH", "Chetan"]
    ]
]
As you notice here it comes as multi- dimensional array and it does not have any column name in it.
IF you are OK with this kind of JSON value then in your JS code you can expect an Array coming from the server and you access the items of the array by using index as following.
function loadSucc(responseObj)
{
    responseObj.forEach(function(x, index) {
        x.forEach(function(y, index) {
            var code = y[0];
            var name = y[1];
        });
    });
}
I hope this will give you some direction around how to approach your problem and solve it.
Thanks and regards,
Chetan Ranpariya