Visual studio SQL default value not showing on windows form when adding new record

Question

I have created a SQL table in Visual studio and set a default value on a field.

The table is connected to my C# project (in the same solution) and pulls through fine, however the default values are not appearing when a new row is created via a windows form.

Info from comment questions:

• It doesn't appear on the form when I click the + for a new row.
• When a row is added from the database the defaults are there.
• Added a new row via the form, left the fields with default values blank, saved, re opened and no default values.

Answer 1

Based on this W3Schools Tutorials

The default value will be added to all new records IF no other value is specified.

So the Default value will not show until you save the row to the database, you can add it programatically, but the Default value constraint is used to assign a value if there is no values provided in this column

You can save these default values in the application Settings and use it when new row is added

textBox1.Text = Properties.Settings.Default.TextBoxDefaultValue;

If you are facing an issue when defining default value in Visual Studio try adding a Default Constraint using SQL query:

ALTER TABLE XXX 
ADD CONSTRAINT def_Retired
DEFAULT 'N' FOR Retired;

UPDATE 1

On the form designer, click on the BindingNavigator, In the Properties window set the AddNewItem property to (none)

Try adding the following code to the bindingNavigatorAddNewItem_Click event

private void bindingNavigatorAddNewItem_Click(object sender, EventArgs e) {

 vehiclesBindingSource.AddNew();
 Textbox1.Text = Properties.Settings.Default.Text1default;

};