Convert null to zero

[ERUM]

i have following insert code

       Dim hotel_book As String = "insert into hotelbooking (Userid, hotel_requirement_Types, singleroom, single_no_room,doubleroom,double_no_room,checkin_date,checkout_date) " & _
                      "VALUES (" & userid & ", '" & ckchecked.Text & "' , " & Convert.ToByte(boolsing) & " ," & Int32.Parse(no_single_room.Text) & "," & Convert.ToByte(booldoub) & "," & Int32.Parse(no_double_room.Text) & " ,'" & txt_checkin.Text & "' ,'" & Me.txt_checkout.Text & "' )"

i want that if no_single_room.Text is null and have no value it should convert it into zero other wise Int32.Parse(no_single_room.Text) in same insert statement

Thanks

[Knvn]

Int32.Parse(IIf(no_single_room.Text = "", 0, no_single_room.Text))

[avrail]

hay,

no_single_room.Text

is empty string not null

[gep13]

Hello there,

As a point to note, you should NOT concatenate your SQL string like that, you leave yourself open to SQL Injection attacks. You should ALWAYS use parameters. There is a link in my signature that provides more information on this topic.

In addition to the above suggestions, you might want to look into the use of:

String.IsNullOrEmpty

As well as:

Int32.TryParse

Gary

[gep13]

Int32.Parse(IIf(no_single_room.Text = "", 0, no_single_room.Text))

If no_single_room is actually Null, then trying to access a member on this object will throw an exception.

Gary

[Pradeep1210]

You can use VAL(no_single_room.Text)
or If(String.IsNullOrEmpty(no_single_room.Text), 0, no_single_room.Text)
or Int32.Parse("0" & no_single_room.Text)
or one of the many other ways.

What I would really recommend is that you use Parameters instead of SQL string which is both more secure as well as parses the appropriate datatype correctly.

[Knvn]

If no_single_room is actually Null, then trying to access a member on this object will throw an exception.

Gary

Ya its true, but the default value of 'Text' property of the TextBox control is 'String.Empty' and the user cannot insert 'Null' on UI.

[gep13]

Ya its true, but the default value of 'Text' property of the TextBox control is 'String.Empty' and the user cannot insert 'Null' on UI.

I guess that assumes that no_single_room is actually a UI control, but there was no mention of that by the OP.

Gary