fill an array from a dataset

gmk51080 · November 29th, 2004, 03:24 PM

HI
i have a data filled in a dataset
is there any possibility in asp.net to fill this array from this dataset and how?

thanks

Georges M. Kaddoum

mehdi62b · November 30th, 2004, 09:20 AM

Hello,
I didnt get your meaning exactly but every DataRow object in DataSet has a property called ItemArray ... I think you can use it,

Code:

DateRow dr=objDataSet.Tables[i].Rows[j];
object[] temp=dr.ItemArray;
DateTime dt=(System.DateTime)temp[0];
//Thought first column represents a date

There is a table map between Sql datatype and .NET data type so you should cast elements of ItemArray according to this table-mapping,
for example,
nvarchar(sql)---------->System.string(.NET)
datetime(sql)---------->System.DateTime(.NET)
Money(sql)---------->System.Decimal(.NET)
HtH.

_____________________________
Mehdi.
software engineering student.
Looking for a good job for summer 2005.