Convert null to zero

i have following insert code

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

Code:

---

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

---

hay,

Code:

---

no_single_room.Text

---

is empty string not null

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:

Code:

---

String.IsNullOrEmpty

---

As well as:

Code:

---

Int32.TryParse

---

Gary

Quote:

---

Originally Posted by Knvn

Code:

---

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

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.

Quote:

---

Originally Posted by gep13

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.

Quote:

---

Originally Posted by Knvn

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