private void GetCrpyear() { try { SqlObj = new SqlString(ComObj); string str = "SELECT CropId,CropYear FROM CropYearMaster where CropId in('8') "; DataSet ds = SqlObj.selectAny(str); if (ds == null) { } else { DDL_CropYear.DataSource = ds.Tables[0]; DDL_CropYear.DataTextField = "CropYear"; DDL_CropYear.DataValueField = "CropId"; DDL_CropYear.DataBind(); //DDL_CropYear.Items.Insert(0, "--Select--"); DDL_CropYear.SelectedValue = "8"; } } catch (Exception ex) { Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('" + ex.Message + "'); </script> "); } }
private void GetCropYear() { SqlObj = new SqlString(ComObj); string str = "SELECT * FROM CropYearMaster"; DataSet ds = SqlObj.selectAny(str); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { DDL_CropYear.DataSource = ds.Tables[0]; DDL_CropYear.DataTextField = "CropYear"; DDL_CropYear.DataValueField = "CropId"; DDL_CropYear.DataBind(); } } }