DevExpress: ASPxGridView 中绑定下拉框（不用该死的ASPxDropDownEdit,而用简单的GridViewDataComboBoxColumn）

 这该死的ASPxDropDownEdit,老是不能很好的解决问题，花了一天都没有解决。刚才重游了一次 devExpree的官网，找到了传说中的解决方案：原来官方不提创使用ASPxDropDownEdit,而是极力推荐 ComboBox。

解决方案如下：

1，html前台代码

     注意：关键在于 sqlDataSource,FieldName,TextField,ValueField,KeyFieldName

                                         <asp:SqlDataSource ID="sqlDataSrcApp" runat="server"></asp:SqlDataSource>
                                             <asp:SqlDataSource ID="sqlDataSrcGroup" runat="server"></asp:SqlDataSource>

                                    <dx:ASPxGridView ID="grvUserGroup" runat="server" AutoGenerateColumns="False" 
                                        ClientIDMode="AutoID" 
                                        CssFilePath="~/App_Themes/Office2003Blue/{0}/styles.css" 
                                        CssPostfix="Office2003Blue" Width="100%" KeyFieldName="AppID" 
                                        onrowinserting="grvUserGroup_RowInserting" 
                                        onrowupdating="grvUserGroup_RowUpdating" 
                                        onrowdeleting="grvUserGroup_RowDeleting" 
                                        oncelleditorinitialize="grvUserGroup_CellEditorInitialize" >
                                                    <ClientSideEvents RowDblClick="function(s, e) {
	s.StartEditRow(e.visibleIndex);
}" />

                                        <Columns>
                                            <dx:GridViewDataComboBoxColumn Caption="系统名称" FieldName="AppID" 
                                                VisibleIndex="0" >
                                                <PropertiesComboBox ValueType="System.String"  TextField="AppName" 
                                                    ValueField="AppID" EnableSynchronization="False"
                    IncrementalFilteringMode="StartsWith" DataSourceID="sqlDataSrcApp" Width="100%">
                                                </PropertiesComboBox>
                                                <EditCellStyle HorizontalAlign="Left">
                                                </EditCellStyle>
                                            </dx:GridViewDataComboBoxColumn>
                                            <dx:GridViewDataComboBoxColumn Caption="用户组" FieldName="GroupID" 
                                                VisibleIndex="1">
                                                <PropertiesComboBox ValueType="System.String"  TextField="GroupName" 
                                                    ValueField="GroupID" EnableSynchronization="False"
                    IncrementalFilteringMode="StartsWith" DataSourceID="sqlDataSrcGroup" Width="100%">
                                                </PropertiesComboBox>
                                                <EditCellStyle HorizontalAlign="Left">
                                                </EditCellStyle>
                                            </dx:GridViewDataComboBoxColumn>
                                        </Columns>
                                        <SettingsBehavior AllowFocusedRow="True" />
                                        <SettingsEditing Mode="PopupEditForm" PopupEditFormHeight="80px" 
                                            PopupEditFormHorizontalAlign="WindowCenter" PopupEditFormModal="True" 
                                            PopupEditFormVerticalAlign="WindowCenter" PopupEditFormWidth="450px" 
                                                        EditFormColumnCount="4" />
                                        <SettingsText CommandCancel="取消" CommandDelete="删除" CommandEdit="修改" 
                                            CommandNew="新建" CommandUpdate="确定" ConfirmDelete="你确定要删除吗" Title="修改用户组信息" 
                                                        PopupEditFormCaption="修改用户组信息" />
                                        <Styles CssFilePath="~/App_Themes/Office2003Blue/{0}/styles.css" 
                                            CssPostfix="Office2003Blue">
                                            <Header HorizontalAlign="Center">
                                            </Header>
                                        </Styles>
                                    </dx:ASPxGridView>

2,后台主要代码（1）

// form_load中的 if(!this.IsPostBack){----}
// 省略号的部分包括以下内容

            sSQL = "select [AppID],[AppName] from [sysApp]";
            sqlDataSrcApp.SelectCommand = sSQL;
            sqlDataSrcApp.ConnectionString = Common.ConfigHelper.GetConfigString("ConnectionString");
            //= Common.Tool.GetDataTable(out sError, sSQL);
            if (!string.IsNullOrEmpty(sError)) { Common.MessageBox.Show(this, sError); return; }

            sSQL = "select [GroupID],[GroupName] from [sysGroup]";
            sqlDataSrcGroup.SelectCommand = sSQL;
            sqlDataSrcGroup.ConnectionString = Common.ConfigHelper.GetConfigString("ConnectionString");
            if (!string.IsNullOrEmpty(sError)) { Common.MessageBox.Show(this, sError); return; }

3，后台主要代码（2）

        protected void grvUserGroup_CellEditorInitialize(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditorEventArgs e)
        {
            string sSQL = string.Empty;
            if (grvUserGroup.IsNewRowEditing && e.Column.FieldName == "AppID")
            {
                sSQL = "select [AppID],[AppName] from [sysApp]";
                sqlDataSrcApp.SelectCommand = sSQL;
                sqlDataSrcApp.ConnectionString = Common.ConfigHelper.GetConfigString("ConnectionString");
                //= Common.Tool.GetDataTable(out sError, sSQL);
                if (!string.IsNullOrEmpty(sError)) { Common.MessageBox.Show(this, sError); return; }
            }
            else if (grvUserGroup.IsNewRowEditing && e.Column.FieldName == "GroupID")
            {
                sSQL = "select [GroupID],[GroupName] from [sysGroup]";
                sqlDataSrcGroup.SelectCommand = sSQL;
                sqlDataSrcGroup.ConnectionString = Common.ConfigHelper.GetConfigString("ConnectionString");
                if (!string.IsNullOrEmpty(sError)) { Common.MessageBox.Show(this, sError); return; }
            }
        }

4，grvUserGroup_RowInserting，grvUserGroup_RowUpdating，grvUserGroup_RowDeleting 自行实现