arraylist to datatable

gane kol

Hi,

I have a code that creates a datatable from an arraylist, but i am getting
an error in casting in

for (int intRow = 0; intRow < alLCPlist.Count; intRow++)
{
DataRow drow = dtLCPack.NewRow();
int intColCount = dtLCPack.Columns.Count;
ArrayList arrlRow = (ArrayList)alLCPlist[intRow]; <== Specified cast
is not valid here
for (int intCol=0; intCol < intColCount; intCol++)
{
drow[intCol] = arrlRow[intCol];
}
dtLCPack.Rows.Add(drow);
}
Can someone help me how to fix it?

Thanks
Gane

Karl Seguin

Without seeing what alLCPlist is and how it's populated, it's quite hard to
help. Clearly,alLCPlist doesn't contain arraylists...

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/ - New and Improved (yes, the popup is
annoying)
http://www.openmymind.net/faq.aspx - unofficial newsgroup FAQ (more to
come!)
"gane kol" <ga*****@softca.com> wrote in message
news:O2**************@TK2MSFTNGP12.phx.gbl...

Hi,

I have a code that creates a datatable from an arraylist, but i am getting
an error in casting in

for (int intRow = 0; intRow < alLCPlist.Count; intRow++)
{
DataRow drow = dtLCPack.NewRow();
int intColCount = dtLCPack.Columns.Count;
ArrayList arrlRow = (ArrayList)alLCPlist[intRow]; <== Specified cast is not valid here
for (int intCol=0; intCol < intColCount; intCol++)
{
drow[intCol] = arrlRow[intCol];
}
dtLCPack.Rows.Add(drow);
}
Can someone help me how to fix it?

Thanks
Gane

gane kol

Well, the code before the for loop is
--------
ArrayList alLCPlist = new ArrayList();

DataRow dr;

for (int i=0;i<infoNode.ChildNodes.Count;i++)

{

currentNode = infoNode.ChildNodes[i];

alLCPlist = product.GetLCPack(strvalue,
currentNode.Attributes["Name"].Value.ToString());

if (alLCPlist.Count > 0)

{

------

alLCPlist gets the data returned from the dataaccess layer.
product.GetLCPack returns an arraylist.

"Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net>
wrote in message news:Or**************@TK2MSFTNGP15.phx.gbl...

Without seeing what alLCPlist is and how it's populated, it's quite hard to help. Clearly,alLCPlist doesn't contain arraylists...

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/ - New and Improved (yes, the popup is
annoying)
http://www.openmymind.net/faq.aspx - unofficial newsgroup FAQ (more to
come!)
"gane kol" <ga*****@softca.com> wrote in message
news:O2**************@TK2MSFTNGP12.phx.gbl...
Hi,

I have a code that creates a datatable from an arraylist, but i am getting an error in casting in

for (int intRow = 0; intRow < alLCPlist.Count; intRow++)
{
DataRow drow = dtLCPack.NewRow();
int intColCount = dtLCPack.Columns.Count;
ArrayList arrlRow = (ArrayList)alLCPlist[intRow]; <== Specified

cast
is not valid here
for (int intCol=0; intCol < intColCount; intCol++)
{
drow[intCol] = arrlRow[intCol];
}
dtLCPack.Rows.Add(drow);
}
Can someone help me how to fix it?

Thanks
Gane

Karl Seguin

alLCPList itself is an arraylist, because, as you say, GetLCPack returns an
arraylist...but what does the items within the array list contain?

ArrayList arr = new ArrayList()
arr.Add("1");
arr.Add("2");
arr.Add("3");
string value = (string)arr[1];
ArrayList arr = new ArrayList()
arr.Add(1);
arr.Add(2);
arr.Add(3);
int value = (int)arr[0];

ArrayList arr = new ArrayList()
arr.Add(new DataSet());
arr.Add(new DataSet());
arr.Add(new DataSet());
DataSet value = (DataSet)arr[2];
if you are casting an item of the arraylist to arraylist, than this item
must be an arraylist, ala:

ArrayList arr = new ArrayList()
arr.Add(new ArraList());
arr.Add(new ArraList());
arr.Add(new ArraList());
ArraListvalue = (ArraList)arr[1];
If you are getting an invalid cast, then the items within your alLCPlist
ArrayList aren't embedded ArrayLists..

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/ - New and Improved (yes, the popup is
annoying)
http://www.openmymind.net/faq.aspx - unofficial newsgroup FAQ (more to
come!)
"gane kol" <ga*****@softca.com> wrote in message
news:uI**************@TK2MSFTNGP10.phx.gbl...

Well, the code before the for loop is
--------
ArrayList alLCPlist = new ArrayList();

DataRow dr;

for (int i=0;i<infoNode.ChildNodes.Count;i++)

{

currentNode = infoNode.ChildNodes[i];

alLCPlist = product.GetLCPack(strvalue,
currentNode.Attributes["Name"].Value.ToString());

if (alLCPlist.Count > 0)

{

------

alLCPlist gets the data returned from the dataaccess layer.
product.GetLCPack returns an arraylist.

"Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net>
wrote in message news:Or**************@TK2MSFTNGP15.phx.gbl...
Without seeing what alLCPlist is and how it's populated, it's quite hard

to
help. Clearly,alLCPlist doesn't contain arraylists...

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/ - New and Improved (yes, the popup is
annoying)
http://www.openmymind.net/faq.aspx - unofficial newsgroup FAQ (more to
come!)
"gane kol" <ga*****@softca.com> wrote in message
news:O2**************@TK2MSFTNGP12.phx.gbl...
Hi,

I have a code that creates a datatable from an arraylist, but i am getting an error in casting in

for (int intRow = 0; intRow < alLCPlist.Count; intRow++)
{
DataRow drow = dtLCPack.NewRow();
int intColCount = dtLCPack.Columns.Count;
ArrayList arrlRow = (ArrayList)alLCPlist[intRow]; <== Specified

cast
is not valid here
for (int intCol=0; intCol < intColCount; intCol++)
{
drow[intCol] = arrlRow[intCol];
}
dtLCPack.Rows.Add(drow);
}
Can someone help me how to fix it?

Thanks
Gane

gane kol

Actually i am converting a datareader to arraylist.

----------
arrOracleParams[0] = objDB.BuildOracleParameter("Product",
System.Data.OracleClient.OracleType.VarChar,
ParameterDirection.Input,Product,50);
arrOracleParams[1] = objDB.BuildOracleParameter("Type",
System.Data.OracleClient.OracleType.VarChar,
ParameterDirection.Input,Type,20);
arrOracleParams[2] = objDB.BuildOracleParameter("pCursor",
System.Data.OracleClient.OracleType.Cursor,
ParameterDirection.Output,null,0);
OracleDataReader objOraReader =
objDB.RunExecuteOracleDataReader("pkg_Prod.sp_get_ CP", arrOracleParams);

while (objOraReader.Read())
{

object[] values = new object[objOraReader.FieldCount];

objOraReader.GetValues(values);

alList.Add(values);

}

return alList;

------
"Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net>
wrote in message news:eq**************@TK2MSFTNGP10.phx.gbl...

alLCPList itself is an arraylist, because, as you say, GetLCPack returns an arraylist...but what does the items within the array list contain?

ArrayList arr = new ArrayList()
arr.Add("1");
arr.Add("2");
arr.Add("3");
string value = (string)arr[1];
ArrayList arr = new ArrayList()
arr.Add(1);
arr.Add(2);
arr.Add(3);
int value = (int)arr[0];

ArrayList arr = new ArrayList()
arr.Add(new DataSet());
arr.Add(new DataSet());
arr.Add(new DataSet());
DataSet value = (DataSet)arr[2];
if you are casting an item of the arraylist to arraylist, than this item
must be an arraylist, ala:

ArrayList arr = new ArrayList()
arr.Add(new ArraList());
arr.Add(new ArraList());
arr.Add(new ArraList());
ArraListvalue = (ArraList)arr[1];
If you are getting an invalid cast, then the items within your alLCPlist
ArrayList aren't embedded ArrayLists..

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/ - New and Improved (yes, the popup is
annoying)
http://www.openmymind.net/faq.aspx - unofficial newsgroup FAQ (more to
come!)
"gane kol" <ga*****@softca.com> wrote in message
news:uI**************@TK2MSFTNGP10.phx.gbl...
Well, the code before the for loop is
--------
ArrayList alLCPlist = new ArrayList();

DataRow dr;

for (int i=0;i<infoNode.ChildNodes.Count;i++)

{

currentNode = infoNode.ChildNodes[i];

alLCPlist = product.GetLCPack(strvalue,
currentNode.Attributes["Name"].Value.ToString());

if (alLCPlist.Count > 0)

{

------

alLCPlist gets the data returned from the dataaccess layer.
product.GetLCPack returns an arraylist.

"Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net>
wrote in message news:Or**************@TK2MSFTNGP15.phx.gbl...
Without seeing what alLCPlist is and how it's populated, it's quite hard
to
help. Clearly,alLCPlist doesn't contain arraylists...

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/ - New and Improved (yes, the popup is
annoying)
http://www.openmymind.net/faq.aspx - unofficial newsgroup FAQ (more to
come!)
"gane kol" <ga*****@softca.com> wrote in message
news:O2**************@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> I have a code that creates a datatable from an arraylist, but i am

getting
> an error in casting in
>
> for (int intRow = 0; intRow < alLCPlist.Count; intRow++)
> {
> DataRow drow = dtLCPack.NewRow();
> int intColCount = dtLCPack.Columns.Count;
> ArrayList arrlRow = (ArrayList)alLCPlist[intRow]; <==

Specified cast
> is not valid here
> for (int intCol=0; intCol < intColCount; intCol++)
> {
> drow[intCol] = arrlRow[intCol];
> }
> dtLCPack.Rows.Add(drow);
> }
> Can someone help me how to fix it?
>
> Thanks
> Gane
>
>

Karl Seguin

Looks like you are converting it to an array of objects...which is very
different than an array list.

try

object[] arrlRow = (object[])alLCPlist[intRow];

in the initial code you sent ...

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/ - New and Improved (yes, the popup is
annoying)
http://www.openmymind.net/faq.aspx - unofficial newsgroup FAQ (more to
come!)
"gane kol" <ga*****@softca.com> wrote in message
news:OJ**************@TK2MSFTNGP14.phx.gbl...

Actually i am converting a datareader to arraylist.

----------
arrOracleParams[0] = objDB.BuildOracleParameter("Product",
System.Data.OracleClient.OracleType.VarChar,
ParameterDirection.Input,Product,50);
arrOracleParams[1] = objDB.BuildOracleParameter("Type",
System.Data.OracleClient.OracleType.VarChar,
ParameterDirection.Input,Type,20);
arrOracleParams[2] = objDB.BuildOracleParameter("pCursor",
System.Data.OracleClient.OracleType.Cursor,
ParameterDirection.Output,null,0);
OracleDataReader objOraReader =
objDB.RunExecuteOracleDataReader("pkg_Prod.sp_get_ CP", arrOracleParams);

while (objOraReader.Read())
{

object[] values = new object[objOraReader.FieldCount];

objOraReader.GetValues(values);

alList.Add(values);

}

return alList;

------
"Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net>
wrote in message news:eq**************@TK2MSFTNGP10.phx.gbl...
alLCPList itself is an arraylist, because, as you say, GetLCPack returns

an
arraylist...but what does the items within the array list contain?

ArrayList arr = new ArrayList()
arr.Add("1");
arr.Add("2");
arr.Add("3");
string value = (string)arr[1];
ArrayList arr = new ArrayList()
arr.Add(1);
arr.Add(2);
arr.Add(3);
int value = (int)arr[0];

