asp.net 把word转化成二进制文件存储到数据库

来源:互联网 发布:潍坊发电机组网络销售 编辑:程序博客网 时间:2024/06/05 13:36
 int flieLength = FileUpload1.PostedFile.ContentLength;            Stream fs = FileUpload1.PostedFile.InputStream;            byte[] bytes = new byte[fs.Length];            fs.Read(bytes, 0, flieLength);            using (SqlConnection con = new SqlConnection("Data Source=localhost;database=test;uid=sa;pwd=123"))            {                con.Open();                using (SqlCommand cmd = con.CreateCommand())                {                    cmd.CommandText = "insert into T_files(files) values(@file)";                    SqlParameter spFile = new SqlParameter("@file", SqlDbType.Image);                    spFile.Value = bytes;                    cmd.Parameters.Add(spFile);                    cmd.ExecuteNonQuery();                }            }


原创粉丝点击