Click here to Skip to main content
11,483,586 members (67,741 online)
Rate this: bad
good
Please Sign up or sign in to vote.
foreach (GridViewRow rowI
tem in GridView1.Rows)
{
      CheckBox chk = (CheckBox)(rowItem.Cells[7].FindControl("ch1"));
      try
      {
          if (chk == null)
          {
              Label3.Text = "hai";
              SqlConnection myConnection = new SqlConnection("Data Source=PCIMS051;Initial Catalog=unblockingwebsite;Integrated Security=True");
              myConnection.Open();
              SqlCommand myCommand = new SqlCommand("INSERT INTO twebsite_unblocking (Requested_Status) " + "Values ('2')", myConnection);
              myCommand.ExecuteNonQuery();
              myConnection.Close();
          }
      }
      catch { }
      
     }

Update Cancel Requested_ID Requested_by Action_taken Action_remark Action_taken_by Action_taken_date Request_Status


Label text changed but check box status not changed and not update to gridview
Posted 27-Nov-12 17:51pm
Edited 27-Nov-12 20:48pm
v2
Comments
Mohd. Mukhtar at 28-Nov-12 1:50am
   
What error you are getting here?

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

//if coloumn datatype is int then remove qouts example values(2)


// validate whether changes made to database
if(  myCommand.ExecuteNonQuery() > 0 )
            {
                Response.Write("success");
            }
            else
            {
                Response.Write("failed");
            }
  Permalink  

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 250
1 Frankie-C 175
2 Raje_ 155
3 OriginalGriff 152
4 Abhipal Singh 108
0 Sergey Alexandrovich Kryukov 8,489
1 OriginalGriff 7,943
2 Sascha Lefèvre 3,114
3 Maciej Los 2,581
4 Richard Deeming 2,370


Advertise | Privacy | Mobile
Web04 | 2.8.150520.1 | Last Updated 28 Nov 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100