private void GetCommodity()
{
try
{
if (Session["pcId"] != null)
{
CdObj = new comodity(ComObj);
string strcom = Session["Markseas_id"].ToString();
string strsql = "SELECT * FROM CommodityMaster where MarkSeasId='" + strcom + "'";
DataSet ds = CdObj.selectAny(strsql);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
DDL_Commodity.DataSource = ds.Tables[0];
DDL_Commodity.DataTextField = "CommodityName";
DDL_Commodity.DataValueField = "CommodityId";
DDL_Commodity.DataBind();
}
}
}
}
catch (Exception ex)
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('" + ex.Message + "'); </script> ");
}
}
private void getCommodity(string strcom)
{
CdObj = new comodity(ComObj);
//string strcom = Session["Markseas_id"].ToString();
string strsql = "SELECT * FROM CommodityMaster where MarkSeasId='" + strcom + "'";
DataSet ds = CdObj.selectAny(strsql);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
DDL_Commodity.DataSource = ds.Tables[0];
DDL_Commodity.DataTextField = "CommodityName";
DDL_Commodity.DataValueField = "CommodityId";
DDL_Commodity.DataBind();
}
}
}