Hi everybody,
I have a .NET question:
I've created a disconnected OleDb.DataSet. After that I filled in the DataTable for this DataSet using OleDb.DataAdapter. Than, I would like to read some data from some fields in this DataTable. How to get the field value without using DataReader? I am trying to use collections (first table (index 0) in the Tables collection and column (index 11) in the Columns collection:
myVariable = myDataSet.Tables(0).Columns(11).ToString, it returns the column name. How to get the actual value from the column? I could not find any example on the WEB and Microsoft Help.
Any ideas?

Thanks
-Dmitriy.;)

just try this

in VB.NET
variable as String=DataSet.Table(0).Rows(index)(column-index).ToString();

in C#.NET

string variable=DataSet.Table[0].Rows[index][column-index].ToString();

Example:

string name=DataSet.Table[0].Rows[3][2].ToString();


hope this help you.

best regards.

I get the following error when I try your advice:
Error 1 Cannot apply indexing with [] to an expression of type 'System.Data.DataTable'

Why would you post your .NET question in the VB6 forum?

DataTable class in .Net supports the calculation of a column by getting the values from other columns.

That means lets say I have a DataTable as dtItems which is having three columns ItemName, Price, Quantity ,if I need to add another column as Total and the calculated value for this column will be Price* Quantity , this can be done easily without looping through all the rows, it will be automatically calculated during runtime " dtItems.Columns.Add("Total", typeof(int), "Price*Quantity"); ".

__________________
Cheers,
Eliza

Mindfire: India's Only Company to be both Apple Premier & Microsoft Gold certified.