如何修复这个错误..'没有给出一个或多个必需参数的值'。 [英] how to fix this erroe..'No value given for one or more required parameters'.

问题描述

private void btnSubmit_Click(object sender, EventArgs e)
      {
          byte[] picbyte = System.IO.File.ReadAllBytes(textBox.Text);
          try
          {
              string constr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=.\\PIS(ACU).mdb;";
              Con = new OleDbConnection(@constr);
              Con.Open();
              Com = new OleDbCommand();
              Com.Connection = Con;
              Com.CommandText = "INSERT INTO PatientImages (Patient_Id,ImageDate,Photo,ImageName)VALUES(" + txtPatientId.Text + ",'" + txtImageDate.Value.ToString("yyyy/MM/dd HH:mm:ss") + "', @Photo ," + txtImageName.Text + ")";
              OleDbParameter picParam = Com.Parameters.Add("@Photo", SqlDbType.Binary);
              picParam.Value = picbyte.ToArray();
              picParam.Size = picbyte.ToArray().Length;
              Com.ExecuteNonQuery();
          }
          catch (Exception ex)
          {
              MessageBox.Show(ex.Message);
          }
          finally
          {
              Con.Close();
              MessageBox.Show("Image Uploaded Successfully", "PIS System");

          }

      }

推荐答案

嘿那里，



尝试在 txtImageName.Text 周围添加单引号。



我建议您使用参数作为所有值，因为您使用 @Photo 作为照片。



希望它有所帮助，让我知道它是怎么回事。



Azee ......

hey there,

Try adding single quotes around txtImageName.Text.

I would suggest you to use Parameters for all Values as you used @Photo for Photo.

Hope it helps, let me know how it goes.

Azee...

这篇关于如何修复这个错误..'没有给出一个或多个必需参数的值'。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！