How To Show A Null Value From Database In TextBox In VB.NET

Question

I want to bring records stored in my SQL server DB to my form in VB.NET, I did below coding and it works fine but is there any other better way to handle NULL value from DB column that is going to be displayed in the textbox?

If DBNull.Value.Equals(dt.Rows(0).Item("fine_amt")) Then
                txtFine_amt.Text = ""
            Else
                txtFine_amt.Text = dt.Rows(0).Item("fine_amt")
            End If

If we don't handle Null value then it is going to throw an error: Conversion from type 'DBNull' to type 'String' is not valid

"Better" in what way? extract the value to a variable? Use a conditional operator? — D Stanley
– D Stanley, Commented Jan 8, 2016 at 14:03

rory.ap · Accepted Answer · 2016-01-08 14:04:16Z

3

If I'm reading your question right, it sounds like you could just do this:

txtFine_amt.Text = dt.Rows(0).Item("fine_amt").ToString()

For null values, ToString() will always just return an empty string.

answered Jan 8, 2016 at 14:04

rory.ap

35.7k15 gold badges104 silver badges199 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Hashmatullah Noorzai Over a year ago

thank you this seems better and short way to achieve same thing :)

D Stanley · Accepted Answer · 2016-01-08 14:06:48Z

2

Not sure if it's really "better" but you could extract the value to a variable and use a conditional operator:

Dim value As Object = dt.Rows(0).Item("fine_amt")
txtFine_amt.Text = If(DBNull.Value.Equals(value), "", value)

answered Jan 8, 2016 at 14:06

D Stanley

153k12 gold badges190 silver badges257 bronze badges

3 Comments

Hashmatullah Noorzai Over a year ago

Thank you! looks fine. I was curious that how many ways are available to handle Null value coming from DB into VB form

D Stanley Over a year ago

@Hazmat Well, you're handling the null value the exact same way - it just reorganizes the code a little to make it more compact. Use whatever methods you can to get it to work, then focus on making it better. Shorter code is not always better code.

Hashmatullah Noorzai Over a year ago

Thank you Stanley for the advice

Collectives™ on Stack Overflow

How To Show A Null Value From Database In TextBox In VB.NET

2 Answers 2

1 Comment

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related