----------------------------------------------------页面-----------------------------------------------------------
<asp:TemplateField HeaderText="销售情况">
<ItemTemplate>
<asp:DropDownList ID="SellState" runat="server" DataSource='<%# ddlbind()%>'
DataValueFiled="SellState" DataTextFiled="SellState" OnSelectedChanged="DropDownList_SelectedChanged"
AutoPostBack="true">
</asp:DropDownList>
</ItemTemplate>
</asp:TemplateField>
//后台查询方法
public SqlDataReader ddlbind()
{
string strsql="select distinct SellState from Sellbook";
SqlConnection conn = GetConnection();
SqlCommand cmd = new SqlCommand(strsql,conn);
cmd.open();
return cmd.ExecuteReader();
}