By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,573 Members | 1,777 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,573 IT Pros & Developers. It's quick & easy.

A couple of questions on typed Datasets

P: n/a
1. I am using a typed dataset which is being filled from
an Oracle database. If any of the columns contain a null
value I get an error when accessing the column
e.g. msgbox(MyDataset.BUILDINGS.Item(0).BUIL_STATUS)
throws an exception - Cannot get value because it is DBNull

Is there a simple way to manage null values without having
to trap for nulls everytime a column is referenced in the
dataset ?

Question 2 relates to dataset properties. When viewing a
datasets properties the window contains a hyperlink to
another Dataset Properties window in the bottom lefthand
side. This second window shows detailed for each table
and column but they are read-only. Is there a way to
programatically access and set these properties?

Cheers

Ernie
Nov 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
yes, you can change through it's schema. where you see dataset properties
link at the bottom in the property window. there is another link for view
schema. you can go there and change those read-only properties. if it is
disable, you can go through solution explorer and look for .xsd files for
the respective dataset.

Rajesh Patel

"Ernie Josefik" <er**********@optusnet.com.au> wrote in message
news:11****************************@phx.gbl...
1. I am using a typed dataset which is being filled from
an Oracle database. If any of the columns contain a null
value I get an error when accessing the column
e.g. msgbox(MyDataset.BUILDINGS.Item(0).BUIL_STATUS)
throws an exception - Cannot get value because it is DBNull

Is there a simple way to manage null values without having
to trap for nulls everytime a column is referenced in the
dataset ?

Question 2 relates to dataset properties. When viewing a
datasets properties the window contains a hyperlink to
another Dataset Properties window in the bottom lefthand
side. This second window shows detailed for each table
and column but they are read-only. Is there a way to
programatically access and set these properties?

Cheers

Ernie

Nov 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.