private void PopulateSearchDropdowns() { LeadTime_Dropdown objData = (new Report_DL()).GetDropdownData(); lbPartyName.DataSource = objData.lst_PartyName; lbPartyName.DataBind(); lbItemName.DataSource = objData.lst_StockItemName; lbItemName.DataBind(); }
public LeadTime_Dropdown GetDropdownData() { LeadTime_Dropdown ddlData = new LeadTime_Dropdown(); Common.OpenConnection(); try { //--- Party Drop Down ---- ddlData.lst_PartyName = new List <string>(); ddlData.lst_PartyName.Add("select"); String sql = "Select distinct PartyName from TD_Txn_VchHdr where Len(PartyName)>2 order by PartyName "; SqlCommand cmd = new SqlCommand(sql, Common.conn); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { ddlData.lst_PartyName.Add(Common.GetString(rdr["PartyName"])); } rdr.Close(); //--- lst_StockItemName Drop Down ---- ddlData.lst_StockItemName = new List <string>(); ddlData.lst_StockItemName.Add("select"); sql = "select distinct StockItemName from TD_Txn_InvLine where Len(StockItemName)>2 order by StockItemName"; cmd = new SqlCommand(sql, Common.conn); rdr = cmd.ExecuteReader(); while (rdr.Read()) { ddlData.lst_StockItemName.Add(Common.GetString(rdr["StockItemName"])); } rdr.Close(); } catch (Exception ex) { } finally { Common.CloseConnection(); } return(ddlData); }