Access GridView column and return values

Question

Access GridView column and return values

Kris Ellison 25

I have a Gridview displaying my data in ASP.NET and C#. How can I access a column and return values greater than 10 and display them in a label below the GridView? I've been looking but couldn't find out how to access them. Thanks

AgaveJoe 30,126 Reputation points

2023-04-18T13:17:20.8033333+00:00
We cannot see your GridView code and have no idea what's in the column. However, looping over GridView rows is trivial. The pattern will look similar to the following.

List<int> numbers foreach (GridViewRow row in myGridView.Rows) { int number = int.Parse((TextBox)row.FindControl("MyNumnbers").Text); if(number > 10) { numbers.Add(number); } }

It's not clear how you want to display the number in label or labels. Frankly, I would write a query to get these values rather than parsing the GridView. Much easier.

Deborah Lane 5

Hi Kris, To access a column and return values greater than 10 in an ASP.NET GridView, you can use GridView's RowDataBound event to iterate through each row in GridView and check the value of the desired column. If the value is greater than 10, you can store it in a List or other data structure and then display the list of values in a label below the GridView. Here is an example code snippet that demonstrates how to accomplish this:

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        // Get the value of the desired column
        int value = Convert.ToInt32(DataBinder.Eval(e.Row.DataItem, "ColumnName"));

        // Check if the value is greater than 10
        if (value > 10)
        {
            // Store the value in a list
            List<int> values = ViewState["Values"] as List<int> ?? new List<int>();
            values.Add(value);
            ViewState["Values"] = values;
        }
    }
}

protected void Button1_Click(object sender, EventArgs e)
{
    // Display the list of values in a label below the GridView
    List<int> values = ViewState["Values"] as List<int>;
    if (values != null)
    {
        Label1.Text = "Values greater than 10: " + string.Join(", ", values);
    }
}

In this example, replace "ColumnName" with the name of the column you want to check. Also, make sure to add the RowDataBound event handler to your GridView in the markup:

<asp:GridView ID="GridView1" runat="server" OnRowDataBound="GridView1_RowDataBound">
    ...
</asp:GridView>

And add a button and label below the GridView: mathematicaCopy code <asp:Button ID="Button1" runat="server" Text="Show Values" OnClick="Button1_Click" /> <br /> <asp:Label ID="Label1" runat="server" />

Kris Ellison 25 Reputation points

2023-04-22T02:18:24.9066667+00:00

Thanks for your help Deborah. It works perfectly except it shows the values twice when you press the button. I've tried several things but being new to C# and ASP.NET I cannot work it out. Thanks for any help.

1 answer

Your answer

AgaveJoe 30,126 Reputation points

2023-04-18T13:17:20.8033333+00:00

We cannot see your GridView code and have no idea what's in the column. However, looping over GridView rows is trivial. The pattern will look similar to the following.

List<int> numbers foreach (GridViewRow row in myGridView.Rows) { int number = int.Parse((TextBox)row.FindControl("MyNumnbers").Text); if(number > 10) { numbers.Add(number); } }

It's not clear how you want to display the number in label or labels. Frankly, I would write a query to get these values rather than parsing the GridView. Much easier.
Deborah Lane 5 Reputation points

2023-04-19T09:01:36.9066667+00:00

Hi Kris, To access a column and return values greater than 10 in an ASP.NET GridView, you can use GridView's RowDataBound event to iterate through each row in GridView and check the value of the desired column. If the value is greater than 10, you can store it in a List or other data structure and then display the list of values in a label below the GridView. Here is an example code snippet that demonstrates how to accomplish this:

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { // Get the value of the desired column int value = Convert.ToInt32(DataBinder.Eval(e.Row.DataItem, "ColumnName")); // Check if the value is greater than 10 if (value > 10) { // Store the value in a list List<int> values = ViewState["Values"] as List<int> ?? new List<int>(); values.Add(value); ViewState["Values"] = values; } } } protected void Button1_Click(object sender, EventArgs e) { // Display the list of values in a label below the GridView List<int> values = ViewState["Values"] as List<int>; if (values != null) { Label1.Text = "Values greater than 10: " + string.Join(", ", values); } }

In this example, replace "ColumnName" with the name of the column you want to check. Also, make sure to add the RowDataBound event handler to your GridView in the markup:

<asp:GridView ID="GridView1" runat="server" OnRowDataBound="GridView1_RowDataBound"> ... </asp:GridView>

And add a button and label below the GridView: mathematicaCopy code <asp:Button ID="Button1" runat="server" Text="Show Values" OnClick="Button1_Click" /> <br /> <asp:Label ID="Label1" runat="server" />
Kris Ellison 25 Reputation points

2023-04-22T02:18:24.9066667+00:00

Thanks for your help Deborah. It works perfectly except it shows the values twice when you press the button. I've tried several things but being new to C# and ASP.NET I cannot work it out. Thanks for any help.

Answer 1

Hi @Kris Ellison,

You'd better provide your code so that we can help you more specifically.

Below are two methods of getting columns that I wrote according to your needs.

 protected void Button1_Click(object sender, EventArgs e)
        {
            List<int> numbers = new List<int>();
            List<int> number = new List<int>();

            for (int i = 0; i < gvCustomers.Rows.Count; i++)
            {
                //get the second column
                int a = Convert.ToInt32(gvCustomers.Rows[i].Cells[1].Text);
                if (a > 10)
                {
                    numbers.Add(a);
                 
                    Label1.Text = string.Join(",", numbers);

                }
                //get the third column
                TextBox tb = (TextBox)gvCustomers.Rows[i].FindControl("TextBox1");
                int b = Convert.ToInt32(tb.Text.ToString());

                if (b > 10)
                {
                    number.Add(b);

                    Label2.Text = string.Join(",", number);

                }
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!this.IsPostBack)
            {
                DataTable dt = new DataTable();
                dt.Columns.AddRange(new DataColumn[]
                {
                    new DataColumn("CustomerId"),
                    new DataColumn("Name"),
                    new DataColumn("Country")
                });
                dt.Rows.Add(1, 1, 11);
                dt.Rows.Add(2, 22, 2);
                dt.Rows.Add(3, 12, 0);
                dt.Rows.Add(4, 3, 13);
                gvCustomers.DataSource = dt;
                gvCustomers.DataBind();
            }
        }

 <div>
            <asp:GridView ID="gvCustomers" runat="server" AutoGenerateColumns="false" >
    <Columns>
        <asp:BoundField DataField="CustomerId" HeaderText="Id" />
        <asp:BoundField DataField="Name" HeaderText="Name" />
        <asp:TemplateField HeaderText="Country">
            <ItemTemplate>
                <asp:TextBox ID="TextBox1" runat="server" Text='<%# Eval("Country") %>'></asp:TextBox>
              
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
</asp:GridView>
            <asp:Button ID="Button1" runat="server" Text="Button" OnClick="Button1_Click" />
            <asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
            <asp:Label ID="Label2" runat="server" Text="Label"></asp:Label>
        </div>

Best regards,
Lan Huang

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Lan Huang-MSFT 30,186 Reputation points Microsoft External Staff

2023-04-27T09:12:10.1+00:00

Hi @Kris Ellison,

Do you have any other questions about this post?

Share via

Access GridView column and return values

1 answer

Your answer