Novice question: Which method should I use to read individual data? ?

sanny7696

For example, I put some website information in a table, put one information in each field, and there is only one record in total

Excuse me, which of the following methods is better when reading? ? Or is there another way? ? Please advise

One:
datareader ["field"]. ToString ();

two:
dataset.Table ["tab"]. Rows [0] ["field"]

shenmue024

datareader is more efficient.

shenmue024

If only one field is available
cmd.ExecuteScalar

3521565

Of course the first is more efficient

zhoujiyuxs

If there is only one row in the table, why should we create a table? By design it fails. If you have to read, in theory, the reader is fast, but you only have the same, so it is the same, so there is no difference.

zhengminglin

If you just read and do nothing else, it is recommended to use datareader.

jys5090

Use the first datareader ["field"]. ToString ();