怎么样才能在后台给gridview footer中的drowpdownlist控件绑定数据

[roycbl]

以下代码执行以后提示
“System.Web.UI.Control”不包含“DataSource”的定义，并且找不到可接受类型为“System.Web.UI.Control”的第一个参数的扩展方法“DataSource”(是否缺少 using 指令或程序集引用?)

该怎么样修改？
private void bindName()
{
string sqlName= "SELECT [Name] FROM [UserInfo] where JobState <> '人才库' and JobState <> '辞职' and JobState <> '辞退'";
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["con"]);
SqlDataAdapter da = new SqlDataAdapter(sqlName, con);
DataSet ds = new DataSet();
con.Open();
da.Fill(ds, "UserInfo");
//Response .Write ((DropDownList)gvUserSearch.FooterRow.FindControl("listName"));

(DropDownList)gvUserSearch.FooterRow.FindControl("listName").DataSource = ds;
(DropDownList)gvUserSearch.FooterRow.FindControl("listName").DataBind();
con.Close();
con.Dispose();
}

[roycbl]

怎么就没有人指点指点吗？

[liupersimmon]

参考书有

[namhyuk]

DropDownList ddl = GridView1.FooterRow.FindControl("listName") as DropDownList;
ddl.DataSource = 数据源；
ddl.DataValueField = "主关键字段";
ddl.DataTextField = "文本字段";
ddl.DataBind();

[KnowKjava]

引用楼主 roycbl 的回复:

以下代码执行以后提示
“System.Web.UI.Control”不包含“DataSource”的定义，并且找不到可接受类型为“System.Web.UI.Control”的第一个参数的扩展方法“DataSource”(是否缺少 using 指令或程序集引用?)

该怎么样修改？
private void bindName()
    {
        string sqlName= "SELECT [Name] FROM [UserInfo] where JobState <> '人才库' and JobState <> '辞职' and JobState <> '辞退'";
        SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["con"]);
        SqlDataAdapter da = new SqlDataAdapter(sqlName, con);
        DataSet ds = new DataSet();
        con.Open();
        da.Fill(ds, "UserInfo");
        //Response .Write ((DropDownList)gvUserSearch.FooterRow.FindControl("listName"));

        (DropDownList)gvUserSearch.FooterRow.FindControl("listName").DataSource = ds;
        (DropDownList)gvUserSearch.FooterRow.FindControl("listName").DataBind();
        con.Close();
        con.Dispose();
    }

gridview

[Myworld88ggc]

[Quote=引用 3 楼 namhyuk 的回复:]
DropDownList ddl = GridView1.FooterRow.FindControl("listName") as DropDownList;
ddl.DataSource = 数据源；
ddl.DataValueField = "主关键字段";
ddl.DataTextField = "文本字段";
ddl.DataBind();
[/Quote]

这个就行