//plan
With Me.DataSet1.Tables.Add("plan")
.Columns.Add("id_plg", GetType(Integer))
.Columns.Add("id_org_ob", GetType(Integer)).Unique = True
.Columns.Add("План на год, руб.", GetType(Decimal)).DefaultValue = 0
.Columns.Add("Оборудование в том числе, руб.", GetType(Decimal)).DefaultValue = 0
.PrimaryKey = New DataColumn() {.Columns.Item(0)}
.Columns.Item(0).AutoIncrement = True
.Columns.Item(0).AutoIncrementSeed = -1
.Columns.Item(0).AutoIncrementStep = -1
.Columns.Item(2).AllowDBNull = False
.Columns.Item(3).AllowDBNull = False
End With
Dim tableMap As DataTableMapping
tableMap = Me.SqlDataAdapter1.TableMappings.Add("Table1", "sp")
tableMap = Me.SqlDataAdapter1.TableMappings.Add("Table", "plan")
Dim columnMaps = New DataColumnMapping() _
{New DataColumnMapping("id_plg", "id_plg"), _
New DataColumnMapping("id_org_ob", "id_org_ob"), _
New DataColumnMapping("plan_o", "План на год, руб."), _
New DataColumnMapping("obor_o", "Оборудование в том числе, руб.")}
tableMap.ColumnMappings.AddRange(columnMaps)
//sp_fil
With Me.DataSet1.Tables.Add("sp")
.Columns.Add("id_na_ob", GetType(Integer))
.Columns.Add("nazv", GetType(String))
End With
//подст столбец
Dim col As New DataGridViewComboBoxColumn
col.Name = "podst_nazv"
col.HeaderText = "Название организации"
col.DataPropertyName = "id_org_ob"
col.DataSource = Me.DataSet1.Tables(1)
col.DisplayMember = "nazv"
col.ValueMember = "id_na_ob"
col.DisplayStyle = DataGridViewComboBoxDisplayStyle.ComboBox
col.MaxDropDownItems = 6
Me.DataGridView1.Columns.Add(col)
//select command plan
cn.Open()
Me.SqlDataAdapter1.Fill(Me.DataSet1)
cn.Close()
                
Me.BindingSource1.DataSource = Me.DataSet1.Tables(0)
Me.DataGridView1.Columns.Item(0).Visible = False

void myDgColumnAdd()
{
   DataTemplate dt;
   Binding bind;
   string _strFormat = "{0:N1}";
   //0
   dt = new DataTemplate(typeof(string));
   FrameworkElementFactory factoryTXT = new FrameworkElementFactory(typeof(TextBlock));
   bind = new Binding("[0]") { Mode = BindingMode.TwoWay };
   factoryTXT.SetBinding(TextBlock.TextProperty, bind); 
   dt.VisualTree = factoryTXT;
   DataGridTemplateColumn txtCol = new DataGridTemplateColumn { Header = "id_plg", CellTemplate = dt };
   myDg.Columns.Add(txtCol);
   // 1
   dt = new DataTemplate(typeof(string));
   factoryTXT = new FrameworkElementFactory(typeof(TextBlock));
   bind = new Binding("[1]") { Mode = BindingMode.TwoWay };
   factoryTXT.SetBinding(TextBlock.TextProperty, bind); 
   dt.VisualTree = factoryTXT;
   txtCol = new DataGridTemplateColumn { Header = "id_org_ob", CellTemplate = dt };                     
   myDg.Columns.Add(txtCol);
   // 2
   dt = new DataTemplate(typeof(string));
   factoryTXT = new FrameworkElementFactory(typeof(TextBox));
   factoryTXT.SetValue(TextBox.TextAlignmentProperty, TextAlignment.Right);            
   bind = new Binding("[2]")
      {
         Converter = new myConverter(),
         ConverterParameter = _strFormat,
         Mode = BindingMode.TwoWay
      };
   factoryTXT.SetBinding(TextBox.TextProperty, bind);  
   dt.VisualTree = factoryTXT;
   txtCol = new DataGridTemplateColumn { Header = "План на год, руб.", CellTemplate = dt };                     
   myDg.Columns.Add(txtCol);
   // 3
   dt = new DataTemplate(typeof(string));
   factoryTXT = new FrameworkElementFactory(typeof(TextBox));
   factoryTXT.SetValue(TextBox.TextAlignmentProperty, TextAlignment.Right);            
   bind = new Binding("[3]")
      {
      Converter = new myConverter(),
      ConverterParameter = _strFormat,
      Mode = BindingMode.TwoWay
      };
   factoryTXT.SetBinding(TextBox.TextProperty, bind);
   dt.VisualTree = factoryTXT;
   txtCol = new DataGridTemplateColumn { Header = "Оборудование в том числе, руб.", CellTemplate = dt };                      
   myDg.Columns.Add(txtCol);
   // комбобокс, что знал то и написал - в итоге канешн не рабоает :)))
   DataGridComboBoxColumn cbCol = new DataGridComboBoxColumn();            
   cbCol.Header = "Название организации";
   cbCol.ItemsSource = ds.Tables[1].Rows;
   cbCol.SelectedValuePath = "id";
   cbCol.DisplayMemberPath = "name";
   cbCol.SelectedItemBinding = new Binding("id");
   cbCol.TextBinding = new Binding("[1]");            
   myDg.Columns.Add(cbCol);
   }

