Question

富文本控件怎么把数据存放到数据库中

Answer 1

//读取文件到Byte[]public static byte[] GetByteFromFile(string fileName){
FileStream fsBLOBFile = new FileStream(fileName, FileMode.Open, FileAccess.Read);
Byte[] bytBLOBData = new Byte[fsBLOBFile.Length];
fsBLOBFile.Read(bytBLOBData, 0, bytBLOBData.Length);
fsBLOBFile.Close(); return bytBLOBData;}
/// <summary> /// 增加一条数据 /// </summary>
public int Add(Byte[] testByte){
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into TestTable(");
strSql.Append("rtfFile)");
strSql.Append(" values (");
strSql.Append("@rtfFile)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {new SqlParameter("@rtfFile", SqlDbType.Image,16)};
parameters[0].Value = testByte;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null){
return 1;
}else{
return Convert.ToInt32(obj);}
}