N
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(sqlSelectPersonal, conn);
OdbcDataReader PerReader = command.ExecuteReader();
while (PerReader.Read())
{
int address_id = PerReader.GetOrdinal("address_id");
int picture_id = PerReader.GetOrdinal("picture_id");
int last_name = PerReader.GetOrdinal("last_name");
int first_name = PerReader.GetOrdinal("first_name");
int middle_name = PerReader.GetOrdinal("middle_name");
txtLastName.Text = PerReader.GetString(last_name).ToString();
txtFirstName.Text = PerReader.GetString(first_name).ToString();
txtMiddleName.Text = PerReader.GetString(middle_name).ToString();
//GetInt32 because it is a number
txtAddressID.Text = PerReader.GetInt32(address_id).ToString();
}
In VB.NET I did it all in one step like this:
While myReader.Read()
if not IsDBNull(myReader.Item("prodNumber")) 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.
reader. Can it be done in one step?:
OdbcCommand command = new OdbcCommand(sqlSelectPersonal, conn);
OdbcDataReader PerReader = command.ExecuteReader();
while (PerReader.Read())
{
int address_id = PerReader.GetOrdinal("address_id");
int picture_id = PerReader.GetOrdinal("picture_id");
int last_name = PerReader.GetOrdinal("last_name");
int first_name = PerReader.GetOrdinal("first_name");
int middle_name = PerReader.GetOrdinal("middle_name");
txtLastName.Text = PerReader.GetString(last_name).ToString();
txtFirstName.Text = PerReader.GetString(first_name).ToString();
txtMiddleName.Text = PerReader.GetString(middle_name).ToString();
//GetInt32 because it is a number
txtAddressID.Text = PerReader.GetInt32(address_id).ToString();
}
In VB.NET I did it all in one step like this:
While myReader.Read()
if not IsDBNull(myReader.Item("prodNumber")) 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.