'ddReceivedby'具有一个无效的SelectedValue，因为它不存在于项列表中。 [英] 'ddReceivedby' has a SelectedValue which is invalid because it does not exist in the list of items.

问题描述

public void LoadInventory(int ID)
    {
        btnSave.Text = "Update";
        DataTable dt = new DataTable();
        SilkSchoolProvider SqlProvider = new SilkSchoolProvider();
        dt = SqlProvider.SpGetInventoryOutByID(ID);
        
        ddBranch.SelectedValue = dt.Rows[0]["CampusID"].ToString();
        ddItems.SelectedValue = dt.Rows[0]["Item_ID"].ToString();
        ddStores.SelectedValue = dt.Rows[0]["Store_ID"].ToString();
        txtQuantity.Text = dt.Rows[0]["Quentity"].ToString();
        txtRate.Text = dt.Rows[0]["Rate"].ToString(); ;
        txtTotalAmount.Text = dt.Rows[0]["TotalAmount"].ToString(); ;
        txtDateOfOrder.Text = dt.Rows[0]["Date_of_Order"].ToString(); ;
        txtDateofReceiving.Text = dt.Rows[0]["Date_of_Delivery"].ToString(); ;
        ddDeliveredby.SelectedValue = dt.Rows[0]["EmployeeID"].ToString();
        ddReceivedby.SelectedValue = dt.Rows[0]["EmployeeID"].ToString();
        //txtItem.Text = dt.Rows[0]["Item"].ToString(); ;
        
        //ddDeliveredby.SelectedValue= dt.Rows[0]["DeliverBy"].ToString(); ;
        //ddReceivedby.SelectedValue= dt.Rows[0]["ReceivedBy"].ToString(); ;
        txtRemarks.Text = dt.Rows[0]["Remarks"].ToString();

    }

推荐答案

运行查询从表中选择EmployeeID 然后检查你是否得到了结果。

错误表明该列中不存在该列。

Run the query select EmployeeID from table and then check if you get a result.
The error suggests this column does not exist in the table.

这篇关于'ddReceivedby'具有一个无效的SelectedValue，因为它不存在于项列表中。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！