c#读取数据库照片 出错 求大神

Question

读取的时候出现参数无效 求大神帮忙啊 网上的代码全试了 都不行

Answer 1

byte[] imagebytes = null;
int bh = 0;
string sc = this.listView1.SelectedItems[0].Text;
SqlConnection sq = new SqlConnection();
sq.ConnectionString = "server=.;database=PhoneBook;uid=sa;pwd=2300700;";
sq.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = sq;
cmd.CommandText = "select * from 联系人 where 用户名='" + label2.Text.Trim() + "' and 姓名='" + sc.Trim() + "'";
SqlDataReader sdr = cmd.ExecuteReader();
string[] zb = new string[20];
Form3 t = new Form3(label2.Text, bh);
while (sdr.Read())
{
t.textBox3.Text = sdr["工作单位"].ToString();
t.textBox2.Text = sdr["联系电话"].ToString();
t.textBox5.Text = sdr["电子邮箱"].ToString();
t.textBox4.Text = sdr["家庭住址"].ToString();
bh = Convert.ToInt32(sdr["编号"]);
imagebytes = (byte[])sdr["照片"];
}

//MessageBox.Show(imagebytes.Length.ToString());

t.textBox1.Text = sc;
MemoryStream ms = new MemoryStream(imagebytes);
Image image = Image.FromStream(ms, true);
t.pictureBox1.Image= image;

                        剩下的代码就不贴了   提示  Image image = Image.FromStream(ms, true); 参数无效