ArrayList arr = new ArrayList()
arr.Add(new DataSet());
arr.Add(new DataSet());
arr.Add(new DataSet());
DataSet value = (DataSet)arr[2];
if you are casting an item of the arraylist to arraylist, than this item
must be an arraylist, ala:

ArrayList arr = new ArrayList()
arr.Add(new ArraList());
arr.Add(new ArraList());
arr.Add(new ArraList());
ArraListvalue = (ArraList)arr[1];
If you are getting an invalid cast, then the items within your alLCPlist
ArrayList aren't embedded ArrayLists..

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/ - New and Improved (yes, the popup is
annoying)
http://www.openmymind.net/faq.aspx - unofficial newsgroup FAQ (more to
come!)
"gane kol" <ga*****@softca.com> wrote in message
news:uI**************@TK2MSFTNGP10.phx.gbl...
Well, the code before the for loop is
--------
ArrayList alLCPlist = new ArrayList();

DataRow dr;

for (int i=0;i<infoNode.ChildNodes.Count;i++)

{

currentNode = infoNode.ChildNodes[i];

alLCPlist = product.GetLCPack(strvalue,
currentNode.Attributes["Name"].Value.ToString());

if (alLCPlist.Count > 0)

{

------

alLCPlist gets the data returned from the dataaccess layer.
product.GetLCPack returns an arraylist.

"Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net> wrote in message news:Or**************@TK2MSFTNGP15.phx.gbl...
> Without seeing what alLCPlist is and how it's populated, it's quite hard to
> help. Clearly,alLCPlist doesn't contain arraylists...
>
> Karl
>
> --
> MY ASP.Net tutorials
> http://www.openmymind.net/ - New and Improved (yes, the popup is
> annoying)
> http://www.openmymind.net/faq.aspx - unofficial newsgroup FAQ (more to > come!)
> "gane kol" <ga*****@softca.com> wrote in message
> news:O2**************@TK2MSFTNGP12.phx.gbl...
> > Hi,
> >
> > I have a code that creates a datatable from an arraylist, but i am
getting
> > an error in casting in
> >
> > for (int intRow = 0; intRow < alLCPlist.Count; intRow++)
> > {
> > DataRow drow = dtLCPack.NewRow();
> > int intColCount = dtLCPack.Columns.Count;
> > ArrayList arrlRow = (ArrayList)alLCPlist[intRow]; <== Specified > cast
> > is not valid here
> > for (int intCol=0; intCol < intColCount; intCol++)
> > {
> > drow[intCol] = arrlRow[intCol];
> > }
> > dtLCPack.Rows.Add(drow);
> > }
> > Can someone help me how to fix it?
> >
> > Thanks
> > Gane
> >
> >
>
>

gane kol

That works great,
I appreciate that Karl,

Thanks.
Gane

"Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net>
wrote in message news:%2****************@TK2MSFTNGP10.phx.gbl...

Looks like you are converting it to an array of objects...which is very
different than an array list.

try

object[] arrlRow = (object[])alLCPlist[intRow];

in the initial code you sent ...

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/ - New and Improved (yes, the popup is
annoying)
http://www.openmymind.net/faq.aspx - unofficial newsgroup FAQ (more to
come!)
"gane kol" <ga*****@softca.com> wrote in message
news:OJ**************@TK2MSFTNGP14.phx.gbl...
Actually i am converting a datareader to arraylist.

----------
arrOracleParams[0] = objDB.BuildOracleParameter("Product",
System.Data.OracleClient.OracleType.VarChar,
ParameterDirection.Input,Product,50);
arrOracleParams[1] = objDB.BuildOracleParameter("Type",
System.Data.OracleClient.OracleType.VarChar,
ParameterDirection.Input,Type,20);
arrOracleParams[2] = objDB.BuildOracleParameter("pCursor",
System.Data.OracleClient.OracleType.Cursor,
ParameterDirection.Output,null,0);
OracleDataReader objOraReader =
objDB.RunExecuteOracleDataReader("pkg_Prod.sp_get_ CP", arrOracleParams);

