checkbox inside datalist

See more:

SQL-Server-2005

C#

ASP.NET

, +

Hello,

I am developing a project in which i am having checkbox inside the datalist,
if i select one checkbox i have retrieve the things related to that name. i am not getting how to do that.please help me.

my aspx code is

<asp:DataList ID="datalist1" runat="server" Width="152px" >
<ItemTemplate>
<asp:CheckBox ID="services_checkbox" runat="server"
  Text='<%#Eval(" BUSINESSUPLOAD_SERVICES_SERVICENAME") %>' AutoPostBack="true" OnCheckedChanged="services_checkbox__CheckedChanged"   />
</ItemTemplate>
        </asp:DataList>

        <asp:DataList ID="datalist2" runat="server">
        <ItemTemplate>
        <asp:CheckBox ID="subservices_checkbox" runat="server" Text='<%#Eval("MEDICALVOYAGER_BUSINESSUPLOAD_SUBSERVICES") %>' AutoPostBack="true"/>
        </ItemTemplate>
        </asp:DataList>

my code behind page is,

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

public partial class servicesdatalist : System.Web.UI.Page
{   
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            services();
        }
    }
    protected void services()
    {
        SqlConnection con = new SqlConnection("Data Source=USER-PC\\SQLEXPRESS;Initial Catalog=MEDICALVOYAGER;Integrated Security=True");
     
        con.Open();
        SqlCommand com = new SqlCommand("SELECT BUSINESSUPLOAD_SERVICES_SERVICENAME FROM MEDICALVOYAGER_BUSINESSUPLOAD_SERVICES", con);
        SqlDataReader dr = com.ExecuteReader();
        datalist1.DataKeyField = "BUSINESSUPLOAD_SERVICES_SERVICENAME";

        datalist1.DataSource = dr;
        datalist1.DataBind();
        con.Close();
    }
    protected void services_checkbox__CheckedChanged(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection("Data Source=USER-PC\\SQLEXPRESS;Initial Catalog=MEDICALVOYAGER;Integrated Security=True");
        con.Open();
        ;
        //SqlCommand com = new SqlCommand("SELECT * FROM MEDICALVOYAGER_BUSINESSUPLOAD_SUBSERVICES where BUSINESSUPLOAD_SERVICES_SERVICENAME= '"+datalist1.SelectedValue.ToString()+"'", con);
        SqlCommand com = new SqlCommand("SELECT * FROM MEDICALVOYAGER_BUSINESSUPLOAD_SUBSERVICES where BUSINESSUPLOAD_SERVICES_SERVICENAME=@ser", con);
        com.Parameters.AddWithValue("@ser", datalist1.SelectedItem.ToString());
        SqlDataReader dr = com.ExecuteReader();

        datalist2.DataSource = dr;
        datalist2.DataBind();
        con.Close();
    }    
}

my table is as follows,

CREATE TABLE MEDICALVOYAGER_BUSINESSUPLOAD_SERVICES
(BUSINESSUPLOAD_SERVICES_SERVICEID INT IDENTITY(1,1),
BUSINESSUPLOAD_SERVICES_SERVICENAME VARCHAR(100)PRIMARY KEY)

CREATE TABLE MEDICALVOYAGER_BUSINESSUPLOAD_SUBSERVICES
(BUSINESSUPLOAD_SUBSERVICES_SUBSERVICESID INT  IDENTITY(1,1),
BUSINESSUPLOAD_SUBSERVICES_SUB_SERVICENAME VARCHAR(100)PRIMARY KEY,
BUSINESSUPLOAD_SERVICES_SERVICENAME VARCHAR(100) FOREIGN KEY REFERENCES MEDICALVOYAGER_BUSINESSUPLOAD_SERVICES(BUSINESSUPLOAD_SERVICES_SERVICENAME) ON DELETE CASCADE)

CREATE TABLE MEDICALVOYAGER_BUSINESSUPLOAD_SUBSERVICES_CATEGORIES
(BUSINESSUPLOAD_BUSINESSUPLOAD_SUBSERVICES_CATEGORIESID INT IDENTITY(1,1),
BUSINESSUPLOAD_SUBSERVICES_SUBSERVICES_CATEGORIESNAME VARCHAR(100)PRIMARY KEY,
BUSINESSUPLOAD_SUBSERVICES_SUB_SERVICENAME VARCHAR(100) FOREIGN KEY REFERENCES MEDICALVOYAGER_BUSINESSUPLOAD_SUBSERVICES(BUSINESSUPLOAD_SUBSERVICES_SUB_SERVICENAME)ON DELETE CASCADE)

if i check on services, subservices related to that has to be displayed, if i check subservices, categories related to subservices has to be displayed.

please help me to come out of this......[Removed Urgency]