1、利用cs包,DataAccess.cs
#region
string m_str = @"select sname from service group by sname";
DataTable m_dt = DataAccess.DBHelper.GetList(m_str);
DropDownList2.DataValueField = "sname";
DropDownList2.DataTextField = "sname";
绑定数据源
this.DropDownList2.DataSource = m_dt;
DropDownList2.DataBind()