public async Task UpdateDb(DataTable table)
{
try
{
using (var connection = new SqlConnection(ConnectionBuilder.ConnectionString))
{
await connection.OpenAsync();
var commandBuilder = new SqlCommandBuilder(Adapter);
Adapter.Update(Ds);
Ds.Clear();
Adapter.Fill(Ds);
MainWindow.CustomGrid.DataContext = Ds.Tables["persons"];
}
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
}