Home All Groups Group Topic Archive Search About

Where are the IsNull methods on my DataSet

Author
3 Jan 2006 9:01 PM
Harry Keck
Usually, when I create a typed DataSet using the Visual Studio designer,
IsColumnNameNull methods are automatically generated for each column in my
tables.  However, this time these methods were not created.  I can not figure
out how to get them.  Any advice?  Thanks.

Author
3 Jan 2006 9:37 PM
Miha Markic [MVP C#]
Did you check if your columsn AllowDBNull?

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Show quote
"Harry Keck" <HarryK***@discussions.microsoft.com> wrote in message
news:0509F513-57AC-4B57-ABC6-9393B4A2B888@microsoft.com...
> Usually, when I create a typed DataSet using the Visual Studio designer,
> IsColumnNameNull methods are automatically generated for each column in my
> tables.  However, this time these methods were not created.  I can not
> figure
> out how to get them.  Any advice?  Thanks.
Author
4 Jan 2006 2:28 PM
Harry Keck
I think that is my problem.  The AllowDBNull value must have been taken when
I dragged the table definition into the designer from Server Explorer.  I can
not find a way to set AllowDBNull from the Visual Studio typed dataset
designer, though.  Do I need to do this directly in the XML, or am I just
missing it somewhere else?

Show quote
"Miha Markic [MVP C#]" wrote:

> Did you check if your columsn AllowDBNull?
>
> --
> Miha Markic [MVP C#]
> RightHand .NET consulting & development www.rthand.com
> Blog: http://cs.rthand.com/blogs/blog_with_righthand/
>
> "Harry Keck" <HarryK***@discussions.microsoft.com> wrote in message
> news:0509F513-57AC-4B57-ABC6-9393B4A2B888@microsoft.com...
> > Usually, when I create a typed DataSet using the Visual Studio designer,
> > IsColumnNameNull methods are automatically generated for each column in my
> > tables.  However, this time these methods were not created.  I can not
> > figure
> > out how to get them.  Any advice?  Thanks.
>
>
>
Author
4 Jan 2006 3:31 PM
Miha Markic [MVP C#]
Select the appropriate column and use the Properties window to adjust it.
Does this work?

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Show quote
"Harry Keck" <HarryK***@discussions.microsoft.com> wrote in message
news:5898E1FB-DD3D-409D-949D-7EEF59487037@microsoft.com...
>I think that is my problem.  The AllowDBNull value must have been taken
>when
> I dragged the table definition into the designer from Server Explorer.  I
> can
> not find a way to set AllowDBNull from the Visual Studio typed dataset
> designer, though.  Do I need to do this directly in the XML, or am I just
> missing it somewhere else?
>
> "Miha Markic [MVP C#]" wrote:
>
>> Did you check if your columsn AllowDBNull?
>>
>> --
>> Miha Markic [MVP C#]
>> RightHand .NET consulting & development www.rthand.com
>> Blog: http://cs.rthand.com/blogs/blog_with_righthand/
>>
>> "Harry Keck" <HarryK***@discussions.microsoft.com> wrote in message
>> news:0509F513-57AC-4B57-ABC6-9393B4A2B888@microsoft.com...
>> > Usually, when I create a typed DataSet using the Visual Studio
>> > designer,
>> > IsColumnNameNull methods are automatically generated for each column in
>> > my
>> > tables.  However, this time these methods were not created.  I can not
>> > figure
>> > out how to get them.  Any advice?  Thanks.
>>
>>
>>

AddThis Social Bookmark Button