通过DataTable数据源初始化ComboBox

2014-12-31 13:44:47 访问(1799) 赞(0) 踩(0)


        /// <summary>
        /// 通过DataTable数据源初始化ComboBox
        /// </summary>
        /// <param name="cbb"></param>
        /// <param name="dt"></param>
        public void ComboBoxInitByBasicDataTable
            (
                ComboBox cbb, 
                DataTable dt
            )
        {

            cbb.Items.Clear();

            int iCount = dt.Rows.Count;

            if (iCount == 0)
                return;

            DataRow dr = null;

            for (int i = 0; i < iCount; ++i)
            {
                dr = dt.Rows[i];

                cbb.Items.Add
                    (
                        new ComboBoxItem
                            (
                                dr[DataColumnName.TheName].ToString(),
                                dr[DataColumnName.ID].ToString()
                            )
                    );
            }

            cbb.SelectedIndex = 0;
        }


       
        /// <summary>
        /// 通过DataTable数据源初始化ComboBox
        /// </summary>
        /// <param name="cbb"></param>
        /// <param name="dt"></param>
        /// <param name="TextField"></param>
        /// <param name="ValueField"></param>
        public void ComboBoxInitByBasicDataTable
            (
                ComboBox cbb,
                DataTable dt,
                string TextField,
                string ValueField
            )
        {

            cbb.Items.Clear();

            int iCount = dt.Rows.Count;

            if (iCount == 0)
                return;

            DataRow dr = null;

            for (int i = 0; i < iCount; ++i)
            {
                dr = dt.Rows[i];

                cbb.Items.Add
                    (
                        new ComboBoxItem
                            (
                                dr[TextField].ToString(),
                                dr[ValueField].ToString()
                            )
                    );
            }

            cbb.SelectedIndex = 0;
        }