Update Method For Image in Win Form

Question

Respected All I have to write an application under visual studio 2013 community i want to write a student update methods with image i has been completed save,delete etc but update method is not working plz help if possible

waqas ahmed · Answer

Sorry Sir i am not able to write update statement

waqas ahmed · Answer

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 P · Answer

hi, kindly share your update statement, so that we can help you Thank you