Click here to Skip to main content
14,699,608 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi, I am trying to remove a complete row from a GridView if it satisfied a condition.

Here I have got
a Description Column from Product table in database 
with which a GridView is populated. I set the sqlcommand in my vb app to only
select the Description which does not contain the String s
. Here
String s has two keywords "Tomatoes" and "Apple"

So the Sql Query should retrieve the
Description that does not have "Tomatoes" and "Apple"
and therefore the Gridview should be updated by removing the rows which satisfy the condition.

I am facing a difficulty in removing the
Description row in GridView
which has "Tomatoes" and "Apple". I tried populating another GridView with the results, but it does not appear in the web page despite the fact that everything is correct because I have seen the values where I specified some Breakpoints. Any suggestions or thoughts?

Here is my code:

Dim cmd1 = New SqlCommand(" SELECT DISTINCT [Description] FROM [Product] WHERE ([Description] LIKE '%' + @Description + '%')", conn)
                        cmd1.Parameters.AddWithValue("@Description", s)


                        For i As Integer = 0 To GridView1.Rows.Count - 1
                            DA.SelectCommand = cmd1
                           'row is of a GridViewRow datatype As GridView1.Rows
                            row.Cells.RemoveAt(i) '' do not know if it is correct or not
                            '  GridView3.DataSource = '' dt tried with no luck
                            ' GridView3.DataBind() '' tried with no luck
                    End If

1 solution

You can treat it by Query, no need to get into code.
Something like:
SELECT DISTINCT [Description] FROM [Product] WHERE ([Description] LIKE '%' + @ Description + '%') And ([Description] Not Like '%s%')

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

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900