c# - 数据源的类型无效。它必须是 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();
}