Saya memilki Field-> Address, yang isinya = NULL.
Untuk menampilkan datanya ke Textbox, agar tidak error saya kasih Syntax
ini:
Me.txtAddress.Text = IIf(IsDBNull(myDR.Item("Address")), "",
Trim(myDR.Item("Address")))
Akibatnya timbul Error Message sbb:
Additional information: Cast from type 'DBNull' to type 'String' is not
valid.
Padahal kalo saya uda Syntax-nya jadi dibawah ini, tidak ada error.
If IsDBNull(myDR.Item("Address")) = True Then
Me.txtAddress.Text = ""
Else
Me.txtAddress.Text = Trim(myDR.Item("Address"))
End If
Mohon petunjuk dari rekan-rekan..
regards,
Muliadi Liem
Send instant messages to your online friends http://asia.messenger.yahoo.com
------------------------ Yahoo! Groups Sponsor --------------------~-->
Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/k7folB/TM
--------------------------------------------------------------------~->
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Programmer-VB/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
