protected void DDL_Dist_SelectedIndexChanged(object sender, EventArgs e) { try { sqlObj = new SqlString(ComObj); string str = "SELECT * FROM PurchaseCenterMaster,MarketingSeasonMaster where PurchaseCenterMaster.DistrictId = '" + DDL_Dist.SelectedValue + "' and PurchaseCenterMaster.MarkSeasId = '" + DDL_MarkSeas.SelectedValue + "' and cropyear ='" + DDL_CropYear.SelectedItem.Text + "' and MarketingSeasonMaster.MarkSeasId = PurchaseCenterMaster.MarkSeasId order by PurchaseCenterName "; //string str = "SELECT * FROM PurchaseCenterMaster,MarketingSeasonMaster where PurchaseCenterMaster.DistrictId = '" + DDL_Dist.SelectedValue + "' and PurchaseCenterMaster.MarkSeasId = '" + DDL_MarkSeas.SelectedValue + "' and cropyear ='" + DDL_CropYear.Text + "' and MarketingSeasonMaster.MarkSeasId = PurchaseCenterMaster.MarkSeasId order by PurchaseCenterName "; DataSet ds = sqlObj.selectAny(str); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { DDL_PC.DataSource = ds.Tables[0]; DDL_PC.DataTextField = "PurchaseCenterName"; DDL_PC.DataValueField = "PcId"; DDL_PC.DataBind(); } else { DDL_PC.Items.Clear(); } } DDL_PC.Items.Insert(0, "--Select--"); } catch (Exception ex) { Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('" + ex.Message + "'); </script> "); } }
private void getPurchaseCenter(string distid, string mid, string cropyear) { PcObj = new PurchaseCenter(ComObj); string str = "SELECT * FROM PurchaseCenterMaster,MarketingSeasonMaster where PurchaseCenterMaster.DistrictId = '" + distid + "' and PurchaseCenterMaster.MarkSeasId = '" + mid + "' and cropyear ='" + cropyear + "' and MarketingSeasonMaster.MarkSeasId = PurchaseCenterMaster.MarkSeasId order by PurchaseCenterName "; DataSet ds = PcObj.selectAny(str); if (ds == null) { } else { if (ds.Tables[0].Rows.Count > 0) { DDL_PC.DataSource = ds.Tables[0]; DDL_PC.DataTextField = "PurchaseCenterName"; DDL_PC.DataValueField = "PcId"; DDL_PC.DataBind(); } } }