asp.net – 如何在ASpxGridView中以编程方式选择ASPxComboBox中

我需要使用DevExpress ASPxGridView.我有一个数据源对象,它返回两个重要的列,ObjectType和ObjectID. ObjectType可以是患者或医生. ObjectID是一个i??nt值,给出患者或医师的ID.希望这是有道理的. ObjectID由Patient表或Physician表选择,它们是indendent表,因此我无法以任何方式加入它们.

表结构如下所示：

对象表：ObjectType varchar(“Physician”或“Patient”),ObjectID int

Dogs Table ID int,Name varchar

Cats表ID int,名称varchar

我已经能够通过组合框来编写适当的objectType,并使用两个控件cbPatient和cbPhysician来编写ObjectID,这些控件由数据源填充.

我无法弄清楚当我编辑ASPxGridView时,如何在cbPatient或cbPhysician中显示对象值.例如,如果ObjectType是Cats并且ObjectID是1,那么我想在cbCats中显示与ID为1对应的名称.

这就是代码的外观.现在,无论出于何种原因,在某些情况下,所选值在某些时候变为空白.我不确定要运行此代码的事件.

protected void grid_HtmlRowCreated(object sender,DevExpress.Web.ASPxGridView.ASPxGridViewTableRowEventArgs e)
{
    if (e.RowType != DevExpress.Web.ASPxGridView.GridViewRowType.EditForm) return;
    if (grid.IsNewRowEditing || grid.IsEditing)
    {
        int val = (int)grid.GetRowValues(grid.EditingRowVisibleIndex,"ObjectID" );

        ASPxComboBox cbPatient = ((ASPxComboBox)grid.FindEditRowCellTemplateControl(grid.Columns["PatientID"] as GridViewDataComboBoxColumn,"cbPatient"));
        if (val != 0)
        {
            string objectID = grid.GetRowValues(grid.EditingRowVisibleIndex,"ObjectID").ToString();

            if (cbPatient.Items.Count > 0)
            {
                cbPatient.Items[1].Selected = true;
            }
            else
            {
                cbPatient.DataSource = dsPatName;
                cbPatient.DataBindItems();
                if (cbPatient.Items.Count > 0)
                    cbPatient.Items[1].Selected = true;
            }

        }
    }

}

这是ASPX代码.

</dx:GridViewDataComboBoxColumn>
<dx:GridViewDataComboBoxColumn Caption="Patient Name" FieldName="PatientID"  Name="PatName"  Visible="false">
    <PropertiesComboBox TextField="Name" ValueField="ID" ValueType="System.Int32"></PropertiesComboBox>
    <EditItemTemplate>
        <dx:ASPxComboBox ID="cbPatient" runat="server"  TextField="Name" ValueField="ID"
        Value='<%# Bind("PatientID") %>' AutoPostBack="false" ValueType="System.Int32" > </dx:ASPxComboBox>
    </EditItemTemplate>
</dx:GridViewDataComboBoxColumn>

protected void cbPatient_DataBound(object sender,EventArgs e)
{
    object rightsindex = grid.GetRowValues(grid.EditingRowVisibleIndex,"Rights");
    if (rightsindex == null) return;
    int rights = Int32.Parse(grid.GetRowValues(grid.EditingRowVisibleIndex,"Rights").ToString());
    object objectID = grid.GetRowValues(grid.EditingRowVisibleIndex,"ObjectID");

    ASPxComboBox cbPatient = ((ASPxComboBox)grid.FindEditRowCellTemplateControl(grid.Columns["PatientID"] as GridViewDataComboBoxColumn,"cbPatient"));
    if (cbPatient != null && cbPatient.Items.Count > 1)
    {

        if (rights == 8)
        {
            ListEditItem pt = cbPatient.Items.FindByValue(objectID);
            if (pt != null && Session["PatientID"] == null)
            {
                cbPatient.Items[pt.Index].Selected = true;
                Session["PatientID"] = (Int32)pt.Value;

            }
        }
            //cbPatient.Items[1].Selected = true;
    }
}

<dx:GridViewDataComboBoxColumn Caption="Patient Name" FieldName="PatientID"  Name="PatName"  Visible="false">
    <PropertiesComboBox DataSourceID="dsPatName" TextField="Name" ValueField="ID" ValueType="System.Int32">
    </PropertiesComboBox>
    <EditItemTemplate>
        <dx:ASPxComboBox ID="cbPatient" runat="server" DataSourceID="dsPatName" TextField="Name" ValueField="ID"
        Value='<%# Bind("PatientID") %>' AutoPostBack="false" ValueType="System.Int32" ondatabound="cbPatient_DataBound" > </dx:ASPxComboBox>
    </EditItemTemplate>
</dx:GridViewDataComboBoxColumn>