文件流將數據讀取到數據庫

1.如何將文件讀取到數據庫保存起來,參考鏈接http://bbs.csdn.net/topics/280014809

寫入 string fileName = Server.MapPath("a.jpg"); FileInfo fi = new FileInfo(fileName); FileStream fs = fi.OpenRead(); byte[] bytes = new byte[fs.Length]; fs.Read(bytes, 0, Convert.ToInt32(fs.Length)); NpgsqlConnection con = new NpgsqlConnection(constr); con.Open(); NpgsqlCommand cm = new NpgsqlCommand(); cm.Connection = con; cm.CommandType = CommandType.Text; cm.CommandText = "insert into test (filename) values(@file)"; NpgsqlParameter spFile = new NpgsqlParameter("@file", NpgsqlTypes.NpgsqlDbType.Bytea); spFile.Value = bytes;//SqlDbType.Image cm.Parameters.Add(spFile); cm.ExecuteNonQuery();

讀取

NpgsqlConnection con = new NpgsqlConnection(constr); con.Open(); string sql = "select filename from test where id=20 "; NpgsqlCommand cm = new NpgsqlCommand(sql, con); Byte[] bytes = (Byte)cm.ExecuteScalar(); System.IO.StreamWriter sw = System.IO.File.CreateText("d://aaa.jpg");

sw.Write(cm.ExecuteScalar()); sw.Close(); con.Close();