Quote Originariamente inviata da djciko Visualizza il messaggio
prova

cmd.Parameters.AddWithValue("@AuthCode", pAuthCode);
cmd.Parameters.AddWithValue("@IdReg", pIdReg);


(e metti una Try anche per ExecuteNonQuery)

System.ArgumentException: Nessun mapping esistente dal tipo di oggetto System.Data.SqlClient.SqlParameter a un tipo nativo di provider gestito noto

Ecco il codice:
codice:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Data.SqlTypes;


namespace Bridge.users
{
    public partial class Bridge : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
            builder.DataSource = "localhost\\SQLExpress";
            builder.InitialCatalog = "Miatabella";
            builder.IntegratedSecurity = true;


            SqlParameter pIdReg = new SqlParameter();
            pIdReg.ParameterName = "@IdReg";
            pIdReg.DbType = DbType.String;
            pIdReg.Direction = ParameterDirection.Input;
            pIdReg.Value = Request.QueryString["idReg"];


            SqlParameter pAuthCode = new SqlParameter();
            pAuthCode.ParameterName = "@AuthCode";
            pAuthCode.DbType = DbType.String;
            pIdReg.Direction = ParameterDirection.Input;
            pAuthCode.Value = Request.QueryString["AuthCode"];


            using (SqlConnection conn = new SqlConnection(builder.ConnectionString))
            {
                try
                {
                    conn.Open();
                }


                catch(Exception errore)
                {
                    Response.Write(errore.ToString());
                }


                using (SqlCommand cmd = new SqlCommand("UPDATE Tabella_Account SET Status='0' WHERE AuthCode= @AuthCode AND IdReg= @IdReg", conn))
                {
                    cmd.Parameters.AddWithValue("@AuthCode", pAuthCode);
                    cmd.Parameters.AddWithValue("@IdReg", pIdReg);
                    try
                    {
                        int risultato = cmd.ExecuteNonQuery();
                        Response.Write("Utente correttamente attivato: " + risultato.ToString());
                    }


                    catch(Exception queryError)
                    {
                        Response.Write(queryError.ToString());
                    }
                   
                }


            
          }
           


        }
    }
}