Smart DataReader!!

[Vai2000]

Hi All, Whenever I use the SqlDataReader I have to retrieve a column by its
OrdinalPosition can't I do something like this

using(SqlDataRedaer sr=SqlHelper.ExecuteReader(....))
{
while(sr.Read())
string x=sr.GetValue("Column1").ToString();
// right now I have to do sr.GetValue(1).ToString();
}

TIA

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

"Vai2000" <no****@microsoft.comwrote in message
news:u2****************@TK2MSFTNGP06.phx.gbl...
| Hi All, Whenever I use the SqlDataReader I have to retrieve a column by
its
| OrdinalPosition can't I do something like this
|
| using(SqlDataRedaer sr=SqlHelper.ExecuteReader(....))
| {
| while(sr.Read())
| string x=sr.GetValue("Column1").ToString();
| // right now I have to do sr.GetValue(1).ToString();
| }

try sr["Column1"]

Regarding the ToString() or in general converting the readed field to the
final type you have to do it always. The reason is that the indexer return
an object wich you need to cast (or convert) to your intended type.
--
Ignacio Machin
machin AT laceupsolutions com