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

Popular posts from this blog

c++ - OpenCV Error: Assertion failed <scn == 3 ::scn == 4> in unknown function, -

php - render data via PDO::FETCH_FUNC vs loop -

The canvas has been tainted by cross-origin data in chrome only -