Click here to Skip to main content
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 16:51pm
Edited 27-Nov-12 19: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 OriginalGriff 454
1 Maciej Los 404
2 CPallini 185
3 Sergey Alexandrovich Kryukov 182
4 Richard MacCutchan 120
0 OriginalGriff 5,634
1 Sergey Alexandrovich Kryukov 4,763
2 Peter Leow 2,954
3 Maciej Los 2,614
4 DamithSL 2,465


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