DB Nulls & DataBinding!

[Adam Knight]

Hi all,

Just wondering how everybody goes about dealing with db nulls when binding
form controls to db data.
The code below produces an error if any column in the reader object contains
a db null value.

Is their a concise way of getting around this?

Cheers,
Adam

'fill reader object with command results
rdrSupervisorDetails = cmdGetSupervisorDetails.ExecuteReader()

'move to record returned in reader object
rdrSupervisorDetails.Read()

'populate form with values retrieve from db
txtFirstName.Text = CStr(rdrSupervisorDetails("first_name"))
txtLastName.Text = rdrSupervisorDetails("last_name")
txtDepartment.Text = rdrSupervisorDetails("department")
txtEmail.Text = rdrSupervisorDetails("email")
txtPhone.Text = rdrSupervisorDetails("phone")
txtMobile.Text = rdrSupervisorDetails("mobile")

'close & destroy db connection
Conn.Close()
Conn = Nothing

[Adam Knight]

This is my attempt so far!
txtFirstName.Text = IIf(rdrSupervisorDetails("first_name") Is DBNull.Value,
String.Empty, rdrSupervisorDetails("first_name"))

"Adam Knight" <ad**@pertrain.com.au> wrote in message
news:e3**************@TK2MSFTNGP09.phx.gbl...

Hi all,

Just wondering how everybody goes about dealing with db nulls when binding
form controls to db data.
The code below produces an error if any column in the reader object
contains a db null value.

Is their a concise way of getting around this?

Cheers,
Adam

'fill reader object with command results
rdrSupervisorDetails = cmdGetSupervisorDetails.ExecuteReader()

'move to record returned in reader object
rdrSupervisorDetails.Read()

'populate form with values retrieve from db
txtFirstName.Text = CStr(rdrSupervisorDetails("first_name"))
txtLastName.Text = rdrSupervisorDetails("last_name")
txtDepartment.Text = rdrSupervisorDetails("department")
txtEmail.Text = rdrSupervisorDetails("email")
txtPhone.Text = rdrSupervisorDetails("phone")
txtMobile.Text = rdrSupervisorDetails("mobile")

'close & destroy db connection
Conn.Close()
Conn = Nothing

Adam,

Yeah, DBNull.Value is the way that I do it as well. Seems to work fine!

J

"Adam Knight" <ad**@pertrain.com.au> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

This is my attempt so far!
txtFirstName.Text = IIf(rdrSupervisorDetails("first_name") Is
DBNull.Value, String.Empty, rdrSupervisorDetails("first_name"))

"Adam Knight" <ad**@pertrain.com.au> wrote in message
news:e3**************@TK2MSFTNGP09.phx.gbl...

Hi all,

Just wondering how everybody goes about dealing with db nulls when
binding form controls to db data.
The code below produces an error if any column in the reader object
contains a db null value.

Is their a concise way of getting around this?

Cheers,
Adam

'fill reader object with command results
rdrSupervisorDetails = cmdGetSupervisorDetails.ExecuteReader()

'move to record returned in reader object
rdrSupervisorDetails.Read()

'populate form with values retrieve from db
txtFirstName.Text = CStr(rdrSupervisorDetails("first_name"))
txtLastName.Text = rdrSupervisorDetails("last_name")
txtDepartment.Text = rdrSupervisorDetails("department")
txtEmail.Text = rdrSupervisorDetails("email")
txtPhone.Text = rdrSupervisorDetails("phone")
txtMobile.Text = rdrSupervisorDetails("mobile")

'close & destroy db connection
Conn.Close()
Conn = Nothing