By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,065 Members | 1,560 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,065 IT Pros & Developers. It's quick & easy.

Dataset question

P: n/a
how to assign data from a dataset to an array or other variables?
how to address data, contaning in dataset.
I know it is organized in row, but how to work with them?
Nov 21 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
dataset.tables("tableName").Rows(rownumber)(column Number)
dataset.tables("tableName").Rows(rownumber)("Colum nName"))

dim datarow as new datarow = dataset.tables("tableName").Rows(number)
messagebox.show (datarow(columnNumber)
messagebox.show (datarow("columnName"))

Hope this helps,

Jason

On Thu, 19 Aug 2004 10:06:26 +0300, "Nikolay Petrov"
<jo******@mail.bg> wrote:
how to assign data from a dataset to an array or other variables?
how to address data, contaning in dataset.
I know it is organized in row, but how to work with them?


Nov 21 '05 #2

P: n/a
Hi,
Datasets contain one or more DataTables which in turn contain DataRows. To
access a specific row in a table, follow this hierarchy.

DataSet.Tables(0).Rows(0)("ColumnName") -- gives the value of column
"ColumnName" in the first row (0-based indexing) of the first table in the
given dataset.

Also, check MSDN for DataSet topic. It contains plenty of info on
manipulating/accessing datasets.

Hope this helps.

"Nikolay Petrov" <jo******@mail.bg> wrote in message
news:#E**************@TK2MSFTNGP09.phx.gbl...
how to assign data from a dataset to an array or other variables?
how to address data, contaning in dataset.
I know it is organized in row, but how to work with them?

Nov 21 '05 #3

P: n/a
Thanks guys
I am sure that MSDN contains all the info
Just i don't have the time ;-)

tnx again

Nov 21 '05 #4

P: n/a
Hi Shiva,
DataSet.Tables(0).Rows(0)("ColumnName") -- gives the value of column
"ColumnName" in the first row (0-based indexing) of the first table in the
given dataset.

I am sure you know this, however I think that this can give
misunderstandings.

In my opinion it has to be "gives the value of Item". That because the
distinct between a column and an item in a datatable is for a lot of newbies
mostly difficult to see.

Only for the next time.

:-)

Cor
Nov 21 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.