bd nao atualiza no Form_LOAD

Question

 

MINHA DUVIDA É SIMPLES, COMO Q FACO PRA NO FORM_LOAD APARECER  O bd ATUALIZADO????
COM ESTE CODIGO ABAIXO NAO ACONTECE ISTO  , os dados sao inseridos com o  _queryINSERT mas ao abrir de novo o programa nao carrega o BD atualizado c/ as novas insercoes. 

Agradeço antecipadamente .

 

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data;
using System.Data.OleDb;

namespace waTr325
{
    public partial class frm325:Form
    {
        public frm325()
        {
            InitializeComponent();
        }

        OleDbConnection _connection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\bdDocTed3.mdb");
        OleDbCommand OLE_select = new OleDbCommand("SELECT AgBB, TelAg, Valor, HoraInicio, Contato, HoraAviso FROM tbl325");

        private void frm325_Load(object sender, EventArgs e)
 
  {
           
           
            // TODO: This line of code loads data into the 'bdDocTed3DataSet.tbl325' table. You can move, or remove it, as needed.

                _connection.Open();
              

                this.tbl325TableAdapter.Fill(this.bdDocTed3DataSet.tbl325);
                //this.tbl325TableAdapter.Update(bdDocTed3DataSet.tbl325);

                OleDbCommand ole_cmd_UPDATE = _connection.CreateCommand();
                ole_cmd_UPDATE.CommandText = "UPDATE `tbl325` SET TelAg =Valor=@Valor,HoraInicio=@HoraInicio, Contato=@Contato, WHERE Contato=@Contato
              
                ole_cmd_UPDATE.Parameters.Add("@Valor", OleDbType.Decimal).Value = txtValor.Text;
                ole_cmd_UPDATE.Parameters.Add("@HoraInicio", OleDbType.DBTimeStamp).Value = txtHoraInicio.Text;
                ole_cmd_UPDATE.Parameters.Add("@Contato", OleDbType.VarChar).Value = txtContato.Text;
               

            }

  private void btnAtualizar_Click(object sender, EventArgs e)
    {

             StringBuilder _queryINSERT = new StringBuilder("INSERT INTO `tbl325` (`Valor`, `HoraInicio`, `Contato`) VALUES (<%0,01%>', '<%12:00%>', '<%Jose%>')");
          
            _queryINSERT.Replace("<%0,01%>", txtValor.Text);

            _queryINSERT.Replace("<%12:00%>", txtHoraInicio.Text);
            _queryINSERT.Replace("<%Jose%>", txtContato.Text);
         

            OleDbCommand _command = new OleDbCommand(_queryINSERT.ToString(), _connection);
            _command.ExecuteNonQuery();   
      

            _connection.Close();
    }
  
       
    }//end public partial class frm325:Form

} //end namespace waTr325

Answer 1

Opa, tudo bem?

 

Você até fez o UPDATE, mas não o executou.

No Form_Load depois de adicionar os parâmetros, vc deve fazer:

ole_cmd_UPDATE.ExcuteNonQuery();