ExecuteNonQuery throwing invalidCastException

本文关键字：invalidCastException throwing ExecuteNonQuery | 更新日期: 2023-09-27 18:17:01

我只是想做一个简单的更新数据库，我得到一个异常，我不明白。

这是代码-请帮助:

protected void btnmodif_Click(object sender, EventArgs e)
{
   SqlConnection sqlConn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["AGENDAConnectionString2"].ConnectionString );
   SqlCommand sqlComm = new SqlCommand();
   sqlComm = sqlConn.CreateCommand();
   sqlComm.CommandText = @"UPDATE RDV SET STATUES_COM = @STAT_COM WHERE INDICE = @ind";
   sqlComm.Parameters.Add("@STAT_COM", SqlDbType.VarChar);
   sqlComm.Parameters["@STAT_COM"].Value = DropDownList1.SelectedItem.Text;
   sqlComm.Parameters.Add("@ind", SqlDbType.VarChar);
   sqlComm.Parameters["@ind"].Value = Request.QueryString["Champ"].ToString();
   sqlConn.Open();
   sqlComm.ExecuteNonQuery();
   sqlConn.Close();
   Response.Write(@"<script language='javascript'>alert('SUCCESS');</script>");
}

我更新了代码

ExecuteNonQuery throwing invalidCastException

在您的按钮单击事件中使用以下代码替换您的代码

protected void btnmodif_Click(object sender, EventArgs e)
{
   var wasSuccessful = UpDateDB();
   if(wasSuccessful)
   {
      //Do Something 
   }
   else
   {
     //Do Something Else logging etc...
   }
}
public static bool UpDateDB()
{
    var ConnString = System.Configuration.ConfigurationManager.ConnectionStrings["AGENDAConnectionString2"].ConnectionString;
    bool successful = false;
    var ddlSelectedText = DropDownList1.SelectedItem.Text;
    var strUpdate = "UPDATE RDV SET STATUES_COM = @STAT_COM WHERE INDICE = @ind"; 
    using (SqlConnection connection = new SqlConnection(ConnString))
    {
        using (SqlCommand sqlComm = new SqlCommand(strUpdate, connection))
        {
            sqlComm.CommandType = CommandType.Text;
            sqlComm.Parameters.AddWithValue("@STAT_COM", ddlSelectedText);
            sqlComm.Parameters.AddWithValue("@ind", (string)Request.QueryString["Champ"]);
            sqlComm.CommandTimeout = 120;
            sqlComm.Connection.Open();
            try
            {
                sqlComm.ExecuteNonQuery();
                successful = true;
            }
            catch(SqlException SqlEx)
            {
                successful = false;
                //Write to a long SqlEx.Message
            }
        }
    }
    return successful;
}