I'm back again. I've been working on improving my database handling and from that end it is looking good. One of the things I had to give up is using subselects and joins to get text from another table since then the DataAdapter.update() can't work.

So I've been researching how to assign other values to the datagrid and discovered how to build the columns myself no problem as long as I bind to a column in me Datatable.

I did run across mention of using databindings so I spent last night and today trying to get those working. Didn't take too long to get two words built into a sentence then a little later some math. That worked great with Textboxes and Textblocks. I still get told that my converter class doesn't exist in the namespace even though it works fine though.

I'm at a dead end now since I am trying to multibind and do some math in a DataGridTextColumn. My converter just throws an exception saying I can't convert a named object into an int/double/whatever. I did a lot of looking and I am thinking the problem is that nothing is being sent IN that object (basically null) so no casting will work. Even Integer.tryparse() throws exceptions which is what it is supposed to prevent.

I'm building the columns in XAML then assigning the datatable to the datagrid in codebehind. NO clue why it isn't working but then I have almost no clue what I am doing either.,

XAML
Code:
            <DataGrid Name="dg" IsReadOnly="False" AutoGenerateColumns="False" >
                <DataGrid.Columns>
                    <DataGridTextColumn Header="Name" Binding="{Binding name}"/>
                    <DataGridTextColumn x:Name="MyGridColumn"
                                Header="Amount"
                                Width="*">
                        <DataGridTextColumn.Binding>
                            <MultiBinding Converter="{StaticResource ingAmountConvert}">
                                <Binding Path="amount" />
                                <Binding Path="stkpkg" />
                            </MultiBinding>
                        </DataGridTextColumn.Binding>
                    </DataGridTextColumn>
                    <DataGridTextColumn Header="Pkg" Binding="{Binding stkunit}"/>
                    <DataGridTextColumn Header="Name" Binding="{Binding name}"/>
                </DataGrid.Columns>
            </DataGrid>
Nothing in the code except dg.ItemsSource=dtUsers.Defaultview