Navigate through all the rows

[Hugo]

Hi

I'm very new to the visual studio environment and telerik controls.  I'm using a Gridview with bound data and I need to navigate through all the data rows.  Basically I need to read the value of the second value to make a secuential process.

private void LlenarRestaurantes () {
           SqlDataReader dr ;
           SqlCommand cmd;
           string Sqlstring;

           Sqlstring = "   SELECT  '(' + rtrim(RE.sNumeroRestaurante) + ') ' +  RE.sNombreRestaurante  as RESTAURANTE,"
                       + "'\\'  +  rtrim (RE.sServidorDatos) + '\\Cambios\\' as [RUTA DE ENVIO] , 'SIN PROCESAR' as RESULTADO "
                       + " FROM         amRestaurantes AS RE INNER JOIN"
                       + " CambioRecetaRestaurante AS CR ON RE.sNumeroRestaurante = CR.sCodigoRestaurante"
                       + " WHERE     (CR.sConsecutivo = '" + lblNumeroDeCambio.Text  +  "')";
           cmd = new SqlCommand (Sqlstring , db);
           dr = cmd.ExecuteReader () ;
           gvRestaurantes.DataSource = dr;

           gvRestaurantes.BestFitColumns();
       }

I know that it's a very simple task but as a novice I haven't found how to do it.  I'm using Windows 7 with Visual Studio 2010 Ultimate.

I need also  to write on the third column some custom values from me. I can do that?

Thanks

[Emanuel Varga]

Hello Hugo,

You can just iterate trough all the rows and then get/set the value to a specific cell, something like this:

foreach (var row in radGridView.Rows)
{
    var valueFromSecondColumn = row.Cells[1].Value; // row.Cells["ColumnName"];
    //set value
    row.Cells[2].Value = someValue;
}

Hope this helps, if you have any other questions or comments, please let me know,

Best Regards,
Emanuel Varga

Telerik WinForms MVP

[Hugo]

Thanks for the quick response.

I'm having problems setting a value to a cell, I'm getting the error "The method specified is not compatible ".  The third column is generated from the query, I don't know if it affects. 

foreach (var fila in gvRestaurantes.Rows)
           {
                var Valor = fila.Cells[1].Value;
                fila.Cells[2].Value = "Procesado";//This intruction gives me an error
            }

Another question, Do you have a webpage where I can find explanations of all members of your components? There's the overview Webpage http://www.telerik.com/help/winforms/ribbonbar-overview.html but is not very deep for a novice as me.

Thanks 

[Svett]

Hi Hugo,

I am not able to reproduce the issue with the supplied information. I would kindly ask you to share with us the data source and source code that you are using to initialize and bind the RadGridView instance. You can refer the API documentation here.

Please note that should open a new support ticket in order to be able to attache files.

Thank you for your cooperation. I am looking forward to your response.

Greetings,
Svett
the Telerik team