public void loadsession()
{
try
{
ds.Clear();
cbl_sessionname.Items.Clear();
string itemheader = "";
for (int i = 0; i < cbl_hostelname.Items.Count; i++)
{
if (cbl_hostelname.Items[i].Selected == true)
{
if (itemheader == "")
{
itemheader = "" + cbl_hostelname.Items[i].Value.ToString() + "";
}
else
{
itemheader = itemheader + "'" + "," + "" + "'" + cbl_hostelname.Items[i].Value.ToString() + "";
}
}
}
if (itemheader.Trim() != "")
{
//string selecthostel = "select distinct Session_Code,Session_Name from Session_Master where Hostel_Code in ('" + itemheader + "')";
//ds = d2.select_method_wo_parameter(selecthostel, "Text");
ds = d2.BindSession_inv(itemheader);
if (ds.Tables[0].Rows.Count > 0)
{
cbl_sessionname.DataSource = ds;
cbl_sessionname.DataTextField = "SessionName";
cbl_sessionname.DataValueField = "SessionMasterPK";
cbl_sessionname.DataBind();
if (cbl_sessionname.Items.Count > 0)
{
for (int i = 0; i < cbl_sessionname.Items.Count; i++)
{
cbl_sessionname.Items[i].Selected = true;
cb_sessionname.Checked = true;
}
txt_sessionname.Text = "Session Name(" + cbl_sessionname.Items.Count + ")";
}
}
else
{
txt_sessionname.Text = "--Select--";
}
}
else
{
txt_sessionname.Text = "--Select--";
}
}
catch
{
}
}
