DataTable Reading.....

[Pete Smith]

What is the syntax to read the data from a DataTable by row # and (column #
or name)?

..Net Framework 1.1 and VB.Net.

I have the below code from documentation

For Each thisTable In myDataSet.Tables
' For each row, print the values of each column.
Dim myRow As DataRow
For Each myRow In thisTable.Rows
Dim myCol As DataColumn
For Each myCol In thisTable.Columns
Console.WriteLine(myRow(myCol))
Next myCol
Next myRow
Next thisTable

But I wanted read the datatable data by referencing as above specified.

Thank you,

-Pete

[Chris]

Pete Smith wrote:

What is the syntax to read the data from a DataTable by row # and (column #
or name)?

.Net Framework 1.1 and VB.Net.

I have the below code from documentation

For Each thisTable In myDataSet.Tables
' For each row, print the values of each column.
Dim myRow As DataRow
For Each myRow In thisTable.Rows
Dim myCol As DataColumn
For Each myCol In thisTable.Columns
Console.WriteLine(myRow(myCol))
Next myCol
Next myRow
Next thisTable

But I wanted read the datatable data by referencing as above specified.

Thank you,

-Pete

For Each thisTable In myDataSet.Tables
' For each row, print the values of each column.
Dim myRow As DataRow
For Each myRow In thisTable.Rows
Dim myCol As DataColumn
For ii as integer = 0 to thisTable.Columns -1
Console.WriteLine(myRow(ii))
Next myCol
Next myRow
Next thisTable

[Chris]

Chris wrote:

Pete Smith wrote:

What is the syntax to read the data from a DataTable by row # and
(column #
or name)?

.Net Framework 1.1 and VB.Net.

I have the below code from documentation

For Each thisTable In myDataSet.Tables
' For each row, print the values of each column.
Dim myRow As DataRow
For Each myRow In thisTable.Rows
Dim myCol As DataColumn
For Each myCol In thisTable.Columns
Console.WriteLine(myRow(myCol))
Next myCol
Next myRow
Next thisTable

But I wanted read the datatable data by referencing as above specified.

Thank you,

-Pete

For Each thisTable In myDataSet.Tables
' For each row, print the values of each column.
Dim myRow As DataRow
For Each myRow In thisTable.Rows
Dim myCol As DataColumn
For ii as integer = 0 to thisTable.Columns -1
Console.WriteLine(myRow(ii))
Next myCol
Next myRow
Next thisTable

Oh, and your way doesn't work because a MyRow object does not contain a
DataColumn. Only the datatable contains a column object.

Chris

[Pete Smith]

Thank you for the reply. But it did not answer my question fully.
-Pete
"Chris" <[e-mail]> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

Chris wrote:

Pete Smith wrote:

What is the syntax to read the data from a DataTable by row # and
(column #
or name)?

.Net Framework 1.1 and VB.Net.

I have the below code from documentation

For Each thisTable In myDataSet.Tables
' For each row, print the values of each column.
Dim myRow As DataRow
For Each myRow In thisTable.Rows
Dim myCol As DataColumn
For Each myCol In thisTable.Columns
Console.WriteLine(myRow(myCol))
Next myCol
Next myRow
Next thisTable

But I wanted read the datatable data by referencing as above specified.

Thank you,

-Pete

For Each thisTable In myDataSet.Tables
' For each row, print the values of each column.
Dim myRow As DataRow
For Each myRow In thisTable.Rows
Dim myCol As DataColumn
For ii as integer = 0 to thisTable.Columns -1
Console.WriteLine(myRow(ii))
Next myCol
Next myRow
Next thisTable

Oh, and your way doesn't work because a MyRow object does not contain a
DataColumn. Only the datatable contains a column object.

Chris

[Chris]

Pete Smith wrote:

Thank you for the reply. But it did not answer my question fully.
-Pete
"Chris" <[e-mail]> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

Chris wrote:

Pete Smith wrote:
What is the syntax to read the data from a DataTable by row # and
(column #
or name)?

.Net Framework 1.1 and VB.Net.

I have the below code from documentation

For Each thisTable In myDataSet.Tables
' For each row, print the values of each column.
Dim myRow As DataRow
For Each myRow In thisTable.Rows
Dim myCol As DataColumn
For Each myCol In thisTable.Columns
Console.WriteLine(myRow(myCol))
Next myCol
Next myRow
Next thisTable

But I wanted read the datatable data by referencing as above specified.

Thank you,

-Pete

For Each thisTable In myDataSet.Tables
' For each row, print the values of each column.
Dim myRow As DataRow
For Each myRow In thisTable.Rows
Dim myCol As DataColumn
For ii as integer = 0 to thisTable.Columns -1
Console.WriteLine(myRow(ii))
Next myCol
Next myRow
Next thisTable

Oh, and your way doesn't work because a MyRow object does not contain a
DataColumn. Only the datatable contains a column object.

Chris

What wasn't answered?

[Pete Smith]

Is there anyway I can read cell(x,y) in the DataTable?
Thank you,
-Pete

"Chris" <[e-mail]> wrote in message
news:e9**************@TK2MSFTNGP10.phx.gbl...

Pete Smith wrote:

