How pass null string as parameter

[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.

 

[Guest]

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.

nillable="true"

 

[Guest]

nillable="true"

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

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

In document:
<element_name xsi:nil="true"/>

 

[Hans Kesting]

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.

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

 

[Guest]

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

through XSD datasets?