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