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 MySql.Data.MySqlClient;
using System.IO;
namespace PeShow
{
public partial class FProdutoNovo : Form
{
private MySqlConnection mConn = null;
private DataSet bdDataSet = null;
private MySqlCommand commS = null;
private MySqlDataReader rs = null;
public String localimagem = "C:\\Users\\user\\Documents\\huahuauha.jpg";
public String armazenaimagem = null;
public FProdutoNovo()
{
InitializeComponent();
}
private void alterarToolStripMenuItem_Click(object sender, EventArgs e)
{
carregaImagem();
}
private void FProdutoNovo_Load(object sender, EventArgs e)
{
abreconexao();
}
######################################################
CARREGANDO A IMAGEM NO PICTUREBOX
######################################################
private void carregaImagem()
{
OpenFileDialog openFileDialog1 = new OpenFileDialog();
openFileDialog1.Filter = "JPeg Image|*.jpg|Bitmap Image|*.bmp|Gif Image|*.gif";
openFileDialog1.Title = "Abrir Imagem";
if (openFileDialog1.ShowDialog() == DialogResult.OK)
{
pictureBox1.ImageLocation = openFileDialog1.FileName;
armazenaimagem = openFileDialog1.FileName;
}
else
{
pictureBox1.ImageLocation = localimagem;
}
}
####################################
ABRINDO A CONEXAO
####################################
public void abreconexao()
{
bdDataSet = new DataSet();
mConn = new MySqlConnection(" Persist Security Info=False;server=localhost;database=peeshow;uid=root;server=localhost;database=peeshow;uid=root;pwd=root");
try
{
mConn.Open();
}
catch
{
MessageBox.Show("Error na Conexão ao banco.");
}
}
########################################################################
AQUI ESTOU TENTANDO ARMAZENAR A IMAGEM O LOCAL, QUE ESTA NA VARIAVEL ARMAZENAIMAGEM
################## ######################################################
private void button1_Click(object sender, EventArgs e)
{
if (mConn.State == ConnectionState.Open)
{
MySqlCommand command = new MySqlCommand("insert into produto(imagem) values('" + armazenaimagem + "')", mConn);
if (MessageBox.Show("Confirma inclusão? ", "Incluir", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
command.BeginExecuteNonQuery();
MessageBox.Show(armazenaimagem);
}
else
{
Close();
}
}
}
###########
NESSE BOTAO EU TENTO CAPTURAR O LOCAL DA IMAGEM....
###########
private void button2_Click(object sender, EventArgs e)
{
MySqlCommand cm1 = new MySqlCommand("select imagem from produto where idproduto = 1", mConn);
rs = cm1.ExecuteReader();
if (rs.Read())
{
String a = rs["imagem"].ToString();
textBox1.Text = a;
pictureBox2.ImageLocation = a;
}
}
}
}
