Export (0) Print
Expand All
3 out of 5 rated this helpful - Rate this topic

Working with Null Values in TableAdapters 

TableAdapter parameters can be assigned null values when you want to query for records that have no current value. For example, consider the following query that has a ShippedDate parameter in its WHERE clause:

SELECT CustomerID, OrderDate, ShippedDate

FROM Orders

WHERE (ShippedDate = @ShippedDate) OR

(ShippedDate IS NULL)

If this were a query on a TableAdapter, you could query for all orders that have not been shipped with the following code:

ordersTableAdapter.FillByShippedDate(northwindDataSet.Orders, null);

System.Nullable<System.DateTime> nullValue = new System.Nullable<System.DateTime>();

northwindDataSetOrdersTableAdapter.FillByShippedDate(northwindDataSet.get_Orders(), nullValue);

Setting the AllowDbNull Property

To enable a query to accept null values

  1. In the Dataset Designer, select the TableAdapter query that needs to accept null parameter values.

  2. Select Parameters in the Properties window and click the ellipsis () button to open the Parameters Collection Editor.

  3. Select the parameter that allows null values and set the AllowDbNull property to true.

See Also

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft. All rights reserved.