前台:
<ext:ComboBox ID="cbxsalesman" runat="server" FieldLabel="业务员" Width="150" DisplayField="UserName" ValueField="UserId" StoreID="Store3"> <Triggers> <ext:FieldTrigger Icon="Clear" Qtip="移除选项" /> </Triggers> <Listeners> <TriggerClick Handler="this.removeByValue(this.getValue());this.clearValue();" /> </Listeners> </ext:ComboBox>
后台;
string strSql = string.Format("select distinct [name] as username,users.id from [JobTypeDetail] inner join users on JobTypeDetail.UserId=users.id where 1=1 "); strSql += "order by username ASC"; DataTable table = SqlHelper.ExecuteDataset(SqlHelper.conn, CommandType.Text, strSql).Tables[0]; List<SalesMan> QList = new List<SalesMan>(); foreach (DataRow row in table.Rows) { SalesMan sm= new SalesMan(); sm.UserName = Convert.ToString(row["username"]); sm.UserId = Convert.ToString(row["id"]); QList.Add(sm); } this.Store3.DataSource = QList; this.Store3.DataBind();