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