Loop through a datagrid and replace values

Posted on 2004-08-11
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
Question by:Fred Goodwin
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Accepted Solution

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"
    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.

Expert Comment

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"
               lbl.Text = ""
            End If
        End If

    End Sub 'dgSurveyItems_ItemDataBound

Expert Comment

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";
             //lbl.Text = "O";

Author Comment

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

Property 'Item' is 'ReadOnly'


Author Comment

by:Fred Goodwin
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"
                DG.Items(i).Cells(9).Text = ""
            End If
        Next i

Thanks again

Featured Post

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

In .NET 2.0, Microsoft introduced the Web Site.  This was the default way to create a web Project in Visual Studio 2005.  In Visual Studio 2008, the Web Application has been restored as the default web Project in Visual Studio/.NET 3.x The Web Si…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…

726 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