Solved

Loop through a datagrid and replace values

Posted on 2004-08-11
5
474 Views
Last Modified: 2006-11-17
I have a datagrid.  It is being bound with a column that is either a 1 or a 0.  I need to replace the 1 with "X" and the 0 with "" in every field in a column.  Can someone help me out.  This cant be nearly as hard as Im making it.
Thanks for the help
0
Comment
Question by:imsolost
5 Comments
 
LVL 4

Accepted Solution

by:
BradB3030 earned 400 total points
ID: 11775205
dim i as integer
for i = 0 to datagrid1.items.count - 1
  'I'll assume the 1 or 0 is located in Column # 22, you'll have to change that accordingly
  if datagrid1.items(i).Cells(22) = "1" then
    datagrid1.items(i).Cells(22) = "X"
  else
    datagrid1.items(i).Cells(22) = ""
  end if
next i

You can also do something similar in an ItemDataBound handler subroutine

using e.item instead of datagrid1.items(i) and no for loop.
0
 
LVL 6

Expert Comment

by:pillbug22
ID: 11775256
Look at the ItemDataBound event.

This example uses assumes you're using ItemTemplates in your grid, but you could do it with bound columns as well:


Private Sub dg1_ItemDataBound(ByVal sender As System.Object, ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs) Handles dg1.ItemDataBound

       If e.Item.ItemType = ListItemType.Item Or e.Item.ItemType = ListItemType.AlternatingItem Then
            Dim lbl As Label
            Dim myValue As Integer = CType(DataBinder.Eval(e.Item.DataItem, "dataBaseField"), Integer)
            lbl = CType(e.Item.FindControl("lblInItemTemplateToChange"), Label)
            If myValue = 1 Then
               lbl.Text = "X"
            Else
               lbl.Text = ""
            End If
        End If

    End Sub 'dgSurveyItems_ItemDataBound
0
 
LVL 8

Expert Comment

by:boulder_bum
ID: 11775258


private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataListItemEventArgs e)
{
   if( e.Item.ItemType == ListItemType.Item ||
      e.Item.ItemType == ListItemType.AlternatingItem )
   {
        DataRowView drvCurrent = (DataRowView)e.Item.DataItem;

        //I'm assuming the data type is a bit
        bool oneOrZero;
        oneOrZero = (bool)drvCurrent["HasResponded"];
       
        //use casting to get a reference to whatever control you want to manipulate (label or whatever you use)
        //note: you will probably want to change the cells and/or controls index    
        //
        //Label lbl = ((Label)e.Item.Cells[0].Controls[0]);

        //manipulate your control
        if( oneOrZero )
             //lbl.Text = "X";
        else
             //lbl.Text = "O";
   }
}
0
 
LVL 7

Author Comment

by:imsolost
ID: 11777804
BradB -  I like the loop option.  however when I run it I get the error of :

Property 'Item' is 'ReadOnly'

0
 
LVL 7

Author Comment

by:imsolost
ID: 11777880
Ahh you were very close. Thanks for the help.  You just left out .text.  here is the loop I ended up using.

        Dim i As Integer
        For i = 0 To DG.Items.Count - 1
            If DG.Items(i).Cells(9).Text = 1 Then
                DG.Items(i).Cells(9).Text = "X"
            Else
                DG.Items(i).Cells(9).Text = ""
            End If
        Next i

Thanks again
0

Featured Post

ScreenConnect 6.0 Free Trial

Explore all the enhancements in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

One of the pain points with developing AJAX, JavaScript, JQuery, and other client-side behaviors is that JavaScript doesn’t allow for cross domain request for pulling content. For example, JavaScript code on www.johnchapman.name could not pull conte…
I recently went through the process of creating a Calendar Control of events with the basis of using a database to keep track of the dates that are selectable, one requirement was to have the selected date pop-up in a simple lightbox.  At first this…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question