How to set an empty string as a default value for a DataSource parameter in ASP.NET?
<p>This doesn't work. I've got an exception from SQL databse that column does not allow nulls.</p>

<pre><code>&lt;asp:SqlDataSource ID="MyDataSOurcet" runat="server" 
        ConnectionString="&lt;%$ ConnectionStrings:MyConnectionString %&gt;" 
        InsertCommand="INSERT INTO MyTable(Name) VALUES (@Name) WHERE NameID = 1" 
        &lt;InsertParameters&gt;
            &lt;asp:Parameter Name="Name" Type="String" DefaultValue=""/&gt;
        &lt;/InsertParameters&gt;
    &lt;/asp:SqlDataSource&gt;
</code></pre>
