如何在c＃中将图像从数据库检索到图片框 [英] how to retrieve image from database into picturebox in c#

问题描述

亲爱的，

i无法将图像从数据库中检索到c＃中的图片框中，并且在执行代码时显示错误参数无效



，这是我的代码

Dear all,
i unable to retrieve image from database into picturebox in c# and while executing the code it is displaying an error "Parameter is not valid "

and here is my code

private void view_Load(object sender, EventArgs e)
       {
           try
           {
               SqlConnection con = new SqlConnection();
               con.ConnectionString = "Data Source=SOFT;Initial Catalog=Dev01;Integrated Security=True";
               con.Open();
               //Retrieve BLOB from database into DataSet.
               SqlDataReader myReader = null;
               SqlCommand cmd = new SqlCommand("select * from empdetails", con);
               myReader = cmd.ExecuteReader();
               while (myReader.Read())
               {
                   lbl_fname.Text = myReader["firstname"].ToString();
                   lbl_mname.Text = myReader["middlename"].ToString();
                   lbl_lname.Text = myReader["lastname"].ToString();
                   lbl_gender.Text = myReader["gender"].ToString();
                   lbl_dob.Text = myReader["dob"].ToString();
                   lbl_qualification.Text = myReader["qualification"].ToString();
                   lbl_skills.Text = myReader["skills"].ToString();
                   lbl_userid.Text = myReader["username"].ToString();
                   lbl_pwd.Text = myReader["password"].ToString();
                   lbl_cpwd.Text = myReader["confirmpassword"].ToString();
                   lbl_mno.Text = myReader["mobilenumber"].ToString();
                   lbl_altmno.Text = myReader["alternativenumber"].ToString();
                   lbl_email.Text = myReader["email"].ToString();
                   lbl_presentadd.Text = myReader["presentaddress"].ToString();
                   lbl_permanentadd.Text = myReader["permanentaddress"].ToString();

               }
               myReader.Close();
               SqlDataAdapter da = new SqlDataAdapter(cmd);
               DataSet ds = new DataSet();
               da.Fill(ds, "empdetails");
               int c = ds.Tables["empdetails"].Rows.Count;

               if (c > 0)
               {   //BLOB is read into Byte array, then used to construct MemoryStream,
                   //then passed to PictureBox.
                   //SqlCommand cmd1=new SqlCommand("Select photo from empdetails");
                   Byte[] bytedata = new Byte[0];

                   bytedata = (Byte[])(ds.Tables["empdetails"].Rows[c - 1]["photo"]);
                   MemoryStream ms = new MemoryStream(bytedata);
                   pictureBox1.Image = Image.FromStream(ms,true); //HERE I AM GETTING ERROR
               }
               con.Close();
           }
           catch (Exception ex)
             { MessageBox.Show(ex.Message);
            }

我已经检查了各种页面，但这并没有解决我的问题。我只在这部分得到错误

I already checked various pages but that didn't solve my prolem. I am getting error only in this part

pictureBox1.Image = Image.FromStream(ms,true);

请确实需要完整的

Please do need full

推荐答案

最有可能，这是怎么回事你救了他们：为什么我得到参数无效。我从数据库中读取图像时出现异常？ [ ^ ]

Most likely, it's how you saved them: Why do I get a "Parameter is not valid." exception when I read an image from my database?[^]

这篇关于如何在c＃中将图像从数据库检索到图片框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！