checkboxes will be checked on particular condition in datalist

Question

0.00/5 (No votes)

See more:

Hi I am displaying datalist with checkboxes. Dispalying all subcategories using this code..

XML

<asp:DataList ID="subcategorydatalist" runat="server" RepeatColumns="3" RepeatDirection="Vertical">
    <ItemTemplate>
        <asp:CheckBox ID="chksubcategory" runat="server" Text='<%# Eval("SubCategory") %>' />
    </ItemTemplate>
</asp:DataList>

My requirement is that the subcategories are displayed from subcategories table. Subcategories which are present in ypinformation1 table should be checked and other will be unchecked.

aspx.cs:--
-----------

C#

protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["UserID"] != null && Session["UserID"] != "")
        {
            UPOBJ.U_UserID = Convert.ToString(Session["UserID"]);
            UPOBJ.U_UserType = Convert.ToInt32(Session["UserType"]);
            Session["ID"] = UPOBJ.U_UserID;
        }
        else
        {
            Response.Redirect("~/Login.aspx?ReturnUrl=" + Request.Url.PathAndQuery.Replace("&", "^"));
        }

        if (Request.QueryString["YPID"] != null && Request.QueryString["YPID"] != "")
        {
            LPOBJ.L_YPID = Convert.ToInt32(Request.QueryString["YPID"]);
        }
        else
        {
            AlertMessage("Please Select the Record For Editing");
            Response.Redirect("EditListing.aspx");
        }
        if (!IsPostBack)
        {
            dr = ABLOBJ.GetYPInformationListingByID(LPOBJ);
            if (dr.HasRows)
            {
                while (dr.Read())
                {
                    txtYPID.Text = dr["YPID"].ToString();
                    txtCategory.Text = dr["Category"] != null ? Convert.ToString(dr["Category"]) : "";
                    txtSubCategory.Text = dr["SubCategory"] != null ? Convert.ToString(dr["SubCategory"]) : "";
                    txtCompanyName.Text = dr["CompanyName"] != null ? Convert.ToString(dr["CompanyName"]) : "";
                    UPOBJ.U_Category = txtCategory.Text.ToString();
                }
            }
            ds = ABLOBJ.GetRelatedSubCategories(UPOBJ);
            ds1 = ABLOBJ.GetSelectedSubCategories(LPOBJ);


            subcategorydatalist.DataSource = ds;
            subcategorydatalist.DataBind();

        }

    }

all subcategories are displaying are displaying by the dataset ds..but my requirement which subcategories are present in ds1 that subcategories are checked remaining are unchecked..there is any chance for comparing the datasets

Posted 21-Apr-11 21:04pm

BHANU PRAKASH BYSANI

Updated 25-Apr-11 21:04pm

v3

Add a Solution

Comments

Ankur^\m/ 22-Apr-11 3:32am

You need to write a query and get required results from database. Then bind that table to your datalist.

BHANU PRAKASH BYSANI 22-Apr-11 4:30am

my requirement is dispalying all subcategories along with selected subcategories

Ankur^\m/ 22-Apr-11 5:12am

So write a query to do that. What's the problem?

BHANU PRAKASH BYSANI 22-Apr-11 5:52am

iam dispalying all subcategories with chesckboxes..when dispalying how can put the condition already they are in ypinformation table taht subcategories checkboxes were chekced true..

mksharma38 22-Apr-11 7:21am

unable to understand ur problem, what is ypinformation1

BHANU PRAKASH BYSANI 22-Apr-11 7:25am

i have a table that contains company names,other subcategoriesids as columns..it is ypinformation1 table..taht subcategories ids and subcategorys are present in subcategorys table..

mksharma38 22-Apr-11 7:35am

i am not getting u, pls give exact name of table and name of column of ur tables,
adn describe ur problem in detail
can' understand what u want to say.
"other subcategoriesids as columns..it is ypinformation1 table..taht subcategories ids and subcategorys are present in subcategorys table.."

BHANU PRAKASH BYSANI 22-Apr-11 7:45am

ypinformation1:--
---------------------
ypid int,companyname nvarchar(100),othersubcategorys nvarchar(100)

subcategories:-=-
------------------
subcategoryid int
subcategory nvarchar(100)

when user selects subcategorys that ids will be stored in other subcategories column..

when user wants to edit the subcategories i want to display all the subcategories from subcategories table with checkboxes along with his selcted subcategorys will be checked..

iam getting a problem in getting subcategory names..plz check the query
declare @subcategorys nvarchar(100)
set @subcategorys =(select othersubcategories from ypinformation1 where ypid=11)
print @subcategorys
select SubCategory from SubCategories where convert(nvarchar,SubCategoryID) in (@subcategorys)

the subcategories are not dispalying

mksharma38 22-Apr-11 8:06am

what is returning "print @subcategorys".

Also please try with "select SubCategory from SubCategories where SubCategoryID = @subcategorys"

BHANU PRAKASH BYSANI 22-Apr-11 8:10am

it is returning 1,2

mksharma38 26-Apr-11 2:55am

send the code of client side and server side with ur problem detail

BHANU PRAKASH BYSANI 26-Apr-11 3:05am

