GridView bouton

Bonjour, voici mon code,
je cherche une équivalence pour le "GridViewRow row = newGridViewRow();" qui ne marche pas et qui rend  "row.Cells[0].Value" faux!

Merci
Sabine

protected void GridView1_SelectedIndexChanged( object sender, EventArgs e)
{
                // connection to MPL database
                DataConnection m = new DataConnection ();
                OracleConnection conn = null ;
                conn = m.DoConnection();

                try
               {
                      GridViewRow row = new GridViewRow ();
                     // create command
                     // command for DELETE
                     OracleCommand cmd = conn.CreateCommand();
                     // commande for COMMIT
                     OracleCommand cmd2 = conn.CreateCommand();

                     cmd.CommandText =

"DELETE FROM user_mpl where login=:parm1 and password=:parm2" ;
                     cmd2.CommandText = "COMMIT" ;

                     OracleParameter myParameter1 = new OracleParameter ( ":parm1" , OracleType .VarChar, 30);
                     myParameter1.Value = row.Cells[0].Value;
                     OracleParameter myParameter2 = new OracleParameter ( ":parm2" , OracleType .VarChar, 30);
                     myParameter2.Value = row.Cells[1].Value;

                     cmd.Parameters.Add(myParameter1);
                     cmd.Parameters.Add(myParameter2);
                    

// execute the query
                    cmd.ExecuteNonQuery();
                    cmd2.ExecuteNonQuery();
                    cmd.Dispose();
                    cmd = null ;
                    cmd2.Dispose();
                    cmd2 = null ;
}
catch ( OracleException err)
{
                   Console .WriteLine( "error:" + err);
}
finally
{
                  conn = m.DoDeconnection();
}

 }

Bonsoir,

l'erreur est logique, tu créer une nouvelle instance de GridviewRow ! tu dois avoir la row selectionné dans la variable GridView1

GridviewRow row = gridview1.SelectedRow; //ou un truc du genre

---

Cyril - MSP - MCTS ASP.net & SQL