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