How to insert image and text into SQL server C# windows application. EASY STEPS.
//// imageToByte (Function)/////
public byte[] imagetobyte(Image img)
{
MemoryStream ms = new MemoryStream();
img.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
return ms.ToArray();
}
/////////
////////Brows button code//////
private void metroButton8_Click_1(object sender, EventArgs e)
{
OpenFileDialog op = new OpenFileDialog();
if (op.ShowDialog() == DialogResult.OK)
{
pictureBox1.ImageLocation = op.FileName;
}
}
//////////////
//////////SAVE button code///////////
private void metroButton9_Click(object sender, EventArgs e)
{
Database.DBGeneral obj = new Database.DBGeneral();
SqlCommand cmd = new SqlCommand("insert into Student_Registration(Name,FName,Picture,UserHistory) Values('"+txtname.Text+"','"+txtfname.Text+"',@img,'"+txtuser.Text+"')",obj.conn);
cmd.Parameters.Add("@img", SqlDbType.Image).Value = imagetobyte(pictureBox1.Image);
obj.generalQuery(cmd);
MessageBox.Show("Record Inserted Successfully!");
}
/////////////////////////////////