数据库如何插入byte[]

[deyter]

TestTable: ID, UserName, UserPhoto
直接用：string sql=" Insert into TestTable(UserName,UserPhoto) values ('Hello', PhotoData) ";
其中：PhotoData是byte[]类型。

中断看下，PhotoData的值为Insert into TestTable(UserName,UserPhoto) values ('Hello', System.Byte[]);

这个问题如何解决
谢谢

[xiaotiange]

把photodata转换成 字符串

[garfieldzf]

参考
http://hi.baidu.com/keepzeal/blog/item/ec16794306f7ae1572f05d22.html

[symbol_bc]

SqlConnection cn = new SqlConnection(strCn); 
                SqlCommand cmd = new SqlCommand("INSERT INTO BLOBTest (BLOBData) VALUES (@BLOBData)", cn); 
                MemoryStream ms  = new MemoryStream(); 
                pictureBox1.Image.Save(ms,ImageFormat.Jpeg); 
                Byte[] bytBLOBData = new Byte[ms.Length]; 
                ms.Position = 0; 
ms.Read(bytBLOBData, 0, Convert.ToInt32(ms.Length)); 
                SqlParameter prm = new SqlParameter("@BLOBData", SqlDbType.VarBinary, bytBLOBData.Length, ParameterDirection.Input, false,      0, 0,null, DataRowVersion.Current, bytBLOBData); 
                cmd.Parameters.Add(prm); 
                cn.Open(); 
                cmd.ExecuteNonQuery(); 
                cn.Close();

[flyerwing]

参数化执行语句就好了!

[让爱延续]

[Quote=引用 3 楼 symbol_bc 的回复:]
C# code

SqlConnection cn = new SqlConnection(strCn);
SqlCommand cmd = new SqlCommand("INSERT INTO BLOBTest (BLOBData) VALUES (@BLOBData)", cn);
MemoryStream ms ……
[/Quote]
[Quote=引用 4 楼 flyerwing 的回复:]
参数化执行语句就好了!
[/Quote]

[mywatermelon]

SQL的话……数据库的数据类型选择varbinary(MAX)……希望能够帮到楼主……

[-小蕾-]

把参数PhotoData类型转换一下。当作参数传进去。

[wuyq11]

FileStream fs = new FileStream(@"D:\a.jpg", FileMode.Open,FileAccess.Read);
Byte[] btye2 = new byte[fs.Length];
fs.Read(btye2 , 0, Convert.ToInt32(fs.Length));
fs.Close();
using (SqlConnection conn = new SqlConnection(sqlconnstr))
{
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "insert into Photo(imgfile) values(@imgfile)";
SqlParameter par = new SqlParameter("@imgfile", SqlDbType.Image);
par.Value = bt;
cmd.Parameters.Add(par);
int t=(int)(cmd.ExecuteNonQuery());
conn.Close();
}

[jcrensheng]

public void imgToDB(string sql)
{ //参数sql中要求保存的imge变量名称为@images
//调用方法如：imgToDB("update TestTable set UserPhoto=@images where ID='" + temp + "'");
FileStream fs = File.OpenRead(t_photo.Text);
byte[] imageb = new byte[fs.Length];
fs.Read(imageb, 0, imageb.Length);
fs.Close();
SqlCommand com3 = new SqlCommand (sql,con);
com3.Parameters.Add("@images", SqlDbType.Image).Value = imageb;
if (com3.Connection.State == ConnectionState.Closed)
com3.Connection.Open();
try
{
com3.ExecuteNonQuery();
}
catch
{ }
finally
{ com3.Connection.Close(); }
}

[qiuqingpo]

不错.收藏

[deyter]

谢谢各位了啊