Thank you for the reply. But it did not answer my question fully.
-Pete
"Chris" <[e-mail]> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

Chris wrote:

Pete Smith wrote:
>What is the syntax to read the data from a DataTable by row # and
>(column #
>or name)?
>
>.Net Framework 1.1 and VB.Net.
>
>I have the below code from documentation
>
>
>
>For Each thisTable In myDataSet.Tables
> ' For each row, print the values of each column.
> Dim myRow As DataRow
> For Each myRow In thisTable.Rows
> Dim myCol As DataColumn
> For Each myCol In thisTable.Columns
> Console.WriteLine(myRow(myCol))
> Next myCol
> Next myRow
> Next thisTable
>
>But I wanted read the datatable data by referencing as above specified.>
>
>
>Thank you,
>
>-Pete
>
>

For Each thisTable In myDataSet.Tables
' For each row, print the values of each column.
Dim myRow As DataRow
For Each myRow In thisTable.Rows
Dim myCol As DataColumn
For ii as integer = 0 to thisTable.Columns -1
Console.WriteLine(myRow(ii))
Next myCol
Next myRow
Next thisTable
Oh, and your way doesn't work because a MyRow object does not contain a
DataColumn. Only the datatable contains a column object.

Chris

What wasn't answered?

[Chris]

Pete Smith wrote:

Is there anyway I can read cell(x,y) in the DataTable?
Thank you,
-Pete

"Chris" <[e-mail]> wrote in message
news:e9**************@TK2MSFTNGP10.phx.gbl...

Pete Smith wrote:

Thank you for the reply. But it did not answer my question fully.
-Pete
"Chris" <[e-mail]> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl. ..
Chris wrote:
>Pete Smith wrote:
>
>
>
>>What is the syntax to read the data from a DataTable by row # and
>>(column #
>>or name)?
>>
>>.Net Framework 1.1 and VB.Net.
>>
>>I have the below code from documentation
>>
>>
>>
>>For Each thisTable In myDataSet.Tables
>> ' For each row, print the values of each column.
>> Dim myRow As DataRow
>> For Each myRow In thisTable.Rows
>> Dim myCol As DataColumn
>> For Each myCol In thisTable.Columns
>> Console.WriteLine(myRow(myCol))
>> Next myCol
>> Next myRow
>> Next thisTable
>>
>>But I wanted read the datatable data by referencing as above
specified.

>>
>>Thank you,
>>
>>-Pete
>>
>>
>
>For Each thisTable In myDataSet.Tables
>' For each row, print the values of each column.
> Dim myRow As DataRow
> For Each myRow In thisTable.Rows
> Dim myCol As DataColumn
> For ii as integer = 0 to thisTable.Columns -1
> Console.WriteLine(myRow(ii))
> Next myCol
> Next myRow
>Next thisTable
Oh, and your way doesn't work because a MyRow object does not contain a
DataColumn. Only the datatable contains a column object.

Chris

What wasn't answered?

My example just showed you how to read every cell in the datatable.

To be more exact:
myDataSet.Tables(Z).Rows(Y).Item(X)

Chris

[Pete Smith]

Thank you,
-Pete

"Chris" <[e-mail]> wrote in message
news:u$**************@TK2MSFTNGP12.phx.gbl...

Pete Smith wrote:

Is there anyway I can read cell(x,y) in the DataTable?
Thank you,
-Pete

"Chris" <[e-mail]> wrote in message
news:e9**************@TK2MSFTNGP10.phx.gbl...

Pete Smith wrote:

Thank you for the reply. But it did not answer my question fully.
-Pete
"Chris" <[e-mail]> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl. ..
>Chris wrote:
>
>
>>Pete Smith wrote:
>>
>>
>>
>>>What is the syntax to read the data from a DataTable by row # and
>>>(column #
>>>or name)?
>>>
>>>.Net Framework 1.1 and VB.Net.
>>>
>>>I have the below code from documentation
>>>
>>>
>>>
>>>For Each thisTable In myDataSet.Tables
>>> ' For each row, print the values of each column.
>>> Dim myRow As DataRow
>>> For Each myRow In thisTable.Rows
>>> Dim myCol As DataColumn
>>> For Each myCol In thisTable.Columns
>>> Console.WriteLine(myRow(myCol))
>>> Next myCol
>>> Next myRow
>>> Next thisTable
>>>
>>>But I wanted read the datatable data by referencing as above

specified.

>>>
>>>
>>>Thank you,
>>>
>>>-Pete
>>>
>>>
>>
>>For Each thisTable In myDataSet.Tables
>>' For each row, print the values of each column.
>> Dim myRow As DataRow
>> For Each myRow In thisTable.Rows
>> Dim myCol As DataColumn
>> For ii as integer = 0 to thisTable.Columns -1
>> Console.WriteLine(myRow(ii))
>> Next myCol
>> Next myRow
>>Next thisTable
>
>
>Oh, and your way doesn't work because a MyRow object does not contain a>DataColumn. Only the datatable contains a column object.
>
>Chris

What wasn't answered?

My example just showed you how to read every cell in the datatable.

To be more exact:
myDataSet.Tables(Z).Rows(Y).Item(X)

Chris