
Originariamente inviata da
djciko
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());
}
}
}
}
}
}