插入数据库
privatebyte[] byData(string strdata) { MemoryStream ms = new MemoryStream(); BinaryFormatter bformatter = newBinaryFormatter(); bformatter.Serialize(ms, strdata); var byteArr= ms.ToArray(); return byteArr; } new MySqlParameter("@Re_Rules",MySqlDbType.LongBlob), parameter[2].Value = Re_Rules;
显示数据
if (dt.Rows[0]["Re_Rules"] != null && dt.Rows[0]["Re_Rules"].ToString() != "") { MemoryStream ms = new MemoryStream(); BinaryFormatter bformatter = new BinaryFormatter(); var padata = (byte[])dt.Rows[0]["Re_Rules"]; ms = new MemoryStream(padata); ViewBag.Re_Rules = (string)bformatter.Deserialize(ms); }