public void loadheadername()
{
try
{
cbl_headername.Items.Clear();
string group_code = Session["group_code"].ToString();
string columnfield = "";
if (group_code.Contains(';'))
{
string[] group_semi = group_code.Split(';');
group_code = group_semi[0].ToString();
}
if ((group_code.ToString().Trim() != "") && (Session["single_user"].ToString() != "1" && Session["single_user"].ToString() != "true" && Session["single_user"].ToString() != "TRUE" && Session["single_user"].ToString() != "True"))
{
columnfield = " and group_code='" + group_code + "'";
}
else
{
columnfield = " and usercode='" + Session["usercode"] + "'";
}
string maninvalue = "";
string selectnewquery = d2.GetFunction("select value from Master_Settings where settings='ItemHeaderRights' " + columnfield + "");
if (selectnewquery.Trim() != "" && selectnewquery.Trim() != "0")
{
string[] splitnew = selectnewquery.Split(',');
if (splitnew.Length > 0)
{
for (int row = 0; row <= splitnew.GetUpperBound(0); row++)
{
if (maninvalue == "")
{
maninvalue = Convert.ToString(splitnew[row]);
}
else
{
maninvalue = maninvalue + "'" + "," + "'" + Convert.ToString(splitnew[row]);
}
}
}
}
ds.Clear();
ds = d2.BindItemHeaderWithRights_inv();
if (ds.Tables[0].Rows.Count > 0)
{
cbl_headername.DataSource = ds;
cbl_headername.DataTextField = "ItemHeaderName";
cbl_headername.DataValueField = "ItemHeaderCode";
cbl_headername.DataBind();
if (cbl_headername.Items.Count > 0)
{
for (int i = 0; i < cbl_headername.Items.Count; i++)
{
cbl_headername.Items[i].Selected = true;
}
txt_headername.Text = "Header Name(" + cbl_headername.Items.Count + ")";
}
}
else
{
txt_headername.Text = "--Select--";
}
}
catch
{
}
}
