这个代码可以将一个字段所有值载入一个DropDownList里，那如何将多个字段一一对应载入多个DropDownList里？

Question

这个代码可以将一个字段所有值载入一个DropDownList里，那如何将多个字段一一对应载入多个DropDownList里？         protected void SetDate(DropDownList ddTist, string SqlTxt, string Field)
        {
            SqlConnection connTmp = new SqlConnection();
            connTmp.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
            DataSet dsTmp = new DataSet();
            SqlDataAdapter daTmp = new SqlDataAdapter(SqlTxt, connTmp);
            try
            {
                connTmp.Open();
                daTmp.Fill(dsTmp, Field);
                ddTist.Items.Clear();
                ddTist.DataTextField = Field;
                ddTist.DataValueField = Field;
                ddTist.DataSource = dsTmp.Tables[Field];
                ddTist.DataBind();
            }
            finally
            {
                daTmp.Dispose();
                dsTmp.Dispose();
                connTmp.Close();
                connTmp.Dispose();
                daTmp = null;
                dsTmp = null;
                connTmp = null;
            }
        }

Answer 1

调用SetDate(DropDownList ddTist, string SqlTxt, string Field)
就是

Answer 2

 SetDate(DropDownList [] ddTist, string SqlTxt, string [] Field)
 DataReader读取 绑定

Answer 3

        /// <summary>
        /// 通过SQL绑定下拉列表
        /// </summary>
        /// <param name="sql">执行SQL,通过上面的DATASET返回DS</param>
        /// <param name="ddl">要绑定的下拉列表</param>
        public static void InitDdlbySql(string sql, ComboBox ddl)
        {
            DataTable dt = new DataTable();
            try
            {
                dt = clsDbOper.GetDataTable(sql);
                ArrayList Item = new ArrayList();
                Item.Add(new DictionaryEntry("-请选择-", "0"));                int RowCount = dt.Rows.Count;
                int i;
                if (RowCount != 0)
                {
                    DataRow dr = null;
                    for (i = 0; i < RowCount; i++)
                    {
                        dr = dt.Rows[i];
                        Item.Add(new DictionaryEntry(dr[1].ToString().Trim(), dr[0].ToString().Trim()));
                        
                    }
                }
                ddl.DataSource = Item;
                ddl.ValueMember = "Value";
                ddl.DisplayMember = "Key";
                ddl.SelectedIndex = 0;
            }
            finally
            {
                dt.Dispose();
            }
        }