c# - 在 Blob MYSQL c# 中插入 imaga

Question

这是我的插入代码：我从 xamarin 应用程序中选择了一个图像，并尝试在转换后插入 MySql 数据库。请检查我的代码是否可以转换？我的代码没有插入数据库，我错在哪里？提前感谢您的帮助。

     private async void Button_Clicked(object sender, EventArgs e)
        {

            await CrossMedia.Current.Initialize();
            if(!CrossMedia.Current.IsPickPhotoSupported)
            {
                await DisplayAlert("info", "Picture not supported", "OK");
            }
            _mediaFile = await CrossMedia.Current.PickPhotoAsync(new PickMediaOptions { });

            if (_mediaFile == null)
                return;
            dir_local = _mediaFile.Path;
            file_name = Path.GetFileName(dir_local);
            _ = DisplayAlert("File Info", file_name, "OK");

            
            Stream fs = _mediaFile.GetStream();
            BinaryReader br = new BinaryReader(fs);
            byte[] bytes = br.ReadBytes((Int32)fs.Length);


            //MYSQL Connection
            MySqlConnection zeeconn = new MySqlConnection(Properties.Resources.db_con);
                       
            MySqlCommand cmd = new MySqlCommand("insert into tblTest (user,pass) values (@user,@pass)", zeeconn);
            

            var user = new MySqlParameter("@user", MySqlDbType.LongBlob, bytes.Length);
            var pass = new MySqlParameter("@pass", MySqlDbType.VarChar, 50);
            
            user.Value = bytes;
            pass.Value = "zero";

            cmd.Parameters.Add(user);
            cmd.Parameters.Add(pass);

            cmd.ExecuteNonQueryAsync();
            zeeconn.Close();

标签： c#mysqlxamarinblob