Transform empty string to null in data bound textbox

Question

I have a textbox in a formview that gets its data from a linqdatasource which is used to enter a date:

<SP:TextBox ID = "StartDate" 
            Type = "Date" 
            Runat = "server" 
            Text = '<%# Bind("StartDate", "{0:yyyy-MM-dd}") %>' />

It works fine, except when StartDate is a null value in the database. Then the StartDate textbox is empty which is correct, but when the empty field is saved back to the database the date 0001-01-01 is stored instead of a null value which is wrong. How can I detect this scenario and turn the empty string into a null value before it is saved?

Tim Schmelter · Accepted Answer · 2011-06-30 11:30:19Z

4

The solution is to add parameters for the nullable columns and set ConvertEmptyStringToNull to true:

<asp:LinqDataSource ID="LinqDataSource1" runat="server"
    ContextTypeName="NullUpdateRepo.DatabaseLinqDataContext" EnableUpdate="True"
    TableName="SampleTables" OnSelected="OnSelected" OnContextCreated="OnContextCreated">
    <UpdateParameters>
        <asp:Parameter Name="firstname" Type="String" ConvertEmptyStringToNull="true" />
        <asp:Parameter Name="lastname" Type="String" ConvertEmptyStringToNull="true" />
    </UpdateParameters>
</asp:LinqDataSource>

http://connect.microsoft.com/VisualStudio/feedback/details/296161/linqdatasource-and-null-column-values

answered Jun 30, 2011 at 11:30

Tim Schmelter

462k79 gold badges721 silver badges981 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

thevan · Accepted Answer · 2011-06-30 13:03:40Z

0

In the BackEnd While Inserting Date value give like this:

   CASE WHEN StartDate='0001-01-01' THEN NULL ELSE StartDate END

It will store NULL in the Table.

answered Jun 30, 2011 at 13:03

thevan

10.4k55 gold badges140 silver badges203 bronze badges

Collectives™ on Stack Overflow

Transform empty string to null in data bound textbox

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related