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(SqlDataRe daer sr=SqlHelper.Ex ecuteReader(... .))
{
while(sr.Read() )
string x=sr.GetValue(" Column1").ToStr ing();
// right now I have to do sr.GetValue(1). ToString();
}

TIA

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

Hi,

"Vai2000" <no****@microso ft.comwrote in message
news:u2******** ********@TK2MSF TNGP06.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(SqlDataRe daer sr=SqlHelper.Ex ecuteReader(... .))
| {
| while(sr.Read() )
| string x=sr.GetValue(" Column1").ToStr ing();
| // 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