1
Good afternoon. I have a little problem with my code, and I need some help. I am inserting an image in my form in an image field, now I need to take this image and write an image field in a field in sql server. How can I make this recording.
below my code where I search the image on pc and play in Form.
private void btn_imagem_Click(object sender, EventArgs e)
{
open_imagem.FileName = "";
open_imagem.Title = "Imagem do Chamdo";
open_imagem.Filter = "JPEG | *.JPG | PNG | *.PNG";
open_imagem.ShowDialog();
}
private void open_imagem_FileOk(object sender, CancelEventArgs e)
{
pcb_imagem.Image = Image.FromFile(open_imagem.FileName);
}
Now follow the code of Insert.
public String cadchamado(String usuario, String departamento, String tipo, String comentario, DateTime data)
{
if (usuario != "")
{
tem = false;
cmd.CommandText = "insert into tbl_chamados values(@GM_USUARIO, @GM_DEPARTAMENTO, @GM_TIPO, @GM_COMENTARIO, @GM_DTINICIAL)";
cmd.Parameters.AddWithValue("@GM_USUARIO", usuario);
cmd.Parameters.AddWithValue("@GM_DEPARTAMENTO", departamento);
cmd.Parameters.AddWithValue("@GM_TIPO", tipo);
cmd.Parameters.AddWithValue("@GM_COMENTARIO", comentario);
cmd.Parameters.AddWithValue("@GM_DTINICIAL", data);
try
{
cmd.Connection = con.conectar();
cmd.ExecuteNonQuery();
con.desconectar();
this.mensagem = "Chamado incluído com sucesso!!";
tem = true;
}
catch (SqlException)
{
throw;
//this.mensagem = "Erro ao inserir chamado verifique!!";
}
}
else
{
this.mensagem = "Existem campos em branco por favor preencer, obrigado!!";
}
return mensagem;
}
I thank you in advance
The winforms is C#?
– Adriano Gomes
yes I have a form in c#
– Junior Guerreiro
I am from the java world and work with sql server database, I believe the concept is the same. This type of data (image) maps itself in its class as byte array (byte[]). Then I believe you will need to transform this file into a byte[] and then save. Check out these examples, I think it will help you: https://www.codeproject.com/Questions/736961/Save-file-in-sql-database-in-csharp-winform
– Adriano Gomes
Recording images in the database is a bad idea... In your Index I do not see the parameter for the image blob... update your question showing how you are doing and where you are finding the error. [MCVE]
– Leandro Angelo
OK thanks for the help Adriano Gomes, I managed to make the recording.
– Junior Guerreiro
@So it would be interesting for you to post the answer with your solution or close the question
– Leandro Angelo