Get One Value From DataTable

[Jordan Richard]

I'm just wondering if there is a faster way (better performance or fewer
lines of code) to retrieve one single value from a DataRow.

Here is what I'm currently doing when I just need a single integer value
from the DataRow:

int someID = 0;
if (DT.Rows.Count == 1) {
DataRow DR;
DR = DT.Rows[0];
someID= Convert.ToInt32(DR["SomeID"]);
}


Please note that I'm not using ExecuteScalar to retrieve one single value
from the underlying data source because I'm using many other columns in that
DataRow elsewhere in the same method.

Thanks!

 

[Jim Hughes]

No need to create the DR object if you are not going to use it more than
once.

int someID = 0;
if (DT.Rows.Count == 1) {
someID= Convert.ToInt32(DT.Rows[0]["SomeID"]);
}

 

[James Curran]

But, he's not actually creating a DR object --- he's just briefly
storing a reference to one which already exists. In fact, the compiler
would probably generate identical IL for both versions.

--
--
Truth,
James Curran
[erstwhile VC++ MVP]

Home: www.noveltheory.com Work: www.njtheater.com
Blog: www.honestillusion.com Day Job: www.partsearch.com