private void BindReasonCode() { DataSet dsValue = customerDetail.GetMasterDetails("Tables", "TableCd as Code,TableCd+' - '+ ShortDsc as Name", " TableType='REAS'"); ddlReasonCode.DataSource = dsValue; ddlReasonCode.DataValueField = "Code"; ddlReasonCode.DataTextField = "Name"; ddlReasonCode.DataBind(); ddlReasonCode.Items.Insert(0, new ListItem("-- Select Delete Reason --")); }
private void BindPendingOrderCode() { DataSet dsValue = customerDetail.GetMasterDetails("listmaster,listdetail", "ListValue as 'Value',ListValue +'-'+ListDtlDesc as 'Code',ListValue +' - '+ListDtlDesc as 'Name'", " SequenceNo ='99' and listmaster.pListMasterID =listdetail.fListMasterID and listmaster.ListName='SOEOrderTypes' order by listdetail.ListValue"); ddlOrderType.DataSource = dsValue; ddlOrderType.DataValueField = "Code"; ddlOrderType.DataTextField = "Name"; ddlOrderType.DataBind(); ddlOrderType.Items.Insert(0, new ListItem("-- Select Order Type--")); }