Check value from gridview on button click ASP.NET

Question

0.00/5 (No votes)

See more:

Hello there,

Hope you all are doing good.
I have question, I have a gridview with a column named 'Status' and the value is fetched from database Sql.
There is a button outside Gridview 'Close'. What i want to do is when user clicks on the button it should first check all the records in gridview have their status = closed, even if there is one record with status ='pending' it should generate a popup asking user are 'you sure you want to close'
I hope i have made myself clear. Looking forward to your help.

Many thanks

What I have tried:

Searhed google but could not find anything similar

Posted 12-Jan-17 19:32pm

Faran Saleem

Updated 15-Jan-17 11:27am

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Peter Leow · Accepted Answer · 2017-01-12T19:55:00

Solution 1

Check out this sample code:

Label cell; // assumming the cell is a Label control
for (int i = 0; i < Gridview1.Rows.Count; i++)
{
    cell = Gridview1.Rows[i].FindControl("Status") as Label;
    if (cell.Text == "pending") return false
}
return true;

Posted 12-Jan-17 19:55pm

Peter Leow

Maciej Los · Accepted Answer · 2017-01-12T22:48:00

In opposite to the solution #1 by Peter Leow[^], if gridview object is bounded with datasource, i'd suggest to not follow through the collection of gridview cells, but through the collection of data of gridview[^] datasource[^].

For example:

C#

DataSet ds = (DataSet)gridview1.DataSource;
var pendingdata = ds.Tables[0].AsEnumerable()
	.Where(x=>x.Field<string>("Status")=="pending")
	.ToList();
foreach(DataRow r in pendingdata)
{
	//display message here!
}

For further details, please see:
DataSet Class (System.Data)[^]
DataSets, DataTables, and DataViews[^]
LINQ to DataSet[^]
Querying DataSets (LINQ to DataSet)[^]
Queries in LINQ to DataSet[^]
LINQ to DataSet Examples[^]

Vincent Maverick Durano · Accepted Answer · 2017-01-15T11:27:00

Another quick example for your reference:

C#

protected void btnClose_Click(object sender, EventArgs e)
{
        //loop through the grid rows
        foreach (GridViewRow row in GridView1.Rows)
        {
               //assuming your are using BoundField column for displaying the Status field
               //change the value of index where your Status field resides in the grid's column
               //index starts at 0
               if(row.Cells[index].Text.Trim().ToLower() == "pending"){
                       ClientScript.RegisterStartupScript(typeOf(this), "alert", "alert('Found pending status.')", true);
                       break;
               } 
        }
}

To display a confirmation from the code-behind, then you may refer this example here.

Check value from gridview on button click ASP.NET

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0