hi
i am getting an error - Collection was modified; enumeration operation may not execute
it point son the next in my loop
i have to make it work!!
here is the code

For Each row In dt.Rows


                number = row.ItemArray(0)
                cmd2.CommandText = "select * from Pays where PhoneNumberFrom ='" & number & "'"
                cmd2.Connection = con
                cmd2.CommandType = CommandType.Text

                con.Open()
                Try
                    Dim adp2 As New OleDbDataAdapter(cmd2)
                    adp2.Fill(dt)
                Catch

                End Try
                con.Close()
                DataGrid2.DataSource = dt
                DataGrid2.DataBind()

        Next

thanks tali

You have a for each on dt.rows...
then in the for, you are modifying dt.

Perhaps you need a second DataTable object.

if you are using the datatable object
you can't change it

Study,Progress,Life...

If the results are already in the data table, use a data view to extract the current record.

Brian

you need 2 loops. Build a array of number cycle your table once then do the loop you wrote.
The code you have is modifying the loop's collection.
You can't modify dt and use dt in the loop condition.

I am studying¡­¡­