[Newbie] SqlDataReader - What is the best or proper way to gain access to the field value?

[DaBrain]

Many thanks in advance!

....

SqlDataReader reader = cmd.ExecuteReader();
....

Working with:

string mystring;
bool mybool;
int myint;


I see this many ways in examples, what is the best or proper way to
gain access to the field value?


String:
mystring = reader["stringval"].ToString();
mystring = (string)reader["stringval"];


Boolean:
mybool = Convert.ToBoolean(reader["boolfield"].ToString());
mybool = Convert.ToBoolean(reader["boolfield"]);
mybool = (bool)reader["boolfield"];

int:
myint = Convert.ToInt32(reader["intfield"].ToString());
myint = Convert.ToInt32(reader["intfield"]);
myint = (int)reader["intfield"];


Many thanks in advance!

 

[Alexey Smirnov]

Many thanks in advance!

...

SqlDataReader reader = cmd.ExecuteReader();
...

Working with:

string mystring;
bool mybool;
int myint;

I see this many ways in examples, what is the best or proper way to
gain access to the field value?

String:
mystring = reader["stringval"].ToString();
mystring = (string)reader["stringval"];

Boolean:
mybool = Convert.ToBoolean(reader["boolfield"].ToString());
mybool = Convert.ToBoolean(reader["boolfield"]);
mybool = (bool)reader["boolfield"];

int:
myint = Convert.ToInt32(reader["intfield"].ToString());
myint = Convert.ToInt32(reader["intfield"]);
myint = (int)reader["intfield"];

Many thanks in advance!

Convert.ToInt32 could parse from string.

For example, here's a string
myint = Convert.ToInt32(reader["intfield"].ToString());

here's an int
myint = (int)reader["intfield"];

It means use

myint = Convert.ToInt32(reader["intfield"].ToString());
myint = Convert.ToInt32(reader["intfield"]);

for string values

and

myint = (int)reader["intfield"];

for int

The same for others...