Update Method For Image in Win Form

Respected Sir

I have no idea iam only save statement as

BROWSE BUTTON

private void button1_Click(object sender, EventArgs e)

{

OpenFileDialog dia = new OpenFileDialog();

dia.Filter = "png files(*.png)|*.png|jpg files(*.jpg)|*.jpg|All files(*.*)|*.*";

if (dia.ShowDialog() == DialogResult.OK)

{

imagelocation = dia.FileName.ToString();

pictureBox1.ImageLocation = imagelocation;

}

SAVE BUTTON

SQLiteConnection conn = new SQLiteConnection("Data Source=Pic.db;Version=3;");

byte[] images = null;

FileStream fs = new FileStream(imagelocation, FileMode.Open, FileAccess.Read);

BinaryReader br = new BinaryReader(fs);

images = br.ReadBytes((int)fs.Length);

conn.Open();

string sql = "INSERT INTO Image(NAME,FN,Image)VALUES('"+textBox1.Text+"','"+textBox2.Text+"',@images)";

SQLiteCommand cmd = new SQLiteCommand(sql, conn);

cmd.Parameters.Add(new SQLiteParameter("@images", images));

int N = cmd.ExecuteNonQuery();

MessageBox.Show("Data added");

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

waqas ahmed8y ago
Sorry Sir i am not able to write update statement
waqas ahmed8y ago
Respected Sir

I have no idea iam only save statement as
BROWSE BUTTON
private void button1_Click(object sender, EventArgs e)
{
OpenFileDialog dia = new OpenFileDialog();
dia.Filter = "png files(*.png)|*.png|jpg files(*.jpg)|*.jpg|All files(*.*)|*.*";
if (dia.ShowDialog() == DialogResult.OK)
{
imagelocation = dia.FileName.ToString();
pictureBox1.ImageLocation = imagelocation;
}

}

SAVE BUTTON
SQLiteConnection conn = new SQLiteConnection("Data Source=Pic.db;Version=3;");
byte[] images = null;
FileStream fs = new FileStream(imagelocation, FileMode.Open, FileAccess.Read);
BinaryReader br = new BinaryReader(fs);
images = br.ReadBytes((int)fs.Length);
conn.Open();
string sql = "INSERT INTO Image(NAME,FN,Image)VALUES('"+textBox1.Text+"','"+textBox2.Text+"',@images)";

SQLiteCommand cmd = new SQLiteCommand(sql, conn);
cmd.Parameters.Add(new SQLiteParameter("@images", images));
int N = cmd.ExecuteNonQuery();
MessageBox.Show("Data added");
Rafnas T P8y ago
hi,
kindly share your update statement, so that we can help you
Thank you