Is there a way to get a column by name instead of ordinal?

[needin4mation]

Hi, using C#, I have to do this to get the database columns in a
reader. Can it be done in one step?:
OdbcCommand command = new OdbcCommand(sql SelectPersonal, conn);
OdbcDataReader PerReader = command.Execute Reader();

while (PerReader.Read ())
{
int address_id = PerReader.GetOr dinal("address_ id");
int picture_id = PerReader.GetOr dinal("picture_ id");
int last_name = PerReader.GetOr dinal("last_nam e");
int first_name = PerReader.GetOr dinal("first_na me");
int middle_name = PerReader.GetOr dinal("middle_n ame");

txtLastName.Tex t = PerReader.GetSt ring(last_name) .ToString();
txtFirstName.Te xt = PerReader.GetSt ring(first_name ).ToString();
txtMiddleName.T ext = PerReader.GetSt ring(middle_nam e).ToString();
//GetInt32 because it is a number
txtAddressID.Te xt = PerReader.GetIn t32(address_id) .ToString();
}

In VB.NET I did it all in one step like this:

While myReader.Read()
if not IsDBNull(myRead er.Item("prodNu mber")) then
txtProduct.text = myReader.Item(" prodNumber")
end if
Also, do you know how to do the IsDBNull test in C# like this VB.NET
above? Thank you for your time.

[Marina]

If you can index by name in VB, you can index by name in C# too. It is the
exact same class you are using.

You can check if an object equals to DBNull.Value, which is the equivalent
of calling the IsDBNull function.

<ne***********@ gmail.com> wrote in message
news:11******** **************@ g49g2000cwa.goo glegroups.com.. .

Hi, using C#, I have to do this to get the database columns in a
reader. Can it be done in one step?:
OdbcCommand command = new OdbcCommand(sql SelectPersonal, conn);
OdbcDataReader PerReader = command.Execute Reader();

while (PerReader.Read ())
{
int address_id = PerReader.GetOr dinal("address_ id");
int picture_id = PerReader.GetOr dinal("picture_ id");
int last_name = PerReader.GetOr dinal("last_nam e");
int first_name = PerReader.GetOr dinal("first_na me");
int middle_name = PerReader.GetOr dinal("middle_n ame");

txtLastName.Tex t = PerReader.GetSt ring(last_name) .ToString();
txtFirstName.Te xt = PerReader.GetSt ring(first_name ).ToString();
txtMiddleName.T ext = PerReader.GetSt ring(middle_nam e).ToString();
//GetInt32 because it is a number
txtAddressID.Te xt = PerReader.GetIn t32(address_id) .ToString();
}

In VB.NET I did it all in one step like this:

While myReader.Read()
if not IsDBNull(myRead er.Item("prodNu mber")) then
txtProduct.text = myReader.Item(" prodNumber")
end if
Also, do you know how to do the IsDBNull test in C# like this VB.NET
above? Thank you for your time.

[needin4mation]

There is no myReader.Item in C# like in VB.NET that I can find. Maybe
it is called something else?

[Marina]

You can index directly into it:

myReader["myCol"]

In VB this would be:

myReader("myCol ")

The Item thing is because VB doesn't support indexers in the same way as C#.
So they defined a default property named Item. But in C# you have the
concept of an indexer.

<ne***********@ gmail.com> wrote in message
news:11******** **************@ z14g2000cwz.goo glegroups.com.. .

There is no myReader.Item in C# like in VB.NET that I can find. Maybe
it is called something else?

[needin4mation]

Thanks I was able to do this:

txtLastName.Tex t = (string)PerRead er["last_name"];