Using ExecuteReader() And GetString()

Hi.

I'm trying to read data from a database. This is my code:

++++++++++++++++++++++++++++++++++++++++++++++++++++++++

connection.Open();SqlCommand cmd = new SqlCommand(sql, connection);

myReader = cmd.ExecuteReader();if (myReader.Read())

{

name1TextBox.Text = myReader.GetString(1);

addr1TextBox.Text = myReader.GetString(2);

code1TextBox.Text = myReader.GetString(5);

tel1TextBox.Text = myReader.GetString(6);

fax1TextBox.Text = myReader.GetString(7);

:

:

++++++++++++++++++++++++++++++++++++++++++++++++++++++++

The above code works fine until one of the GetString calls trys to return NULL (in this case myReader.GetString(5)).

In other words, this code will run through about 30 rows of data until it runs in to a NULL entry for one of the columns.

At that stage it's too late. I'm not allowed call GetString( ) on a NULL value.

Is there anyway I can test the column entry before calling GetString( ).

Regards (& thanks in advance)

Garrett