busca informacoes do campo da tablela utilizando o textbox "ID" para fazer um consulta e recuperar colocando os valores nos outros
textbox
GOstaria de exemplo tambem com o DataSet e etc .. AGRADECO
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
namespace tentantomdb
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void ObterDadosBdDst()
{
//*String de conexão com o banco
string stringconn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=J:\LEONE\Cursos e esdudos de TI\Dot net\Aprendendo Net 2010\bancoteste.mdb;Mode=Share Deny None; User ID=;Password=";
//*Cria a conexão com o banco
OleDbConnection conn = new OleDbConnection(stringconn);
//*Abre conexão
conn.Open();
//*String de consulta
string SqlQuery = "select * from cadastro";
OleDbCommand cmd = new OleDbCommand(SqlQuery, conn);
OleDbDataAdapter adpt = new OleDbDataAdapter(cmd);
DataTable dtCadastro = new DataTable("cadastro");
DataSet ds1 = new DataSet();
ds1.Tables.Add(dtCadastro);
adpt.Fill(ds1, "cadastro");
dataGridView1.DataSource = ds1;
dataGridView1.DataMember = "cadastro";
}
private void Limpacampos()
{
this.idTextBox.Clear();
this.nomeTextBox.Clear();
this.emailTextBox.Clear();
this.telefoneTextBox.Clear();
//patientFirstNameTextBox.Clear();
//patientFirstNameTextBox.Clear();
//patientDOBPicker.Value = DateTime.Today;
//patientGroupBox.Enabled = false;
//patientPhoto.Image = null;
}
private void Form1_Load(object sender, EventArgs e)
{
Limpacampos();
}
private void Listar1_Click(object sender, EventArgs e)
{
Form2 Formula2 = new Form2();
Formula2.Show();
//Form2.ActiveForm();
}
private void Listar2_Click(object sender, EventArgs e)
{
Form3 Formulario3 = new Form3();
Formulario3.Show();
}
private void Listar3_Click(object sender, EventArgs e)
{
Form4 Formulario3 = new Form4();
Formulario3.Show();
}
private void btnIncluir_Click(object sender, EventArgs e)
{
//*String de conexão com o banco
string stringconn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=J:\LEONE\Cursos e esdudos de TI\Dot net\Aprendendo Net 2010\bancoteste.mdb;Mode=Share Deny None; User ID=;Password=";
//*Cria a conexão com o banco
OleDbConnection conn = new OleDbConnection(stringconn);
//*Abre conexão
conn.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.CommandText = "INSERT INTO cadastro (nome,email,telefone) VALUES (@nome, @email, @telefone)";
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@nome", this.nomeTextBox.Text);
cmd.Parameters.AddWithValue("@email", this.emailTextBox.Text);
cmd.Parameters.AddWithValue("@telefone", this.telefoneTextBox.Text);
//cmd.Parameters.AddWithValue("@nome", "inserimanual");
// cmd.Parameters.AddWithValue("@email", "testeia@teste.com");
// cmd.Parameters.AddWithValue("@telefone", "12345678");
//cmd.ExecuteNonQuery();
int rowsAffected = cmd.ExecuteNonQuery();
if (rowsAffected == 1)
MessageBox.Show("Dados inseridos com êxito!");
//Console.WriteLine("Row inserted successfully.");
//Finaliza os objetos
conn.Close();
Limpacampos();
}
private void btnConsultar_Click(object sender, EventArgs e)
{
//define os objetos DataReader, Connection e Command
OleDbDataReader reader = null;
OleDbConnection con = null;
OleDbCommand cmd = null;
try
{
//*String de conexão com o banco
string stringconn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=J:\LEONE\Cursos e esdudos de TI\Dot net\Aprendendo Net 2010\bancoteste.mdb;Mode=Share Deny None; User ID=;Password=";
//*Cria a conexão com o banco
OleDbConnection conn = new OleDbConnection(stringconn);
//*Abre conexão
conn.Open();
//*String de consulta // define um comando para selecionar
string CommandText = "select * from cadastro WHERE id=?criterioID";
//associa comando a conexão
cmd = new OleDbCommand(CommandText);
cmd.Connection = con;
// Define o parâmetro @criterio e seu tipo de dados
cmd.Parameters.Add(new OleDbParameter("?criterioID", System.Data.OleDb.OleDbType.Integer));
cmd.Parameters["?criterioID"].Value = idTextBox.Text;
// sqldr.Read();
//OleDbDataReader reader = cmd.ExecuteReader();
reader = cmd.ExecuteReader();
return reader;
Limpacampos();
reader.Read();
//idTextBox = ;
//this.nomeTextBox.Text = reader["nome"].ToString();
//this.emailTextBox.Text = reader["email"].ToString();
//this.telefoneTextBox.Text = reader["telefone"].ToString();
this.nomeTextBox.Text = reader.GetString(1);
this.emailTextBox.Text = reader.GetString(2);
this.telefoneTextBox.Text = reader.GetString(3);
}
catch (Exception ex)
{
// exibe mensagem de erro
MessageBox.Show(ex.Message);
}
finally
{
// fecha o data reader e a conexão
if (reader != null)
reader.Close();
if (con.State == ConnectionState.Open)
con.Close();
}
}
private void btnEditar_Click(object sender, EventArgs e)
{
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
}
private void button1_Click(object sender, EventArgs e)
{
ObterDadosBdDst();
}
private void button2_Click(object sender, EventArgs e)
{
dtrTexrbox Formulario5 = new dtrTexrbox();
Formulario5.Show();
}
}
}
EM ANEXO A SOLUCAO
Attached Files
-
tentantomdb.zip 48.03KB
32 downloads
