Hi Nick,
This is a known issue of typed DataSet in .NET 2.0. The generated code
snippet is actually from the typed DataSet (for example:
DataSet1.Table3 Row) rather than the TableAdapter. As the TableAdapter's
documentation (
http://msdn2.microsoft.com/en-us/library/bz9tthwx.aspx)
claimed: The TableAdapters support nullable types Nullable(Of T) and T?.
You should see the Insert or Update method of your TableAdapter does use
"System.Nullabl e<double>" as parameter data type.
We looked really closely at extending typed DataSet to support Nullable
types. However, Nullable types were added a bit late in the cycle and we
just didn't have the time to work out all the plumbing issues up and down
the stack. Because typed DataSet serializes into untyped DataSets, and due
to the way DataBinding works with Views, adding Nullable types in the
strongly typed DataSet was problematic. Another issue is related to
compatibility with .NET 1.x.
There's already a related feedbak on this issue:
http://connect.microsoft.com/VisualS...k.aspx?Feedbac
kID=121229
As the product team responded, it will be considered for a future
enhancement. Thank you for your feedback!
Hope this helps. Please feel free to post here if anything is unclear.
Sincerely,
Walter Wang (wa****@online. microsoft.com, remove 'online.')
Microsoft Online Community Support
=============== =============== =============== =====
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
=============== =============== =============== =====
This posting is provided "AS IS" with no warranties, and confers no rights.