dt = new DataTemplate();
factoryTXT = new FrameworkElementFactory(typeof(ComboBox));
factoryTXT.SetValue(ComboBox.ItemsSourceProperty, ds.Tables[1].Rows);
factoryTXT.SetValue(ComboBox.SelectedValuePathProperty, "[0]");
factoryTXT.SetValue(ComboBox.DisplayMemberPathProperty, "[1]");                        
dt.VisualTree = factoryTXT;
txtCol = new DataGridTemplateColumn { Header = "Название организации", CellTemplate = dt };            
myDg.Columns.Add(txtCol);
// комбобокс
DataGridComboBoxColumn cbCol = new DataGridComboBoxColumn { Header = "Название организации" };
cbCol.ItemsSource = ds.Tables[1].Rows;
cbCol.SelectedValuePath = "[0]";
cbCol.DisplayMemberPath = "[1]";
bind = new Binding("[1]")
   {                
      Mode = BindingMode.TwoWay
    };
cbCol.SelectedValueBinding = bind;                
myDg.Columns.Add(cbCol);

ds.Tables.Add("plg");
// plg
ds.Tables[0].Columns.Add("id_plg", typeof(int));
ds.Tables[0].Columns.Add("id_org_ob", typeof(int));
ds.Tables[0].Columns.Add("plan_o", typeof(decimal)).DefaultValue = 0;
ds.Tables[0].Columns.Add("obor_o", typeof(decimal)).DefaultValue = 0;
ds.Tables[0].PrimaryKey = new DataColumn[] { ds.Tables[0].Columns[0] };
ds.Tables[0].Columns[0].AutoIncrement = true;
ds.Tables[0].Columns[0].AutoIncrementSeed = -1;
ds.Tables[0].Columns[0].AutoIncrementStep = -1;            
ds.Tables[0].Columns[1].Unique = true;
ds.Tables[0].Columns[2].AllowDBNull = false;
ds.Tables[0].Columns[3].AllowDBNull = false;
ds.EnforceConstraints = true;
// список 
ds.Tables.Add("sp");
ds.Tables[1].Columns.Add("id", typeof(int));
ds.Tables[1].Columns.Add("name", typeof(string));            
ds.Tables[1].PrimaryKey = new DataColumn[] { ds.Tables[1].Columns[0] };

void frmObjectOrgPlg_Loaded(object sender, RoutedEventArgs e)
        {
            dsSelect();
            myDgColumnAdd();
            myDg.DataContext = ds.Tables[0];
            Binding bind = new Binding()
            {
                Mode = BindingMode.TwoWay,
                Path = new PropertyPath(".")
            };

            myDg.SetBinding(DataGrid.ItemsSourceProperty, bind);     
        }   

void myDgColumnAdd()
{            
   Binding bind;            
   // 0 комбобокс
   DataGridComboBoxColumn cbCol = new DataGridComboBoxColumn { Header = "Название организации" };
   cbCol.ItemsSource = ds.Tables[1].Rows;
   cbCol.SelectedValuePath = "[0]";
   cbCol.DisplayMemberPath = "[1]";
   bind = new Binding("[1]")
      {                
         Mode = BindingMode.TwoWay                
      };
   cbCol.SelectedValueBinding = bind;           
   myDg.Columns.Add(cbCol);                
   // 2
   bind = new Binding("[2]")
      {
         Converter = new myConverter(),
         ConverterParameter = "{0:N1}",
         Mode = BindingMode.TwoWay
      };
   bind.ValidationRules.Add(new AllDecimalRule(0, 999999999.9m));
   Style st = new Style();
   Setter settet = new Setter(DataGridCell.HorizontalAlignmentProperty, HorizontalAlignment.Stretch);
   st.Setters.Add(settet);
   DataGridTextColumn txtCol = new DataGridTextColumn { Header = "план на год, руб.", Binding = bind, CellStyle = st };
   myDg.Columns.Add(txtCol);      
   // 3
   bind = new Binding("[3]")
   {
      Converter = new myConverter(),
      ConverterParameter = "{0:N1}",
      Mode = BindingMode.TwoWay
   };
   bind.ValidationRules.Add(new AllDecimalRule(0, 999999999.9m));
   txtCol = new DataGridTextColumn { Header = "в т.ч. оборудование, руб.", Binding = bind, CellStyle = st };
   myDg.Columns.Add(txtCol);
}