首页 > 解决方案 > 数据源的类型无效。它必须是 IListSource、IEnumerable 或 IDataSource。绑定数据时包含以下错误

问题描述

我无法将数据绑定到我的下拉控件。它将我重定向回 catch-block 并显示错误:

数据源的类型无效。它必须是 IListSource、IEnumerable 或 IDataSource。

这是我的代码:

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Edge_ConnectionString"].ConnectionString.ToString());
try
{
    con.Open();
    SqlCommand cmd2 = new SqlCommand("SELECT DISTINCT CustomerCode,CustomerName FROM ufn_Fill_SalesOrder_Pending_Dispatch('E','','"+ usr.CmpyCode + "','','') Where SoType = 'F'", con);
    cmd2.CommandType = CommandType.Text;

    cmd2.Parameters.AddWithValue("@FillFor",'E');
    cmd2.Parameters.AddWithValue("@DispatchType", "");
    cmd2.Parameters.AddWithValue("@CmpyCode", usr.CmpyCode);
    cmd2.Parameters.AddWithValue("@ProjectCode", "");
    cmd2.Parameters.AddWithValue("@CustomerCode", "");

    //SqlDataReader Reader = cmd2.ExecuteReader();
    //cmd2.ExecuteNonQuery();
    SqlDataReader Reader = cmd2.ExecuteReader();
    // Reader = getReader(cmd2)

    if (cmd2 != null)
    {
        ddlCust.TextField = "CustomerName";
        ddlCust.ValueField = "CustomerCode";
        ddlCust.DataSource = cmd2;
        ddlCust.DataBind();
    }
}
catch (Exception ev)
{
    Response.Write(ev.Message.ToString());
}
finally
{
    con.Close();
}

标签: c#asp.net

解决方案


推荐阅读