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);
}
