How to convert a Collection arraylist to dataset

[mimi]

I would like to convert an arraylist to dataset or datatable so that I can
filter or make a select distinct from it. How to do it? Can someone show
me the syntax? Thanks

[Alvin Bruney [MVP]]

how about this:

DataSet dsTemp = new DataSet();
DataTable Tables = new DataTable();
dsTemp.Tables.Add(Tables);

dsTemp.Tables[0].Columns.Add( "val", System.Type.GetType(
"System.String" ) );

foreach(string str in arraylistcontainer)
{

if(str != string.Empty)
{
DataRow myRow = dsTemp.Tables[0].NewRow();
myRow[0]= str;
dsTemp.Tables[0].Rows.Add(myRow);
}

roughly

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
"mimi" <mh****@hotmail.com> wrote in message
news:uD**************@TK2MSFTNGP11.phx.gbl...

I would like to convert an arraylist to dataset or datatable so that I can
filter or make a select distinct from it. How to do it? Can someone show
me the syntax? Thanks

[Mimi]

Thanks Alvin
"Alvin Bruney [MVP]" <vapor at steaming post office> wrote in message news:<#8**************@TK2MSFTNGP11.phx.gbl>...

how about this:

DataSet dsTemp = new DataSet();
DataTable Tables = new DataTable();
dsTemp.Tables.Add(Tables);

dsTemp.Tables[0].Columns.Add( "val", System.Type.GetType(
"System.String" ) );

foreach(string str in arraylistcontainer)
{

if(str != string.Empty)
{
DataRow myRow = dsTemp.Tables[0].NewRow();
myRow[0]= str;
dsTemp.Tables[0].Rows.Add(myRow);
}

roughly

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
"mimi" <mh****@hotmail.com> wrote in message
news:uD**************@TK2MSFTNGP11.phx.gbl...

I would like to convert an arraylist to dataset or datatable so that I can
filter or make a select distinct from it. How to do it? Can someone show
me the syntax? Thanks