Форум программистов [Powered by Invision Power Board]

Код


System.Data.OleDb.OleDbException was unhandled by user code
  Message="Отсутствует значение для одного или нескольких требуемых параметров."
  Source="Microsoft JET Database Engine"
  ErrorCode=-2147217904
  StackTrace:
       в System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
       в System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
       в System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
       в System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
       в System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
       в System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
       в EditTeams.UpdateBase(Object sender, EventArgs E) в d:\F1\EditTeams.aspx.cs:строка 79
       в System.Web.UI.WebControls.Button.OnClick(EventArgs e)
       в System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
       в System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
       в System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
       в System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
       в System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
  InnerException:

Код


        string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + @"Data Source=D:\F1\App_Data\Base.mdb";

        using (OleDbConnection connection = new OleDbConnection(connectionString))
        {
            connection.Open();

            OleDbCommand command = new OleDbCommand("UPDATE Teams SET `Place`='" + textBox5.Text + "', `Teams`='" + textBox6.Text + "',  `Bals`='" + textBox7.Text + "' WHERE `ID`='" + textBox8.Text + "' ", connection);
            try
            {
                command.ExecuteNonQuery();
                Response.Redirect("EditTeams.aspx");
            }
            catch (OleDbException e)
            {
                string Msg = "ОШИБКА: Обновить запись не удалось.";
                Label1.Text = Msg;
                Response.Write("");
            }
        }