How pass null string as parameter

  • Thread starter Thread starter Bobby Edward
  • Start date Start date
B

Bobby Edward

Using MySql. Using business classes that work thru XSD datasets.

I have a datetime field in a table. How can I pass a null to it (as a
param)?

Hope this is clear. Thanks.
 
Using MySql.  Using business classes that work thru XSD datasets.

I have a datetime field in a table.  How can I pass a null to it (as a
param)?

Hope this is clear.  Thanks.
Click to expand...

nillable="true"
 
nillable="true"
Click to expand...

--------------------------------------------------------------------------------

In schema:
<xs:element name="element_name" type="xs:date" nillable="true"/>

In document:
<element_name xsi:nil="true"/>
 
Bobby Edward explained on 10-12-2008 :
Using MySql. Using business classes that work thru XSD datasets.

I have a datetime field in a table. How can I pass a null to it (as a
param)?

Hope this is clear. Thanks.
Click to expand...

Use a DBNull.Value as parameter value if you want a "null" in the
database. This should work even if it is a datetime parameter.

Hans Kesting
 
Bobby Edward explained on 10-12-2008 :




Use a DBNull.Value as parameter value if you want a "null" in the
database. This should work even if it is a datetime parameter.

Hans Kesting
Click to expand...

through XSD datasets?
 
Back
Top