Can't default values

[Zeki-Gursoy]

create table mytable(field integer default 10);

var tbl = new DataTable();

using var adp = new FbDataAdapter("select * from mytable", _cn);

adp.Fill(tbl);

//tbl.Columns[0].DefaultValue = 10;

DataGrid.DataSource = tbl;

DataGrid is enabled Add for user. When user it is moved to the "NewRow" row, the field's default value is "0". This indicates that it has not been added to the DataTable schema.

I can set the default values ​​manually, but it's annoying in a table with many columns.

[cincuranet]

Datatables and dataadapters are basically obsolete, so although there might be some missing functionality, I wouldn't recommend using those. I'll leave this issue open, but as a very low priority.