c# - No mapping exists from object type System.Web.UI.WebControls.ListItem -
i don´t know what's seems problem have error. can give little help?
protected void send_click(object sender, eventargs e) { string userid; membershipuser p = membership.getuser(user.identity.name); userid = p.provideruserkey.tostring(); string cnnstring = configurationmanager.connectionstrings["defaultconnection"].connectionstring; sqlconnection conn = new sqlconnection(cnnstring); string sql = "insert [noticia] (cod_empregado,titulo,tipo_cliente,tipo_animal,data_noticia,descricao) values (@cod_empregado,@titulo,@tipo_cliente,@tipo_animal,@data_noticia,@descricao) "; sqlcommand comando = new sqlcommand(sql, conn); conn.open(); comando.parameters.add(new sqlparameter("@cod_empregado", userid)); comando.parameters.add(new sqlparameter("@titulo", titulo.text)); comando.parameters.add(new sqlparameter("@tipo_cliente", dropdownlistcliente.selecteditem)); comando.parameters.add(new sqlparameter("@tipo_animal", dropdownlistanimal.selecteditem)); comando.parameters.add(new sqlparameter("@data_noticia", datetime.now)); comando.parameters.add(new sqlparameter("@descricao", descricao.text)); comando.executenonquery(); conn.close(); titulo.text = ""; descricao.text = ""; erros.text = "noticia publicada com sucesso"; }
error:
an exception of type 'system.argumentexception' occurred in system.data.dll not handled in user code
additional information: no mapping exists object type system.web.ui.webcontrols.listitem known managed provider native type.
the problem dropdownlistcliente.selecteditem
and/or dropdownlistanimal.selecteditem
. don't want pass whole item value value out, this:
comando.parameters.add(new sqlparameter("@tipo_cliente", dropdownlistcliente.selecteditem.value)); comando.parameters.add(new sqlparameter("@tipo_animal", dropdownlistanimal.selecteditem.value));
Comments
Post a Comment