while (objOraReader.Read())
{

object[] values = new object[objOraReader.FieldCount];

objOraReader.GetValues(values);

alList.Add(values);

}

return alList;

------
"Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net>
wrote in message news:eq**************@TK2MSFTNGP10.phx.gbl...
alLCPList itself is an arraylist, because, as you say, GetLCPack returns
an
arraylist...but what does the items within the array list contain?

ArrayList arr = new ArrayList()
arr.Add("1");
arr.Add("2");
arr.Add("3");
string value = (string)arr[1];
ArrayList arr = new ArrayList()
arr.Add(1);
arr.Add(2);
arr.Add(3);
int value = (int)arr[0];

ArrayList arr = new ArrayList()
arr.Add(new DataSet());
arr.Add(new DataSet());
arr.Add(new DataSet());
DataSet value = (DataSet)arr[2];
if you are casting an item of the arraylist to arraylist, than this
item must be an arraylist, ala:

ArrayList arr = new ArrayList()
arr.Add(new ArraList());
arr.Add(new ArraList());
arr.Add(new ArraList());
ArraListvalue = (ArraList)arr[1];
If you are getting an invalid cast, then the items within your alLCPlist ArrayList aren't embedded ArrayLists..

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/ - New and Improved (yes, the popup is
annoying)
http://www.openmymind.net/faq.aspx - unofficial newsgroup FAQ (more to
come!)
"gane kol" <ga*****@softca.com> wrote in message
news:uI**************@TK2MSFTNGP10.phx.gbl...
> Well, the code before the for loop is
> --------
> ArrayList alLCPlist = new ArrayList();
>
> DataRow dr;
>
> for (int i=0;i<infoNode.ChildNodes.Count;i++)
>
> {
>
> currentNode = infoNode.ChildNodes[i];
>
> alLCPlist = product.GetLCPack(strvalue,
> currentNode.Attributes["Name"].Value.ToString());
>
> if (alLCPlist.Count > 0)
>
> {
>
> ------
>
> alLCPlist gets the data returned from the dataaccess layer.
> product.GetLCPack returns an arraylist.
>
>
>
> "Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net> > wrote in message news:Or**************@TK2MSFTNGP15.phx.gbl...
> > Without seeing what alLCPlist is and how it's populated, it's quite hard
> to
> > help. Clearly,alLCPlist doesn't contain arraylists...
> >
> > Karl
> >
> > --
> > MY ASP.Net tutorials
> > http://www.openmymind.net/ - New and Improved (yes, the popup is
> > annoying)
> > http://www.openmymind.net/faq.aspx - unofficial newsgroup FAQ
(more
to > > come!)
> > "gane kol" <ga*****@softca.com> wrote in message
> > news:O2**************@TK2MSFTNGP12.phx.gbl...
> > > Hi,
> > >
> > > I have a code that creates a datatable from an arraylist, but i

am > getting
> > > an error in casting in
> > >
> > > for (int intRow = 0; intRow < alLCPlist.Count; intRow++)
> > > {
> > > DataRow drow = dtLCPack.NewRow();
> > > int intColCount = dtLCPack.Columns.Count;
> > > ArrayList arrlRow = (ArrayList)alLCPlist[intRow]; <==

Specified
> > cast
> > > is not valid here
> > > for (int intCol=0; intCol < intColCount; intCol++)
> > > {
> > > drow[intCol] = arrlRow[intCol];
> > > }
> > > dtLCPack.Rows.Add(drow);
> > > }
> > > Can someone help me how to fix it?
> > >
> > > Thanks
> > > Gane
> > >
> > >
> >
> >
>
>

arraylist to datatable

This discussion thread is closed

Similar topics