110,566
社区成员
发帖
与我相关
我的任务
分享
FileStream fs = new FileStream(this.openFileDialog1.FileName, FileMode.Open);
byte[] value = new byte[fs.Length];
fs.Read(value, 0, value.Length);
sqlcom = new SqlCommand();
sqlcom.Connection = SqlCon();
sqlcom.Connection.Open();
sqlcom.CommandText = "insert into 导出数据到Word文档(WORD) values(@word)";
sqlcom.Parameters.Add("@word",SqlDbType.Image);
sqlcom.Parameters[0].Value = value;
sqlcom.ExecuteNonQuery();
sqlcom.Connection.Close();
MessageBox.Show("保存成功", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
byte[] by = null;
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(sqlcon,con);
da.Fill(ds);
by = (byte[])ds.Tables[0].Rows[0][0];
Console.WriteLine(by.Count().ToString());
Console.WriteLine(Encoding.UTF8.GetString(by,0,by.Length));
Console.WriteLine(Encoding.GetEncoding("GDK").GetString(by,0,by.Length));