Error when null value in database

[Mad_Cat]

Hi, I just started to use C# and I have a problem.

 

Code:

myConnection.Open();

myDataReader = myCommand.ExecuteReader();

while (myDataReader.Read())
{
Label1.Text = (string)Clientes.GetValue(0);
// Error below when there is a null value in the database
Label2.Text = (string)Clientes.GetValue(1);
}

 

I tried a if else to teste the null, diferent casts but can't seem to find a workaround, can anyone help?

 

Thanks in advance,

Mad Cat

Edited March 15, 2006 by PlausiblyDamp

[PlausiblyDamp]

Try something like the following

myConnection.Open();

myDataReader = myCommand.ExecuteReader();

while (myDataReader.Read())
{
Label1.Text = (string)Clientes.GetValue(0);

if (!Convert.IsDBNull(Clientes.GetValue(1)))
    Label2.Text = (string)Clientes.GetValue(1);
}

hopefully that should do the trick.

[Mad_Cat]

Thank you! The IsDBNull was what I needed.