Hi mvadukul,
Refer the below code.
HTML
<div>
<div id="Services">
<div class="col-md-12" style="background-color: #f2f2f2; border-top-left-radius: 6px;
border-top-right-radius: 6px;">
<div class="row">
<div class="col-md-3" style="background-color: #ececec; border-top-left-radius: 6px;">
<h3>
Filter Result</h3>
</div>
<div class="col-md-9" style="background-color: #ececec; border-left: 1px solid #e0e0e0;
border-top-right-radius: 6px;">
<h3>
Search Result</h3>
</div>
<div class="col-md-3">
<h3>
Working Hours</h3>
<asp:HiddenField ID="hfWorkingHRS" runat="server" />
<asp:HiddenField ID="hfContractType" runat="server" />
<asp:HiddenField ID="hfTypeOfSchool" runat="server" />
<asp:DataList ID="dlWorkingHRS" runat="server" RepeatDirection="Vertical">
<ItemTemplate>
<table>
<tr>
<td>
<asp:LinkButton Text='<%#Eval("WorkingHRS") %>' ID="chkWorkingHRS" CommandArgument="WorkingHRS"
runat="server" OnClick="OnSelect" />
<%-- <asp:CheckBox ID="chkWorkingHRS" Text='<%#Eval("WorkingHRS") %>' runat="server" OnCheckedChanged="OnChange"
AutoPostBack="true" />--%>
</td>
<td>
<asp:Label ID="lblWorkingHours" Text='<%#Eval("Count")== "" ? "[ "+"0"+" ]" : "[ "+Eval("Count")+" ]" %>'
runat="server" />
</td>
</tr>
</table>
</ItemTemplate>
</asp:DataList>
<hr />
<h3>
Contract Type</h3>
<asp:DataList ID="dlContractType" runat="server" RepeatDirection="Vertical">
<ItemTemplate>
<table>
<tr>
<td>
<asp:LinkButton Text='<%#Eval("Contract") %>' ID="chkContractType" CommandArgument="Contract"
runat="server" OnClick="OnSelect" />
<%--<asp:CheckBox ID="chkContractType" Text='<%#Eval("Contract") %>' runat="server" OnCheckedChanged="OnChange"
AutoPostBack="true" />--%>
</td>
<td>
<asp:Label ID="lblContractType" Text='<%#Eval("Count")== "" ? "[ "+"0"+" ]" : "[ "+Eval("Count")+" ]" %>'
runat="server" />
</td>
</tr>
</table>
</ItemTemplate>
</asp:DataList>
<hr />
<h3>
Type of School</h3>
<asp:DataList ID="dlTypeOfSchool" runat="server" RepeatDirection="Vertical">
<ItemTemplate>
<table>
<tr>
<td>
<asp:LinkButton Text='<%#Eval("OrgType") %>' ID="chkTypeOfSchool" CommandArgument="OrgType"
runat="server" OnClick="OnSelect" />
<%--<asp:CheckBox ID="chkTypeOfSchool" Text='<%#Eval("OrgType") %>' runat="server" OnCheckedChanged="OnChange"
AutoPostBack="true" />--%>
</td>
<td>
<asp:Label ID="lblTypeOfSchool" Text='<%#Eval("Count")== "" ? "[ "+"0"+" ]" : "[ "+Eval("Count")+" ]" %>'
runat="server" />
</td>
</tr>
</table>
</ItemTemplate>
</asp:DataList>
<hr />
</div>
<div class="col-md-9" style="border-left: 1px solid #e0e0e0; padding: 5px;">
<asp:DataList ID="dlJobListing" runat="server" DataKeyField="JobID" CssClass="Mytable Mytable-hover "
BackColor="White">
<ItemTemplate>
<div class="col-md-3 hidden-xs ">
<div class="row">
<p>
<asp:Image ID="LogoLabel" CssClass="ImageLogo" Width="133px" Height="112px" runat="server" />
</p>
<asp:Button ID="btnJobDetails" runat="server" Width="132px" Text="Job Details" CssClass="btn btn-mine btn-block" />
<asp:Button ID="btnSaveJobs" runat="server" Width="132px" Text="Save Job" CssClass="btn btn-mine btn-block" />
<asp:Button ID="btnEmialJobs" runat="server" Width="132px" Text="Email Job" CssClass="btn btn-mine btn-block" />
</div>
</div>
<div class="col-md-9" style="margin-top: -15px;">
<div class="row">
<h3 style="color: #008001">
<asp:Label ID="JobNameLabel" runat="server" Text='<%# Eval("JobName") %>' />
</h3>
<h5>
<b>
<asp:Label ID="OrgNameLabel" runat="server" Text='<%# Eval("OrgName") %>' />
</b>
</h5>
<asp:Label ID="ShortDescLabel" runat="server" Text='<%# Eval("ShortDesc") %>' />
<br />
<br />
<asp:Label ID="SalaryFromLabel" runat="server" Text='<%# "£" + Eval("SalaryFrom") %>' />-
<asp:Label ID="SalaryToLabel" runat="server" Text='<%# "£" + Eval("SalaryTo") %>' />,
<asp:Label ID="ContractLabel" runat="server" Text='<%# " " + Eval("Contract") %>' />,
<asp:Label ID="WorkingHRSLabel" runat="server" Text='<%# " " + Eval("WorkingHRS") %>' />,
<asp:Label ID="JobCategoryNameLabel" runat="server" Text='<%# " " + Eval("JobCategoryName") %>' />
<asp:Label ID="JobIDLabel" runat="server" Text='<%# Eval("JobID") %>' Visible="false" />
<div class="text-right">
<asp:Button ID="btnApplyNow" runat="server" Text="Apply Now" CssClass="btn btn-success" />
</div>
</div>
</div>
</ItemTemplate>
</asp:DataList>
</div>
</div>
</div>
</div>
</div>
Code
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
BindDatalist("", "", "");
dlWorkingHRS.DataSource = DataTable("GetWorkingHRSCheckBox", "", "", "");
dlWorkingHRS.DataBind();
dlContractType.DataSource = DataTable("GetContractCheckBox", "", "", "");
dlContractType.DataBind();
dlTypeOfSchool.DataSource = DataTable("GetOrgTypeCheckBox", "", "", "");
dlTypeOfSchool.DataBind();
}
}
private DataTable DataTable(string query, string workingHRS, string contract, string orgType)
{
DataTable dt = new DataTable();
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
con.Open();
using (SqlCommand cmd = new SqlCommand(query))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
cmd.Parameters.AddWithValue("@WorkingHRS", workingHRS);
cmd.Parameters.AddWithValue("@Contract", contract);
cmd.Parameters.AddWithValue("@OrgType", orgType);
sda.SelectCommand = cmd;
sda.Fill(dt);
}
}
con.Close();
}
return dt;
}
private void BindDatalist(string WorkingHRS, string Contract, string OrgType)
{
DataTable dt = new DataTable();
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
con.Open();
using (SqlCommand cmd = new SqlCommand("Getmvadukul"))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
cmd.Parameters.AddWithValue("@WorkingHRS", WorkingHRS);
cmd.Parameters.AddWithValue("@Contract", Contract);
cmd.Parameters.AddWithValue("@OrgType", OrgType);
sda.SelectCommand = cmd;
sda.Fill(dt);
}
}
con.Close();
}
dlJobListing.DataSource = dt;
dlJobListing.DataBind();
}
protected void OnSelect(object sender, EventArgs e)
{
string workingHRS = "", contractType = "", typeOfSchool = "";
if ((sender as LinkButton).CommandArgument == "WorkingHRS")
{
workingHRS = (sender as LinkButton).Text;
}
if ((sender as LinkButton).CommandArgument == "Contract")
{
contractType = (sender as LinkButton).Text;
}
if ((sender as LinkButton).CommandArgument == "OrgType")
{
typeOfSchool = (sender as LinkButton).Text;
}
dlWorkingHRS.DataSource = DataTable("GetWorkingHRSCheckBox", workingHRS, contractType, typeOfSchool);
dlWorkingHRS.DataBind();
dlContractType.DataSource = DataTable("GetContractCheckBox", workingHRS, contractType, typeOfSchool);
dlContractType.DataBind();
dlTypeOfSchool.DataSource = DataTable("GetOrgTypeCheckBox", workingHRS, contractType, typeOfSchool);
dlTypeOfSchool.DataBind();
BindDatalist(workingHRS, contractType, typeOfSchool);
}
