MarcoART_ Posts - Answer Overflow

MarcoART_

•Created by MarcoART_ on 1/15/2024 in #help

How to insert an image from a MediaPicker into my database in C# (MAUI)

Hello! 🙂 I'm new to MAUI and I'm facing challenges trying to insert an image from a MediaPicker into my database. What I do is obtain either my byte array using these lines:

await stream.CopyToAsync(memoryStream);
ImageData = memoryStream.ToArray();
photoPreview.Source = ImageSource.FromStream(() => new MemoryStream(ImageData));

await stream.CopyToAsync(memoryStream);
ImageData = memoryStream.ToArray();
photoPreview.Source = ImageSource.FromStream(() => new MemoryStream(ImageData));

or obtain the data in a base64 string value using this line:

base64string = Convert.ToBase64String(ImageData);

base64string = Convert.ToBase64String(ImageData);

The problem is, once I obtain these values that I need to insert into my database, and I execute the insert query, I'm getting this error: Microsoft.Data.SqlClient.SqlException: 'A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - Success)' This only happens if i'm including the image in the query, if I eliminate it, the other data can be inserted perfectly without showing me any error. This is my query:

byte[] bytesImagen = Convert.FromBase64String(base64string);

string cadena = @"Insert into Marco.CatUsuarios (Usuario, Nombre, Contrasena, NumTelefono, Imagen2, Ubicacion, Longitud, Latitud) values (@Usuario, @Nombre, @Contrasena, @NumTelefono, @Imagen2, @Ubicacion, @Longitud, @Latitud)";
 SqlCommand comando = new SqlCommand(cadena, conexion);

 comando.Parameters.AddWithValue("@Usuario", Usuario.Text);
 comando.Parameters.AddWithValue("@Nombre", Nombre.Text);
 comando.Parameters.AddWithValue("@Contrasena", Contrasena.Text);
 comando.Parameters.AddWithValue("@NumTelefono", NumTelefono.Text);
 comando.Parameters.AddWithValue("@Imagen2", bytesImagen);

 comando.ExecuteNonQuery();

byte[] bytesImagen = Convert.FromBase64String(base64string);

string cadena = @"Insert into Marco.CatUsuarios (Usuario, Nombre, Contrasena, NumTelefono, Imagen2, Ubicacion, Longitud, Latitud) values (@Usuario, @Nombre, @Contrasena, @NumTelefono, @Imagen2, @Ubicacion, @Longitud, @Latitud)";
 SqlCommand comando = new SqlCommand(cadena, conexion);

 comando.Parameters.AddWithValue("@Usuario", Usuario.Text);
 comando.Parameters.AddWithValue("@Nombre", Nombre.Text);
 comando.Parameters.AddWithValue("@Contrasena", Contrasena.Text);
 comando.Parameters.AddWithValue("@NumTelefono", NumTelefono.Text);
 comando.Parameters.AddWithValue("@Imagen2", bytesImagen);

 comando.ExecuteNonQuery();

And this is my connection string:

string connectionString = "Data Source=MyDataSource;Initial Catalog=MyInitialCatalog; User ID= MyUserID; Password = MyPassword; TrustServerCertificate=true;";

string connectionString = "Data Source=MyDataSource;Initial Catalog=MyInitialCatalog; User ID= MyUserID; Password = MyPassword; TrustServerCertificate=true;";

Thank You!

20 replies

Gaming

Programming