Hi,
   i am facing a problem with the checkboxes displayed in the datagrid.when the data are displayed, one of the columns has the checkboxes.Now i want that when i select some checkboxes, the rows corresponding to those selected, should be updated or deleted. I tried this using datagriditem and using a loop to search the entire data. But how can i get the value of the checkboxes to see whether it is clicked or not ? Please give some idea.

Hi again, this time i am sending my codings with this. Look at it and say what is the problem with this.I hope this time i will get a reply.

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

        Dim con As SqlConnection
        Dim cmd1, cmd2 As SqlCommand
        Dim qry1, qry2 As String

        con = New SqlConnection("server= cabin61;uid=sa;pwd=;database=ab")
        con.Open()
        qry1 = "select rollno,name from chkbtry "
         cmd1 = New SqlCommand(qry1, con)
         DataGrid1.DataSource = cmd1.ExecuteReader()
        DataGrid1.DataBind()
        con.Close()
    End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim myDataGridItem As DataGridItem

        Dim chkSelected As System.Web.UI.WebControls.CheckBox

        Dim strStoreName As String

        Dim strStoreID As String
        Dim conn As SqlConnection
        Dim cmd3, cmd4 As SqlCommand
        Dim qry, qry2 As String
        Dim sqldrd As SqlDataReader
        For Each myDataGridItem In DataGrid1.Items
            chkSelected = myDataGridItem.FindControl("chkSelection")

           If chkSelected.Checked = True Then
        conn = New SqlConnection("server= cabin61;uid=sa;pwd=;database=ab")
        conn.Open()
        qry = "update chkbtry set name = '" & TextBox1.Text & "' where rollno=4"
        cmd3 = New SqlCommand(qry, conn)
        cmd3.ExecuteNonQuery()
        DataGrid1.DataBind()
        conn.Close()
        Response.Redirect("WebForm10.aspx")
        conn.Close()
         End If
         Next
    End Sub
End Class


<asp:datagrid id="DataGrid1" style="Z-INDEX: 101; LEFT: 286px; POSITION: absolute; TOP: 157px" runat="server" AutoGenerateColumns="False" SelectedIndex="0">
                <Columns>
                    <asp:TemplateColumn HeaderText="RollNo">
                        <HeaderStyle Font-Names="Bookman Old Style" ForeColor="Black" BackColor="White"></HeaderStyle>
                        <ItemTemplate>
                            <asp:CheckBox ID="ChkSelection" Runat="server"></asp:CheckBox>
                            <asp:Label ID="hypDetails" Text='<%#DataBinder.Eval(Container.DataItem, "rollno")%>' runat="server">
                            </asp:Label>
                        </ItemTemplate>
                    </asp:TemplateColumn>
                    <asp:TemplateColumn HeaderText="Name">
                        <HeaderStyle Font-Names="Bookman Old Style" ForeColor="Black" BackColor="White"></HeaderStyle>
                        <ItemTemplate>
                            <asp:Label ID ="lbl1" Text='<%#DataBinder.Eval(Container.DataItem, "name")%>' runat="server">
                            </asp:Label>
                        </ItemTemplate>
                    </asp:TemplateColumn>
                </Columns>
            </asp:datagrid><asp:button id="Button1" style="Z-INDEX: 102; LEFT: 330px; POSITION: absolute; TOP: 336px" runat="server" Text="Enter"></asp:button><asp:label id="lblstatus1" style="Z-INDEX: 103; LEFT: 221px; POSITION: absolute; TOP: 393px" runat="server" Height="56px" Width="440px"></asp:label>
            <asp:TextBox id="TextBox1" style="Z-INDEX: 104; LEFT: 289px; POSITION: absolute; TOP: 81px" runat="server"></asp:TextBox></form>


I dont know where the problem is. Even no error message is comign but the data are not updated also.Please help.

Hello ractim,
Have a look at this thread
http://p2p.wrox.com/topic.asp?TOPIC_ID=17583
Hope this helps.

--------------------------------------------
Mehdi.:)