private void vendors_DGV_CellValueChanged(object sender, DataGridViewCellEventArgs e)
        {
            
            
            
           int column = vendors_DGV.CurrentCellAddress.X;
            int row = vendors_DGV.CurrentCellAddress.Y;
            string fieldName = vendors_DGV.Columns[column].HeaderText;
          
            if (vendors_DGV.Rows[row].Cells[0].Value == null) { return; }
 
            string companyName = vendors_DGV.Rows[row].Cells[0].Value.ToString();
 
            var updateV = from vend in vendors where vend.CompanyName == companyName select vend;
 
           
           
            
            MainForm.dc.SubmitChanges();
        }