GridView bouton

Question

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();
} }

jesusonline · Answer

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
<hr />Cyril - MSP - MCTS ASP.net & SQL

GridView bouton

1 réponse

Votre réponse

Discussions similaires