Accessing specific columns of a datatable

Question

I want to use specific cells of each row of a datatable.

 

I tried  following in C# :

DataTable.Rows[Index].Column[Index]

but failed. Can you please help ?

 

Answer 1

Hello, it is recommended to use Entity Framework to work with database. DataSet should only be used for backward compatibility. In addition, your question has nothing to do with WCF. If you have to use DataSet, please post the question on http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataset/threads.

---

Lante, shanaolanxing This posting is provided "AS IS" with no warranties, and confers no rights.
If you have feedback about forum business, please contact [e-mail]. But please do not ask technical questions in the email.

Answer 2

The Syntax is,

DataTable.Rows[Index].[Index]

For prompt response of any Ado.net specific question please use

http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataset/threads.

---

Lingaraj Mishra

Answer 3

When you say "Failed" what do you mean?  If you got an IndexOutOfRangeException then it's likely b/c there aren't any rows or you're looking past the # of rows/columns.  You can just use a simplified syntax though - DataTableName.Rows[RowIndex][ColumnIndex].  You'll likely want to cast the value to whatever type you're expecting, and you'll want to check for Null just to be completely safe but that should do it for you unless I'm misunderstanding the question.

---

Cordially, W.G.Ryan - www.williamgryan.mobi