现在从oracle中取得一个图片信息,是BLOB字段类型,取到之后我想把他放到sql server数据库中对应的字段中,是Image字段类型,插入语句的格式是什么样??如: string dataPic = dt.Rows[i][2].ToString();注:dt.Rows[i][2].ToString();取到的是二进制,此应转换"insert into tb_Common_Picture(" +
"[ID], " +
"[CONTENT]," +
"[DESCRIPTION] " +
") VALUES (" +
"'" + id + "' " +
",'" + investigation_id + "' " +
",:DATAPIC " +
",'" + description + "' )";
SqlCommand cmd = new SqlCommand(sql, ss.conn);
SqlParameter cardpic = new SqlParameter(":DATAPIC ", SqlDbType.Image);
cardpic.Direction = ParameterDirection.Input;
cardpic.Value = dataPic;
cmd.Parameters.Add(cardpic);
cmd.ExecuteNonQuery();这样的格式好象不对,红色字体为要插入的图片字段,请大狭指教??多谢
"[ID], " +
"[CONTENT]," +
"[DESCRIPTION] " +
") VALUES (" +
"'" + id + "' " +
",'" + investigation_id + "' " +
",:DATAPIC " +
",'" + description + "' )";
SqlCommand cmd = new SqlCommand(sql, ss.conn);
SqlParameter cardpic = new SqlParameter(":DATAPIC ", SqlDbType.Image);
cardpic.Direction = ParameterDirection.Input;
cardpic.Value = dataPic;
cmd.Parameters.Add(cardpic);
cmd.ExecuteNonQuery();这样的格式好象不对,红色字体为要插入的图片字段,请大狭指教??多谢
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货