What is better? Faster?

[bigfoot]

I'm checking for null in the table as I am opening it.

This:
txtCustST.Text = row.Item("CustST&quot & ""

Or This:
txtCustZip.Text = IIf(IsDBNull(row.Item("CustZip&quot), "", row.Item("CustZip&quot)

'It works on int fields too
txtSalesNumber.Text = IIf(IsDBNull(row.Item("SalesNumber&quot), 0, row.Item("SalesNumber&quot)


I would thik a concatination is faster then a decision.
What do you all think?

And if the concat (&) works better, then how do you handle numeric fields? The same way:
txtCustST.Text = row.Item("SalesNumber&quot & ""

 

[chiph]

Why not use ildasm.exe to see which one produces fewer MSIL statements?

Chip H.

 

[3587]

Bigfoot, may i ask you two questions? Do you have your fields in your database set to allow zero length strings?

Thank you,

 

[bigfoot]

It's a SQL Server database, and I have allow nulls turned on.