private void button1_Click(object sender, EventArgs e) { try { OpenFileDialog dlg = new OpenFileDialog(); dlg.Filter = "JPG Files (*.jpg|*.jpgg|GIF Files (*.gif)|*,gif|All Files (*.*)|*.*"; dlg.Title = " Select Animal Image "; if (dlg.ShowDialog() == DialogResult.OK) { img = dlg.FileName.ToString(); pictureBox1.ImageLocation = img; } } catch (Exception ex) { MessageBox.Show(ex.Message); } } private void button2_Click(object sender, EventArgs e) { byte[] imgdata = readimage(img); SqlConnection obj = new SqlConnection(); obj.ConnectionString = "Data Source=KHATRII;Initial Catalog=varun;Integrated Security=True"; obj.Open(); SqlCommand cmd = new SqlCommand("insert into Table2 values(@idd,@imge", obj); cmd.Parameters.Add("@id", SqlDbType.NVarChar, 50).Value = (textBox1.Text); cmd.Parameters.Add("@imge", imgdata); cmd.ExecuteNonQuery(); } private byte[] readimage(string img) { byte[] imagedata = null; FileInfo fs = new FileInfo(img); long length = fs.Length; FileStream files = new FileStream(img, FileMode.Open, FileAccess.Read); BinaryReader br = new BinaryReader(files); imagedata = br.ReadBytes((int)length); return imagedata; }
)
// Add closing tag after '@imge' SqlCommand cmd = new SqlCommand("insert into Table2 values(@idd,@imge", obj);
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)