c# - rows in sql server db being deleted once I click update. the id is only filed that has data -

i have gotten past errors ham having issue db not being update datgridview data. sorry newbie here , don't know why not updating.

protected void gvkeypersonnel_rowupdating(object sender, eventargs e) { using (sqlcommand cmd = new sqlcommand()) { cmd.connection = conn; conn.open(); // sqldatareader myreader = null; // myreader = cmd.executereader();

            foreach (gridviewrow row in gvkeypersonnel.rows)             {                                  cmd.parameters.clear();                cmd.commandtext = @"update sp2010_edcstaffing_appdb.dbo.cms_key_personnel  set  name = @name, vdcidiq = @vdcidiq, vdcffs = @vdcffs, vdchim = @vdchim, vdcwebhosting = @vdcwebhosting, vdccwf = @vdccwf id = @id";                  cmd.parameters.addwithvalue("@id", convert.toint32(gvkeypersonnel.datakeys[row.rowindex].values[0]));                  cmd.parameters.addwithvalue("@name", row.cells[1].text);                 cmd.parameters.addwithvalue("@vdcidiq", row.cells[2].text);                 cmd.parameters.addwithvalue("@vdcffs", row.cells[3].text);                 cmd.parameters.addwithvalue("@vdchim", row.cells[4].text);                 cmd.parameters.addwithvalue("@vdcwebhosting", row.cells[5].text);                 cmd.parameters.addwithvalue("@vdccwf", row.cells[6].text);                 cmd.executenonquery();             }             conn.close();         }     }   } 

}

you

cmd.commandtext = @"update  

no need @ just

cmd.commandtext = "update  

and ensure connection database open by

conn.open();