hi see once i updated my question..

3 solutions

Solution 2

SQL

declare @subcategorys nvarchar(100)

declare @sQuery NVarchar(max)

set @subcategorys =(select othersubcategories from ypinformation1 where ypid=10)

set @sQuery ='select SubCategory from SubCategories where SubCategoryID in ('+@subcategorys+')'

exec sp_executesql @sQuery

Posted 22-Apr-11 19:21pm

BHANU PRAKASH BYSANI

Solution 5

Here is my sample code, u can go through

<asp:datalist id="subcategorydatalist" runat="server" repeatcolumns="3" repeatdirection="Vertical" xmlns:asp="#unknown">
<itemtemplate>
<asp:checkbox id="chksubcategory" runat="server" text="<%# Eval(" id")="" %>"="" checked="<%# Eval(" selected")="">

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

Dim empTable As DataTable = New DataTable()
Dim dr As DataRow
empTable.Columns.Add(New DataColumn("Id"))
empTable.Columns.Add(New DataColumn("Selected", System.Type.GetType("System.Boolean")))
empTable.Columns("Selected").DefaultValue = False
dr = empTable.NewRow()
dr("Id") = "2"
empTable.Rows.Add(dr)
dr = empTable.NewRow()
dr("Id") = "3"
empTable.Rows.Add(dr)
dr = empTable.NewRow()
dr("Id") = "4"
empTable.Rows.Add(dr)

Dim empTable1 As DataTable = New DataTable()
empTable1.Columns.Add(New DataColumn("Id"))
dr = empTable1.NewRow()
dr("Id") = "2"
empTable1.Rows.Add(dr)
dr = empTable1.NewRow()
dr("Id") = "4"
empTable1.Rows.Add(dr)
For Each dr In empTable.Rows
If empTable1.Select("Id=" & dr("Id")).Length > 0 Then
dr("Selected") = True
End If
Next

subcategorydatalist.DataSource = empTable
subcategorydatalist.DataBind()
End Sub

Here i used directely datatable. in ur case u can have a boolen column in table of ds, which have all checkbox.
And set value true for those check box, those are in ds1.

Posted 25-Apr-11 23:45pm

mksharma38

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

mksharma38 · Accepted Answer · 2011-04-22T02:33:00

Solution 1

First create a finction in ur database

IF EXISTS(SELECT * FROM sysobjects WHERE ID = OBJECT_ID('StringSplitInTableFunction'))
DROP FUNCTION StringSplitInTableFunction
GO
CREATE FUNCTION StringSplitInTableFunction
(
@inputString VARCHAR(8000)
)
RETURNS @splitStringTable TABLE(sID VARCHAR(20))
AS
BEGIN
DECLARE @sTemp VARCHAR(10)
WHILE LEN(@inputString) > 0
BEGIN
SET @sTemp = LEFT(@inputString, ISNULL(NULLIF(CHARINDEX(',', @inputString) - 1, -1),
LEN(@inputString)))
SET @inputString = SUBSTRING(@inputString,ISNULL(NULLIF(CHARINDEX(',', @inputString), 0),
LEN(@inputString)) + 1, LEN(@inputString))
INSERT INTO @splitStringTable VALUES (@sTemp)
END
RETURN
END
Go

And replace ur query
select SubCategory from SubCategories where convert(nvarchar,SubCategoryID) in (@subcategorys)
by
select SubCategory from SubCategories where SubCategoryID in (StringSplitInTableFunction(@subcategorys))

and try, if any problem then reply

Posted 22-Apr-11 2:33am

mksharma38

Comments

BHANU PRAKASH BYSANI 22-Apr-11 8:36am

'StringSplitInTableFunction' is not a recognized built-in function name. THIS ERROR IAM GETTING

mksharma38 22-Apr-11 8:38am

replace query
select SubCategory from SubCategories where SubCategoryID in (StringSplitInTableFunction(@subcategorys))

by

select SubCategory from SubCategories where SubCategoryID in (select sId from StringSplitInTableFunction(@subcategorys))

mksharma38 22-Apr-11 8:40am

now r u geting subcategory names

BHANU PRAKASH BYSANI 22-Apr-11 9:00am

ya.iam getting ..thanks..

BHANU PRAKASH BYSANI 22-Apr-11 9:03am

plz help in condition also for checking checkboxes.iam eriting function for checked condition

mksharma38 26-Apr-11 3:19am

send ur code of server sode and client side with ur problem in detail

BHANU PRAKASH BYSANI 26-Apr-11 3:20am

i update my original question..plz check once

mksharma38 26-Apr-11 3:28am

what is data in ds and ds1, also structure of both datatable.
Is ds contains all checkboxs of ds1

BHANU PRAKASH BYSANI 26-Apr-11 4:23am

ds contains total subcategories..ds1 contains user already selected categories..
this is edit subcategories page

mksharma38 26-Apr-11 7:36am

did ur problem resolved with solution 4

BHANU PRAKASH BYSANI 26-Apr-11 7:39am

sorry iam not aware of datatable..

BHANU PRAKASH BYSANI 26-Apr-11 8:09am

thats why iam not getting.. i will try