I have an insert statement in my aspx.cs file. I'm trying to avoid having a Null value in my record. Not sure the best way to handle this when the user does not provide data in this text box?
I'm currently just adding a space to every entry. (I would prefer a space over "N/A".)
command.Parameters.Add("@MiddleName", SqlDbType.VarChar, 50).Value =
TextBoxMiddleName.Text.Trim() + " ";