How do You Get a Specific Value From a System.Data.DataTable Object?
I'm a low-level algorithm programmer, and databases are not really my thing - so this'll be a n00b question if ever there was one.
I'm running a simple SELECT query through our development team's DAO. The DAO returns a System.Data.DataTable object containing the results of the query. This is all working fine so far.
The problem I have run into now:
I need to pull a value out of one of the fields of the first row in the resulting DataTable - and I have no idea where to even start. Microsoft is so confusing about this! Arrrg!
Any advice would be appreciated. I'm not providing any code samples, because I believe that context is unnecessary here. I'm assuming that all DataTable objects work the same way, no matter how you run your queries - and therefore any additional information would just make this more confusing for everyone.
Answer
Just the basics....
yourDataTable.Rows[ndx][column]
where ndx is the row number (starting at 0) where column can be a DataColumn object, an index (column n), or the name of the column (a string)
yourDataTable.Rows[0][0]
yourDataTable.Rows[0][ColumObject]
yourDataTable.Rows[0]["ColumnName"]
to test for null, compare to DBNull.Value;