i want to show it checked what are checked

Question

1.00/5 (1 vote)

See more:

i have a number of checkboxes in gridview. when i checked that its value is inserting into database. but when i am again debugging it is showing unchecked. i want to show it checked what are checked

Posted 9-Mar-14 22:11pm

Member 10578683

Add a Solution

Comments

Rockstar_ 10-Mar-14 4:36am

Please elaborate the problem clearly.

Krunal Rohit 10-Mar-14 4:39am

Make the question clear.

-KR

Member 10578683 10-Mar-14 4:49am

i want to show the check boxes remains checked wnen i checked them in every time when i will open my website

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)

Krunal Rohit · Answer 1 · 2014-03-09T22:56:00

Solution 1

Write your code in condition like

C#

if(!IsPostBack)
{
    // your chechbox logic
}

-KR

Posted 9-Mar-14 22:56pm

Krunal Rohit

V5709 · Answer 2 · 2014-03-09T22:58:00

Solution 2

if you have already saved checked check boxes details in data base. Then go for row data bound event of grid view & by checking check property for each row ,check tat row check box .

for better understanding refer this link

Posted 9-Mar-14 22:58pm

V5709

Comments

Member 10578683 10-Mar-14 5:19am

protected void Button3_Click(object sender, EventArgs e)
{
for (int i = 0; i < GridView1.Rows.Count; i++)
{
CheckBox chk = (CheckBox)GridView1.Rows[i].Cells[2].FindControl("CheckBox1");
if (chk != null)
{
if (chk.Checked)
{
string strID = GridView1.Rows[i].Cells[0].Text;
string strName = GridView1.Rows[i].Cells[1].Text;
string status = "Y";
SqlCommand cmd = new SqlCommand();
cmd = new SqlCommand("Update Role1 set Checkin_Add ='" + status + "' where ID= '" + strID + "' and Role_Name= '" + strName + "'", con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
else
{
string strID = GridView1.Rows[i].Cells[0].Text;
string strName = GridView1.Rows[i].Cells[1].Text;
string status = "N";
SqlCommand cmd = new SqlCommand();
//cmd = new SqlCommand("insert into Role1(Checkin_Add) values(" + status + " where ID= '" + strID + "' and Role_Name='" + strName + "')", con);
cmd = new SqlCommand("Update Role1 set Checkin_Add ='" + status + "' where ID= '" + strID + "' and Role_Name= '" + strName + "'", con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}

}

Member 10578683 10-Mar-14 5:19am

hi this my code what will i do

V5709 10-Mar-14 6:56am

ok... This code is working for insert or update check box related details in data base.
Now you have to done one thing more. After inserting or updating in data base you should rebind your grid.(i think you may have done it on page load also.) here call that binding function again. If you have written row data bound event as explained in above link, then grid binding event will rise an call to row data bound event & there you will have placed your check box checking logic.

Member 10578683 10-Mar-14 9:50am

when i m going from one page to other checkboxes are not in checked format

V5709 11-Mar-14 0:45am

to show that you have to repopulate data from data base & have to show it in grid.