Insert picture in datagrid c#

Goran Bibic

8y888Learn iOS Programming

Problem line 13 and 38..data column type is image in sql

Or some recomandition to insert into and update pciture from picture box

String cs = "Data Source=.\\SQLEXPRESS;Initial Catalog=bss;Integrated Security=True";
if (string.IsNullOrEmpty(idTextBox.Text))
{
using (SqlConnection openCon = new SqlConnection(cs))
{
string saveStaff = "INSERT into dbo.poslovni_partneri (Ime, data) VALUES (@Ime,@data)";
using (SqlCommand querySaveStaff = new SqlCommand(saveStaff))
{
querySaveStaff.Connection = openCon;
querySaveStaff.Parameters.Add("@Ime", SqlDbType.VarChar, 255).Value = imeTextBox.Text;
querySaveStaff.Parameters.Add("@data", SqlDbType.image).Value = pictureBox.Text;
openCon.Open();
querySaveStaff.ExecuteNonQuery();
openCon.Close();
}
}
}
else
{
using (SqlConnection openCon = new SqlConnection(cs))
{
string saveStaff = "UPDATE dbo.poslovni_partneri SET Ime=@Ime, data=@data WHERE id=" + idTextBox.Text;
using (SqlCommand querySaveStaff = new SqlCommand(saveStaff))
{
querySaveStaff.Connection = openCon;
querySaveStaff.Parameters.Add("@Ime", SqlDbType.VarChar, 255).Value = imeTextBox.Text;
querySaveStaff.Parameters.Add("@data", SqlDbType.image).Value = pictureBox.Text;
openCon.Open();
querySaveStaff.ExecuteNonQuery();
MessageBox.Show("Uspješno ste izmenili stavku!", "Informacija", MessageBoxButtons.OK, MessageBoxIcon.Information);
openCon.Close();
}
}
}

For upload picture in picture box use this code and it work...

private void button4_Click(object sender, EventArgs e)
{
//Read image file
using (OpenFileDialog ofd = new OpenFileDialog() { Filter = "JPEG|*.jpg", ValidateNames = true, Multiselect = false })
{
if (ofd.ShowDialog() == DialogResult.OK)
{
fileName = ofd.FileName;
lblFilename.Text = fileName;
dataPictureBox1.Image = System.Drawing.Image.FromFile(fileName);
}
}
}

5 Replies

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

Rafnas T P8y ago
Accepted answer
full code
byte[] img_arr=null;
    MemoryStream ms = new MemoryStream();
    dataPictureBox1.Image.Save(ms, dataPictureBox1.Image.RawFormat);
    img_arr = ms.GetBuffer();
String cs = "Data Source=.\\SQLEXPRESS;Initial Catalog=bss;Integrated Security=True";
            if (string.IsNullOrEmpty(idTextBox.Text))
            {
                using (SqlConnection openCon = new SqlConnection(cs))
                {
                    string saveStaff = "INSERT into dbo.poslovni_partneri (Ime, data) VALUES (@Ime,@data)";
                    using (SqlCommand querySaveStaff = new SqlCommand(saveStaff))
                    {
                        querySaveStaff.Connection = openCon;
                        querySaveStaff.Parameters.Add("@Ime", SqlDbType.VarChar, 255).Value = imeTextBox.Text;
                        querySaveStaff.Parameters.AddWithValue("@data",img_arr);
                          openCon.Open();
                        querySaveStaff.ExecuteNonQuery();
                        openCon.Close();
                    }
                }
            }
            else
            {
                using (SqlConnection openCon = new SqlConnection(cs))
                {
                    string saveStaff = "UPDATE  dbo.poslovni_partneri SET Ime=@Ime, data=@data WHERE id=" + idTextBox.Text;
using (SqlCommand querySaveStaff = new SqlCommand(saveStaff))
                    {
                        querySaveStaff.Connection = openCon;
                        querySaveStaff.Parameters.Add("@Ime", SqlDbType.VarChar, 255).Value = imeTextBox.Text;                         querySaveStaff.Parameters.AddWithValue("@data",img_arr);
                        openCon.Open();
                        querySaveStaff.ExecuteNonQuery();
                        MessageBox.Show("Uspješno ste izmenili stavku!", "Informacija", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        openCon.Close();
                    }
                }
            }
+1
Goran Bibic8y ago
Instead line 13?
0
Goran Bibic8y ago
Aha...that not do...in which line put this code?
0
Rafnas T P8y ago
hi,

to save image , you have to convert that image into byte array

try code
  byte[] img_arr=null;
    MemoryStream ms = new MemoryStream();
    dataPictureBox1.Image.Save(ms, dataPictureBox1.Image.RawFormat);
    img_arr = ms.GetBuffer();
   querySaveStaff.Parameters.AddWithValue("@data",img_arr);
+1
Amit Gupta8y ago
Complete example for saving image to database
https://www.c-sharpcorner.com/uploadfile/e628d9/inserting-retrieving-images-from-sql-server-database-without-using-stored-procedures/

If you have large images and having more quantities then I recommend not to save image into the database, it will unnecessary increases the db size.

Alternatively, you can save the image path to database and retrieve that from your code
+2