How to checkbox true dynamically in C# .net

Question

1.00/5 (1 vote)

See more:

Dear Frnds,

I have designed with check boxes.. i need check box true when the columns Values are "yes" in data base.

I have written this code but always shows checked.

C#

while (dtr.Read())
           {
                   if (dtr["EmpMaster"].ToString() == "N")
                   {
                       ChkEmpMaster.Checked = false;
                   }
                   else
                   {
                       ChkEmpMaster.Checked = true;
                   }

}

With Regards,
Vivek

Posted 23-May-14 20:26pm

Vivek.anand34

Add a Solution

Comments

Prasad_Kulkarni 24-May-14 2:34am

Not clear.
I have written this code but always shows checked.

Vivek.anand34 24-May-14 2:40am

for that code... output is checked in checkbox. didn't change please c that code..

Peter Leow 24-May-14 2:46am

The problem lies somewhere else. Show more code if you can.

Vivek.anand34 24-May-14 2:56am

GridViewRow row = (sender as ImageButton).NamingContainer as GridViewRow;
con.Open();
string strSQL = "SELECT * from Vw_UserCreation where UserId='" + row.Cells[0].Text + "'";
SqlCommand cmd = new SqlCommand(strSQL, con);
SqlDataReader dtr = cmd.ExecuteReader();
while (dtr.Read())
{
txtUserId.Text = dtr.GetString(dtr.GetOrdinal("UserId"));
txtUserName.Text = dtr.GetString(dtr.GetOrdinal("UserName"));
txtPassword.Text=dtr.GetString(dtr.GetOrdinal("Password"));
txtDeptId.Text = dtr.GetString(dtr.GetOrdinal("DepartmentId"));
txtDeptName.Text = dtr["DepartmentName"].ToString();
rbUserType.Text = dtr["UserType"].ToString();

if (dtr["EmpMaster"].ToString() == "N")
{
ChkEmpMaster.Checked = false;
}
else
{
ChkEmpMaster.Checked = true;
}
}

Peter Leow 24-May-14 3:14am

Add you code to your original question using the "Improve question" widget. More eyes is better than 2.

Peter Leow 24-May-14 3:17am

How many rows do you expect to return from the sql query? What are the expected values in the EmpMaster fields?

Vivek.anand34 24-May-14 3:38am

in the EmpMaster having only 2 values only Y and N.. if Y means checkbox checked else checkbox unchecked..

Peter Leow 24-May-14 3:54am

Try adding this above the 'if (dtr["EmpMaster"].ToString() == "N")' and run it
Debug.WriteLine(dtr["EmpMaster"].ToString());
what is the output?

Vivek.anand34 24-May-14 4:18am

debug is doesnot exist in the current context.

Peter Leow 24-May-14 4:28am

You have to include "using System.Diagnostics;"
check this out, http://msdn.microsoft.com/en-us/library/vstudio/9z9k5ydz%28v=vs.110%29.aspx
To see the output, go to debug > windows > output of your visual studio

Vivek.anand34 24-May-14 4:33am

Nothing hpn..

Vivek.anand34 24-May-14 4:35am

I put this type too.. but nothing hpn..
if (dtr["EmpMaster"].ToString() == "N")
{
Debug.WriteLine(dtr["EmpMaster"].ToString());
ChkEmpMaster.Checked = false;
}
else
{
ChkEmpMaster.Checked = true;
Debug.WriteLine(dtr["EmpMaster"].ToString());
}

Peter Leow 24-May-14 4:38am

I said "Try adding this ABOVE the 'if (dtr["EmpMaster"].ToString() == "N")' not inside the loop.

Debug.WriteLine(dtr["EmpMaster"].ToString());
if (dtr["EmpMaster"].ToString() == "N")
{
ChkEmpMaster.Checked = false;
}
else
{
ChkEmpMaster.Checked = true;
}

Vivek.anand34 24-May-14 4:43am

i add debug above it..before i add that line always checked checkbox. now didn't check check box always unchecked..

Peter Leow 24-May-14 4:45am

I am asking what did this line return? I was not asking about the checkbox.
Debug.WriteLine(dtr["EmpMaster"].ToString());

Vivek.anand34 24-May-14 4:59am

An exception of type 'System.Threading.ThreadAbortException' occurred in mscorlib.dll but was not handled in user code
'WebDev.WebServer40.EXE' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Xaml\v4.0_4.0.0.0__b77a5c561934e089\System.Xaml.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
Y
Y
The thread '<no name="">' (0x604) has exited with code 0 (0x0).
The thread '<no name="">' (0x1758) has exited with code 0 (0x0).
The thread '<no name="">' (0x152c) has exited with code 0 (0x0).
The thread '<no name="">' (0x17f8) has exited with code 0 (0x0).

Vivek.anand34 24-May-14 4:39am

didn't any action performed.. always which user i selected always checked the check box..

Vivek.anand34 24-May-14 4:44am

i add debug above it..before i add that line always checked checkbox. now didn't check check box always unchecked..

2 solutions

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)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 1 · 2014-05-23T20:41:00

Solution 1

As you are using DataReader, so it would loop for all the rows returned by the query.
You are trying to check one single CheckBox inside the loop, so the loop would end up in checking the CheckBox according to the last returned value of the DataReader.

So, debug and see for each loop, what the value returned.

Posted 23-May-14 20:41pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Comments

Vivek.anand34 24-May-14 2:48am

how use loop send some lines...

Vivek.anand34 24-May-14 2:52am

GridViewRow row = (sender as ImageButton).NamingContainer as GridViewRow;
con.Open();
string strSQL = "SELECT * from Vw_UserCreation where UserId='" + row.Cells[0].Text + "'";
SqlCommand cmd = new SqlCommand(strSQL, con);
SqlDataReader dtr = cmd.ExecuteReader();
while (dtr.Read())
{
txtUserId.Text = dtr.GetString(dtr.GetOrdinal("UserId"));
txtUserName.Text = dtr.GetString(dtr.GetOrdinal("UserName"));
txtPassword.Text=dtr.GetString(dtr.GetOrdinal("Password"));
txtDeptId.Text = dtr.GetString(dtr.GetOrdinal("DepartmentId"));
txtDeptName.Text = dtr["DepartmentName"].ToString();
rbUserType.Text = dtr["UserType"].ToString();

if (dtr["EmpMaster"].ToString() == "N")
{
ChkEmpMaster.Checked = false;
}
else
{
ChkEmpMaster.Checked = true;
}
}

DamithSL · Answer 2 · 2014-05-23T20:44:00

Solution 2

try below

C#

ChkEmpMaster.Checked =dtr["EmpMaster"].ToString() == "yes";

also note that if you have multiple records then you will get the status of last record since you have while loop and set again and again the checked status of same control.

Posted 23-May-14 20:44pm

DamithSL

Updated 23-May-14 20:49pm

v2

Comments

Vivek.anand34 24-May-14 2:52am

no use of this line.. didn't action anyting

DamithSL 24-May-14 3:12am

what is the value you get for dtr["EmpMaster"].ToString()? debug and let me know

Vivek.anand34 24-May-14 3:25am

in this dtr["EmpMaster"] columns two values: Y and N.. if Y means check box is checked and N means Checkbox not checked..