Select IMAGE from SQL BASE to picturebox C#

Code working fine

I need to put picture from sql to picturebox in my code

private void prijavaAction() //04.04. final doradjena perfect
{
{
SqlConnection con = new SqlConnection(cs);
if (textBox1.Text.All(char.IsDigit))
{
string queryString = "SELECT [ime_prezime] FROM dbo.radnici WHERE bar_kod = '" + textBox1.Text + "'";// pronaci radnika u bazi
using (SqlConnection connection = new SqlConnection(cs))
{
SqlCommand command = new SqlCommand(queryString, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
string commanda = "select case when (SELECT (DATEDIFF(SECOND, Max(vrijemeprijave), GETDATE()) / 60) from dbo.prijava_radnika where status='prijavljen' and radnik= (" + queryString + ")) < 5 THEN 1 ELSE 0 END";
SqlConnection connection3 = new SqlConnection(cs);
SqlCommand command2 = new SqlCommand(commanda, connection3);
connection3.Open();
int broj = Convert.ToInt32(command2.ExecuteScalar());
string commanda2 = "select case when (SELECT (DATEDIFF(SECOND, Max(vrijemeodjave), GETDATE()) / 60) from dbo.prijava_radnika where status='odjavljen' and radnik= (" + queryString + ")) < 5 THEN 1 ELSE 0 END";
SqlConnection connection4 = new SqlConnection(cs);
SqlCommand command4 = new SqlCommand(commanda2, connection4);
connection4.Open();
int broj2 = Convert.ToInt32(command4.ExecuteScalar());
if (broj == 1 || broj2 == 1)
{
notificationPanel.BackColor = System.Drawing.ColorTranslator.FromHtml("#FD7400");
messageLabel.Text = "Prijava i odjava su blokirani 5 minuta \nza ovog radnika";
textBox1.Text = "";
}
else
{
try
{
if (reader.Read())
{
string prijava = "SELECT count(*) from dbo.prijava_radnika where vrijemeprijave is not null and vrijemeodjave is null and radnik = '" + readerresultTextbox.Text + "' and redni_broj is NULL";
SqlCommand provjeraprijaveradnika = new SqlCommand(prijava, con);
con.Open();
int result = Convert.ToInt32(provjeraprijaveradnika.ExecuteScalar());
con.Close();
if ((result == 0))
{
String saveStaff = "INSERT INTO dbo.prijava_radnika (vrijemeprijave, status, radnik,idfakture) VALUES(@vrijemeprijave,'prijavljen', '" + readerresultTextbox.Text + "',@idfakture)";
using (SqlConnection openCon2 = new SqlConnection(cs))
{
using (SqlCommand querySaveStaff = new SqlCommand(saveStaff))
{
querySaveStaff.Connection = openCon2;
querySaveStaff.Parameters.Add("@vrijemeprijave", SqlDbType.DateTime).Value = DateTime.Now;
querySaveStaff.Parameters.Add("@idfakture", SqlDbType.Int).Value = id_fakture;
openCon2.Open();
querySaveStaff.ExecuteNonQuery();
openCon2.Close();
notificationPanel.BackColor = System.Drawing.ColorTranslator.FromHtml("#2EFF36");
// messageLabel.Text = (reader["ime_prezime"].ToString()) + " je prijavljen u \n " + DateTime.Now.ToString("dd.MM.yyyy HH:mm:ss");
messageLabel.Text = ("Dobro došli na posao...\n" + reader["ime_prezime"].ToString()) + " \nPrijavljeni ste od\n " + DateTime.Now.ToString("dd.MM.yyyy HH:mm:ss");
readerresultTextbox.Text = (reader["ime_prezime"].ToString());
}
}
}
else
{
String updateStaff = " declare @maxNo integer = 0 select @maxNo = isnull(max(redni_broj), 0) from[dbo].[prijava_radnika] UPDATE[dbo].[prijava_radnika] SET"
+ " [vrijemeodjave] = @vrijemeodjave,[redni_broj] = (@maxNo+1),[status] = 'odjavljen' WHERE radnik = '" + readerresultTextbox.Text + "'and [status] = 'prijavljen'";
using (SqlConnection connection1 = new SqlConnection(cs))
{
SqlCommand command1 = new SqlCommand(queryString, connection1);
connection1.Open();
SqlDataReader reader1 = command1.ExecuteReader();
connection.Close();
try
{
if (reader1.Read())
{
using (SqlConnection openCon3 = new SqlConnection(cs))
{
using (SqlCommand queryupdateStaff = new SqlCommand(updateStaff))
{
queryupdateStaff.Connection = openCon3;
queryupdateStaff.Parameters.Add("@vrijemeodjave", SqlDbType.DateTime).Value = DateTime.Now;
openCon3.Open();
queryupdateStaff.ExecuteNonQuery();
openCon3.Close();
}
}
notificationPanel.BackColor = System.Drawing.ColorTranslator.FromHtml("#FFE11A");
messageLabel.Text = (reader1["ime_prezime"].ToString()) + " je odjavljen u \n " + DateTime.Now.ToString("dd.MM.yyyy HH:mm:ss");
}
}
catch { }
}
reader.Close();
}
}
else
{
notificationPanel.BackColor = System.Drawing.ColorTranslator.FromHtml("#FD7400");
messageLabel.Text = "Radnik ne postoji u bazi! \nProverite vašu karticu ili probajte ponovo!";
textBox1.Text = "";
}
}
finally
{
}
}
}
}
else
{
notificationPanel.BackColor = System.Drawing.ColorTranslator.FromHtml("#FD7400");
messageLabel.Text = "Bar kod nije važeci ili nije bar kod";
textBox1.Text = "";
}
}
}

2 Replies

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

Goran Bibic8y ago
I am find solution
using (var stream = new MemoryStream((byte[])reader4["data"]))
pictureBox.Image = Image.FromStream(stream);
Goran Bibic8y ago
I put this in complete code on finally (line 141 code up)...

Error line 10 (code down)

Error CS0029 Cannot implicitly convert type 'string' to 'System.Drawing.Image'
string slika = "SELECT [data] FROM dbo.radnici WHERE ime_prezime = '" + readerresultTextbox.Text + "'";// pronaci radnika u bazi
using (SqlConnection connection2 = new SqlConnection(cs))
{
    SqlCommand command3 = new SqlCommand(slika, connection2);
    connection2.Open();
    SqlDataReader reader4 = command3.ExecuteReader();
    connection2.Close();
    if(reader4.Read())
    {
        pictureBox.Image = (reader4["data"].ToString());
    }
    else
    {
        //
    }
}