How to convert asp.net NULL value to "" (blank string)

I have a situation where I am using a detailsview with the SQLDataSource to update a record in an SQL Server Database.

My issue is that textfields that are not completed are converted to NUL开发者_开发百科L in the database. This causes issue as the website using third party web services that can not handle to NULL DB value.

Is there a way that if the textfield is left empty that when the update or insert occurs, that the data is converted to "" (blank string) instead of the NULL value?

Since you are using SQLDataSource, when you insert or update a record, there is a ConvertEmptyStringToNull property of the Insert/update parameters. Set this to false, and set the string to empty, if no value is provided to that control. Look at the example below:

<asp:SqlDataSource ID="SqlDataSource1" runat="server">
        <InsertParameters>
            <asp:ControlParameter ConvertEmptyStringToNull="false" />
        </InsertParameters>
        <UpdateParameters>
            <asp:ControlParameter ConvertEmptyStringToNull="false" />
        </UpdateParameters>
    </asp:SqlDataSource>

You could set a default value of "" on the database table column. Or in your SQL select statements you could do something like

SELECT IsNull(ColName,"")
FROM SomeTable

The