Re: Null Values

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

The best advice is to always check inbound values for null before processing
them. You can use the IsDBNull(value) function or you can check a value
against DBNull.value.


"Kevin" <kevgrim@xxxxxxxxx> wrote in message
news:u$6ybQJPFHA.4064@xxxxxxxxxxxxxxxxxxxxxxx
> Am using SQL Server 2000. The tables use a default of 0 for the bit
> fields.
> Have been using VB for years and never hit any serious data problems like
> this.
> Am trying to keep myself upto date and with my initial attempts at data
> with VB.NET has resulted in disaster. In my ignorance have used the
> DataForm Wizard and really screwed up the data because there was a Null
> value for a checkbox.
> This is a known bug but there are dozens of fixes published but, because
> am new to VB.NET am not sure of the merit of each fix. Also getting the
> same problem with a combo box.
> Because am not familiar with the sequence the data events are fired, am
> not sure where to place the fix code, or what data object to apply it to.
> Am used to connections and recordsets but all these datasets and adapters
> are very bewildering to a novice.
>
> Thanks in advance for any help.
>
> "William (Bill) Vaughn" <billvaRemoveThis@xxxxxxxxxx> wrote in message
> news:euTvY0IPFHA.3072@xxxxxxxxxxxxxxxxxxxxxxx
>> That's a pretty broad question. What exceptions are you seeing? How are
>> your tables defined in the sense of column definitions? What techniques
>> are you using to fetch or update the data? What database are you using?
>> Jet/Access, SQL Server, Oracle, DB2?
>>
>> --
>> ____________________________________
>> William (Bill) Vaughn
>> Author, Mentor, Consultant
>> Microsoft MVP
>> www.betav.com/blog/billva
>> www.betav.com
>> Please reply only to the newsgroup so that others can benefit.
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> __________________________________
>>
>> "Kevin" <kevgrim@xxxxxxxxx> wrote in message
>> news:up8olMGPFHA.1884@xxxxxxxxxxxxxxxxxxxxxxx
>>> Am fed up with Null values crashing my applications and screwing up data
>>> when it hits a check or combo box, in Visual Studio 2002.
>>> Have found numerous fixes on various sites and now feel am going round
>>> in circles.
>>> What is the best and most reliable way of dealing with Nulls??
>>>
>>>
>>
>>
>
>


.

Relevant Pages

  • Re: Null Values
    ... Am using SQL Server 2000. ... Have been using VB for years and never hit any serious data problems like ... sure where to place the fix code, or what data object to apply it to. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Getting list of recently added IDENTITY items
    ... num_of_hits for each hit within the same 3ms timeframe. ... The problem is fairly apparent here, because SQL Server has a fairly ... floating-point as a primary key. ... IDENTITY is a discrete set of value that is easy ...
    (comp.databases.ms-sqlserver)
  • Re: Recurring import of linked text file data
    ... indication that the amount of data being imported was exceeding ... calculate how much time you have before you would hit my arbitrary size. ... The mdb file was about 256mb, ... migrate it to SQL Server 2000. ...
    (microsoft.public.access.externaldata)
  • Re: Just passed 70-228 !
    ... After the exam I received a printed report with a sectional report. ... There are 6 sections, each one represented with a bar graph that shows how good did you perform in each area, but it doesn't tell you how many questions per area or how many did you hit. ... I didn't have previous experience in SQL Server, but 4 years working with DB2 on mainframe. ... This was my first exam after getting MCSA in W2K. ...
    (microsoft.public.cert.mcdba)