SqlConnection con = new SqlConnection(@"Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|cms.mdf;Integrated Security=True;User Instance=True");
con.Open();
SqlCommand cmd = new SqlCommand("selecthome", con);
cmd.Parameters.Add("@monthlyachiever", SqlDbType.NVarChar).Value = monthlyachiever.Text;
cmd.Parameters.Add("@topachiever", SqlDbType.NVarChar).Value = txttopachiever.Text;
cmd.Parameters.Add("@training", SqlDbType.NVarChar).Value = txttraining.Text;
cmd.Parameters.Add("@otherinformation", SqlDbType.NVarChar).Value = txtotherinformationhome.Text;
cmd.Parameters.Add("@image", SqlDbType.Image).Value = Convert.ToByte( fileupload.FileContent);
cmd.CommandText = "selecthome";
string c1 = (string)cmd.Parameters["@monthlyachiever"].Value;
Label6.Text = c1;
string c2 = (string)cmd.Parameters["@topachiever"].Value;
Label4.Text = c2;
string c3 = (string)cmd.Parameters["@training"].Value;
Label2.Text = c3;
string c4 = (string)cmd.Parameters["@otherinformation"].Value;
Label3.Text = c4;
Image c5 = (Image)cmd.Parameters["@image"].Value;
Image1 = c5;
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
con.Close();
问题是这一行:Convert.ToByte( fileupload.FileContent);
由于FileContent
是一个Stream
您必须从中读取数据,因此不能直接将其转换为字节数组。
有关如何执行此操作,请参阅从流创建字节数组。