Click here to Skip to main content
11,479,083 members (62,201 online)
Click here to Skip to main content

Changing a column in multiple DataGrid rows using checkboxes

, 19 Nov 2003 76.6K 39
Rate this:
Please Sign up or sign in to vote.
This article demonstrates how to apply a dropdownlist value to multiple rows in a DataGrid.

Sample Image - chk.gif

Introduction

This article will demonstrate how to change the value of a DataGrid column in multiple rows using checkboxes. This is a very common problem and it's easily implementable, so without much ado, let's get to the point.

Before I start, though, I'll put forward one assumption I make in this article, make sure your code meets the underlying requirement, otherwise you'll have to do some extra work.

I'll assume that the data bound to the grid is also editable through some object in your code (in other words, DataGrid columns are properties of one object) and you have an update routine for this object. For example, in our case, the object we're using is PurchaseOrder, and the column (property) is ApprovalStatus.

First off, let's start with a simple bind routine. The getApproverPOs function simply returns a DataTable object, you can replace it with your own DataTable.

Sub BindGrid()
    dgPO.DataSource = PurchaseOrder.getApproverPOs
    dgPO.DataBind()
End Sub

In our example, we have a dropdown named lstStatus and a button named btnApply.

The Iterate routine which follows next will loop through each row and see if the checkbox (named chk) in the DataGrid's first template column is checked, if so, it will load PurchaseOrder, set a new ApprovalStatus, and update the changes.

Public Sub Iterate() 
 Dim DGItem As DataGridItem
 Dim chkSel As System.Web.UI.WebControls.CheckBox
 Dim po As PurchaseOrder
 For Each DGItem In dgPO.Items
  chkSel = DGItem.FindControl("chk")
  If chkSel.Checked Then
    po = PurchaseOrder.getPO(DGItem.Cells(1).Text) 'pass the po number to get
    po.ApprovalStatus = lstStatus.SelectedItem.Value
    'send an email to original PO poster
    PurchaseOrder.NotifyPoster(po)
    po.Update()
  End If
 Next
End Sub

And finally, we need an event handler for our button which will point to the Sub above. We use Response.Redirect in the end to refresh the checkboxes, as well as the ApprovalStatus column.

Private Sub btnApply_Click(ByVal sender _
  As System.Object, ByVal e As System.EventArgs) _
  Handles btnApply.Click
    Iterate()
    Response.Redirect("thissamefile.aspx")
End Sub

That's all there is! Hope this was helpful.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

Share

About the Author

Mesrop Simonian
Web Developer
United States United States
No Biography provided

Comments and Discussions

 
GeneralMy vote of 5 Pin
manoj kumar choubey7-Feb-12 20:29
membermanoj kumar choubey7-Feb-12 20:29 
GeneralUsing checkbox in autogenerated datagrid Pin
ashasprabhu20-Jun-07 22:12
memberashasprabhu20-Jun-07 22:12 
QuestionValue in TextBox should be changed to required formate Pin
kishore19@hotmail.com28-Dec-06 7:45
memberkishore19@hotmail.com28-Dec-06 7:45 
QuestionHow to add the multiple edit in this auto generated script Pin
Anonymous4-Sep-05 17:20
sussAnonymous4-Sep-05 17:20 
GeneralMultiple checkboxes selection. PLEASE HELP. Pin
misssBlur3-Apr-04 20:56
membermisssBlur3-Apr-04 20:56 
GeneralChecking if an item is checked before post back Pin
Esterbarn27-Nov-03 23:15
sussEsterbarn27-Nov-03 23:15 
GeneralRe: Checking if an item is checked before post back Pin
Mesrop Simonian2-Dec-03 7:52
memberMesrop Simonian2-Dec-03 7:52 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.150520.1 | Last Updated 20 Nov 2003
Article Copyright 2003 by Mesrop Simonian
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid