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();
}
}
}
private void GetCommodity()
{
SqlObj = new SqlString(ComObj);
string strcom = Session["Markseas_id"].ToString();
string strsql = "SELECT * FROM CommodityMaster where MarkSeasId='" + strcom + "'";
DataSet ds = SqlObj.selectAny(strsql);
if (ds.Tables[0].Rows.Count > 0)
{
DDL_Commodity.DataSource = ds.Tables[0];
DDL_Commodity.DataTextField = "CommodityName";
DDL_Commodity.DataValueField = "CommodityId";
DDL_Commodity.DataBind();
}
else
{
// nothing
}
}
private void GetCommodity()
{
try
{
SqlObj = new SqlString(ComObj);
string strcom = Session["StateLog_MarkID"].ToString();
string strsql = "SELECT * FROM CommodityMaster where MarkSeasId='" + strcom + "'";
DataSet ds = SqlObj.selectAny(strsql);
if (ds.Tables[0].Rows.Count > 0)
{
DDL_Commodity.DataSource = ds.Tables[0];
DDL_Commodity.DataTextField = "CommodityName";
DDL_Commodity.DataValueField = "CommodityId";
DDL_Commodity.DataBind();
DDL_Commodity.Items.Insert(0, "--Select--");
}
}
catch (Exception ex)
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('" + ex.Message + "'); </script> ");
}
}
private void GetCommodity(string comdity)
{
SqlObj = new SqlString(ComObj);
ds = new DataSet();
try
{
if (DDL_MarSeas.SelectedItem.Text != "--Select--")
{
string strSql = "select * from CommodityMaster where MarkSeasId='" + comdity + "'";
ds = SqlObj.selectAny(strSql);
if (ds.Tables[0].Rows.Count > 0)
{
DDL_Commodity.DataSource = ds.Tables[0];
DDL_Commodity.DataTextField = "CommodityName";
DDL_Commodity.DataValueField = "CommodityId";
DDL_Commodity.DataBind();
DDL_Commodity.Items.Insert(0, "--Select--");
}
}
else
{
DDL_Commodity.Items.Clear();
}
}
catch (Exception ex)
{
DivMsg.InnerText = ex.Message;
}
finally
{
SqlObj = null;
ds = null;
}
}
