I have one TextBox (Name:TB_Test) If I do not input any string.... In SQL DB "test" field will get "NULL" How can i do,"test" field change blank string ,not "NULL" thank you
Michael Wu from Taiwan
Code :
SqlDataSource SqlDataSource1 = new SqlDataSource();
SqlDataSource1.UpdateParameters.Clear();
SqlDataSource1.UpdateParameters.Add("test",String.IsNullOrEmpty(TB_Test.Text.ToString()) ? "": TB_Test.Text.ToString());
SqlDataSource1.Update();
Add default value to your Column.
ALTER TABLE TableName ADD CONSTRAINT DF_SomeName DEFAULT N'' FOR test;
Change the DB as @Amit Kumar suggested or use the Add(Parameter) overload of ParameterCollection. Something like this:
var parameter = new Parameter("test")
{
DefaultValue = String.IsNullOrEmpty(TB_Test.Text.ToString())
? "" : TB_Test.Text.ToString()),
ConvertEmptyStringToNull = false
};
SqlDataSource1.UpdateParameters.Add(parameter);
The important part is the ConvertEmptyStringToNull property of the Parameter class which defaults to true.
try String.Empty as below.
String.IsNullOrEmpty(TB_Test.Text.ToString()) ? String.Empty : TB_Test.Text.ToString()
"test"with"@test"andAddwithAddWithValue- rest of your code is fine.