DataGridComboBoxColumn 使用最简单方法

    <DataGrid x:Name="dgrid" Width="250" Grid.Row="0" CanUserSortColumns="True" CanUserDeleteRows="False" AutoGenerateColumns="False">
        <DataGrid.Columns>
            <DataGridTextColumn x:Name="IDCol" Header="ID" IsReadOnly="True"/>
            <DataGridTextColumn x:Name="NameCol" Header="名称"/>
            <DataGridComboBoxColumn x:Name="DepCol" Header="部门"/>
        </DataGrid.Columns>
    </DataGrid>

后台：

//首先绑定DataGrid数据
    private void Grid1Bind()
    {
        string sql = "select * from " + database;
        SQLiteConnection conn = new SQLiteConnection(connString);
        dt = new DataTable();
        sda = new SQLiteDataAdapter(sql, conn);
            conn.Open();
            s