We help IT Professionals succeed at work.
Get Started

data tables and data sets - single items

BillWhelan333
on
153 Views
Last Modified: 2010-04-23
Hey,
A few dumb questions, but something that will help me out alot.

how do i get just a single value out of a data table (or dataset)?
(not looping through the data table..)

say - if i wanted the item from the fourth row  in the fifth column?

also, if i wanted all the values in the 5 fifth row of the datatable,
or if i wanted alll the values in the sixth column for all the rows?

AND...
one more...

i have loaded values from about 6 tables from a database into datatables, each database table corresponding to each data table
Now... i need to do some queries - like  - Selecting different fields from diffenent rows and columns according to results from another query - they are nothing to compicated at all, just getting generally one or two values from one table matching/checking it to another and then inserting somewhere else..

Should / can i do this with data tables - if i load data from a database (as i have mentioned above) can i then do rather select statements to grab info from them and then add to another datatable to update the database after all queries have been done...

in other words, is it possible to use data tables and close the connection to the database and do fitering, selecting and updating (and in some cases complex select statements) from/ to the data tables, then reinsert...
or do i have to use SQL select statements keeping the database connection open?


Please help me, i am in urgent need..
many thanks,
Bill
Comment
Watch Question
Top Expert 2004
Commented:
This problem has been solved!
Unlock 1 Answer and 1 Comment.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE