How to select values from gridview and give in textbox

Question

I need to check whether the cells of a particular column in gridview has certain values. If the cells contain values it should do some action. I have attached my code. protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { if (TextBox1.Text != "") { if ((e.Row.Cells[3].Text == "1") && (e.Row.Cells[3].Text == "2")) { Label3.Visible = true; } } } } It is not checking the AND condition. If i replace it by OR statement it works

ashwini patel · Answer

Hi Now I am not using that code. Ya it is checking same cell so I deleted that code. for (int i = 0; i { string n = GridView1.Rows[0].Cells[3].Text; string m = GridView1.Rows[1].Cells[3].Text; if (n == "1" && m == "2" ) { Label3.Visible = true; } else { Label3.Visible = false; } } I am checking only 2 numbers ryt now, This code is working but her I have assigned to check 0th row and 1st row of 3rd column. But I cannot assign like that. Automatically it should check all rows of that 3rd column and if the column has all the numbers from 1 to 15 in any of its rows, it should execute. Is there any solution.

Rafnas T P · Answer

hi, as per your code you are checking both conditions in same cell, how it is possible like 1 in cell3 and also 2 in cell3 protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { if (TextBox1.Text != "") { if ((e.Row.Cells[3].Text == "1") && (e.Row.Cells[3].Text == "2")) { Label3.Visible = true; } } } }

ashwini patel · Answer

Hai...I tried but it is not working. I need to check all the rows of 3rd column,(3rd column contains the numbers) whether it contains 1 to 15 values. If all 15 values are present, then execute our condition. I modified the code as below, at that time it is executing even when the column contains any 1 of the value. if (e.Row.RowType == DataControlRowType.DataRow) { if (TextBox1.Text != "") { string Value1 = e.Row.Cells[3].Text; string str = System.Text.RegularExpressions.Regex.Replace(Value1, @"[.\D+]", ""); int x = Convert.ToInt32(str); if (Enumerable.Range(1, 2).Contains(x)) { Label3.Visible = true; } else { Label3.Visible = false; } } }

Nikunj Satasiya · Answer

Ashwini Please Try This Solution: for ( int i = 1; i { if (e.Row.RowType == DataControlRowType.DataRow) { if (TextBox1.Text != "" ) { string Value1 = e.Row.Cells[i].Text; string str = System.Text.RegularExpressions.Regex.Replace(Value1, @ "[.\D+]" , "" ); int x = Convert.ToInt32(str); if (Enumerable.Range(1, 15).Contains(x)) { Label3.Visible = true ; } else { Label3.Visible = false ; } } } }

ashwini patel · Answer

The cells of column(3) contains just numbers from 1 to 15. I just need to check whether the column(3) has all numbers from 1 to 15 . If it contains all numbers then it should show PASS. If any one of the number is missing from 1 to 15 , it should show an error along with which number is missing. The column value we are taking from database. for (int i = 1; i { string n = GridView1.Rows[0].Cells[3].Text; string m = GridView1.Rows[1].Cells[3].Text; if (n =="1" && m =="2") { Label3.Visible = true; } else { Label3.Visible = false; } } This code is working but the problem is I have assigned to check row[0] and row[1] of column.Instead of that automatically it should check all the cells of that column

ashwini patel · Answer

Hello I need to check if any of the cells in column has value 1 and 2. If it contains both 1 and 2 then some condition should be executed. if (TextBox1.Text != "") { string Value1 = e.Row.Cells[3].Text; string Value2 = e.Row.Cells[3].Text; if (Value1 == "1" && Value2 == "2") { Label3.Visible = true; } if (e.Row.Cells[3].Text == "3") { Label5.Visible = true; } } As you said it is checking whether the same column value is having 1 and 2. What i need is to check any of the column values has 1 and 2. It is not working even after giving 2 variables

ashwini patel · Answer

Hello Nikunj I tried the above code but still it is not working. If I use OR statement it is taking