© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
C#C
C#•4y ago•
2 replies
Hiccup

❔ Decoded bitmap images aren't set in the photoboxes correctly

private void BTN_Save_Click(object sender, EventArgs e)
        {
            string DBpath = @"Data Source=.\StudentDB.db;Version=3;";
            Bitmap[] PictureBoxesBitmaps = {FirstPictureBitmap, SecondPictureBitmap, ThirdPictureBitmap };
            using SQLiteConnection connection = new(DBpath);
            using SQLiteCommand cmd = new(DBpath, connection);
            connection.Open();
            cmd.CommandText = @"DELETE FROM PictureBoxes";
            cmd.ExecuteNonQuery();
            foreach (Bitmap bitmap in PictureBoxesBitmaps)
            {
                System.IO.MemoryStream ms = new();
                bitmap?.Save(ms, ImageFormat.Png);
                byte[] BitmapByteArray = ms.ToArray();
                var PictureBox64 = Convert.ToBase64String(BitmapByteArray);
                cmd.CommandText = @"INSERT INTO PictureBoxes(Encoded) VALUES('" + PictureBox64 + "')";
                cmd.ExecuteNonQuery();
            }
            connection.Close();
        }
private void BTN_Save_Click(object sender, EventArgs e)
        {
            string DBpath = @"Data Source=.\StudentDB.db;Version=3;";
            Bitmap[] PictureBoxesBitmaps = {FirstPictureBitmap, SecondPictureBitmap, ThirdPictureBitmap };
            using SQLiteConnection connection = new(DBpath);
            using SQLiteCommand cmd = new(DBpath, connection);
            connection.Open();
            cmd.CommandText = @"DELETE FROM PictureBoxes";
            cmd.ExecuteNonQuery();
            foreach (Bitmap bitmap in PictureBoxesBitmaps)
            {
                System.IO.MemoryStream ms = new();
                bitmap?.Save(ms, ImageFormat.Png);
                byte[] BitmapByteArray = ms.ToArray();
                var PictureBox64 = Convert.ToBase64String(BitmapByteArray);
                cmd.CommandText = @"INSERT INTO PictureBoxes(Encoded) VALUES('" + PictureBox64 + "')";
                cmd.ExecuteNonQuery();
            }
            connection.Close();
        }

I'm using this first code to encode three bitmap images into a base64 string, then I'm storing them in a SQLite database.
C# banner
C#Join
We are a programming server aimed at coders discussing everything related to C# (CSharp) and .NET.
61,871Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Class Objects Aren't Working Correctly?
C#CC# / help
2y ago
Bad Bitmap quality
C#CC# / help
13mo ago
✅ bitmap bug question
C#CC# / help
3y ago