insert null to mssql when it passed a integer = 0

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joe - 22 Jul 2004 05:57 GMT

Dear all
the integer in vb.net can not be null, it always be 0 when it have nothing
however i want to insert null to db when it is 0. how can do it

moreover
how to check a textbox is value? e.g txtbox = 2828828
is it txtbox.text.isinteger?

Reply to this Message

Claes Bergefall - 22 Jul 2004 09:40 GMT

> moreover
> how to check a textbox is value? e.g txtbox = 2828828
> is it txtbox.text.isinteger?

Try
Dim value As Integer = Int32.Parse(txtbox.Text)
Catch
' It wasn't an integer
End Try

/claes

Reply to this Message

Joe - 22 Jul 2004 11:43 GMT

any shared function provided by .net
i don't want to use error handling things

> > moreover
> > how to check a textbox is value? e.g txtbox = 2828828
[quoted text clipped - 7 lines]
>
> /claes

Reply to this Message

Claes Bergefall - 23 Jul 2004 08:19 GMT

> any shared function provided by .net

Int32.Parse *is* a shared function provided by .NET
But, as Mark wrote, you can always use IsNumeric instead

> i don't want to use error handling things

So basically nothing can ever go wrong in your program?
Cool :-)

/claes

> > > moreover
> > > how to check a textbox is value? e.g txtbox = 2828828
[quoted text clipped - 7 lines]
> >
> > /claes

Reply to this Message

insert null to mssql when it passed a integer = 0

Free Magazines