请各位高手帮忙看两段程序，C#实现word在sql数据库中的存取

[wwzlgxwhx]

下面两段代码分别是实现向sql数据库中存和取word文件（包含表格）：
//读取word并存入sql数据库
OpenFileDialog openFileDialog1 = new OpenFileDialog();
openFileDialog1.Filter = "doc文件(*.doc)|*.doc|所有文件(*.*)|*.*";
if (openFileDialog1.ShowDialog() == DialogResult.OK)
{
if (openFileDialog1.FileName != "")
{
string mp = openFileDialog1.FileName;
FileStream fs = File.OpenRead(mp); System.IO.BinaryReader br = null;
br = new BinaryReader((Stream)fs);
byte[] b = new byte[fs.Length]; int intLength = (int)fs.Length;
b = br.ReadBytes(intLength);
fs.Close();
string nn = "server=localhost; database=hyz; User ID=sa;trusted_connection=true";
string sql = "insert into test values ('1','" + b + "')";
SqlConnection connect = new SqlConnection(nn);
SqlCommand cmd1 = new SqlCommand(sql);
cmd1.Connection = connect; //数据库连接
cmd1.Parameters.Add("t1", SqlDbType.Image).Value = b;
cmd1.Connection.Open();
cmd1.ExecuteNonQuery(); //入库
cmd1.Connection.Close();
cmd1.Dispose();
connect.Dispose();
connect.Close();






//从数据库中取出，并保存为word文档
string str = "server=localhost;database=hyz;uid=sa;pwd=";
SqlConnection connection = new SqlConnection(str);
SqlCommand cmd = new SqlCommand(sqlstr);
cmd.Connection = connection;
connection.Open();
int intLenth = 0;
MemoryStream stream = new MemoryStream(b, true);
stream.Write(b, 0, intLenth);
FileStream fsw = new FileStream(@"e:\test.doc",FileMode.OpenOrCreate,FileAccess.Write);
fsw.Write(b,0,b.Length)


为什么我取出来的结果是文件的路径名称，而不是word中包含的内容？？？如何修改？？先谢谢了

[eyu660]

14楼正解。

[birdlonger]

崇拜追踪各种高手.顺便帮顶!

[wwzlgxwhx]

[Quote=引用 10 楼 GabrielCNMao 的回复:]
doc文檔它有自己的組件去讀取.doc文檔.
[/Quote]

能说得再详细点吗？在C#中如何使用它的组件？谢谢

[wwzlgxwhx]

[Quote=引用 14 楼 xjh_net 的回复:]
1.写到数据库
string sql = "insert into test values ('1',:t1)";// 在SQL中 :t1 表示一个Parameter，名字叫t1
SqlConnection connect = new SqlConnection(nn);
SqlCommand cmd1 = new SqlCommand(sql);
cmd1.Connection = connect; //数据库连接
cmd1.Parameters.Add("t1", SqlDbType.I…
[/Quote]

提示不认:t1,需要添加引用吗？

[xiangweixing]

[Quote=引用 6 楼 wuyq11 的回复:]
Word.ApplicationClass wordApp=new ApplicationClass();

object file=path;

object nullobj=System.Reflection.Missing.Value;

Word.Document doc = wordApp.Documents.Open(

ref file, ref nullobj, ref nullobj,

ref nullobj, ref nullobj, ref nullobj,

ref nullobj, ref nullobj, ref nullobj,

ref nullobj, ref nullobj,…
[/Quote]



顶一下,这个才是真正的读取word文档

[xjh_net]

string sql = "insert into test values ('1',:t1)";// 在SQL中 :t1 表示一个Parameter，名字叫t1
SqlServer 的SQL语句的参数是这样的：@t1,Oracle 是:t1
所以 SqlServer 中 string sql = "insert into test values ('1',@t1)";// 在SQL中 :t1 表示一个Parameter，名字叫t1

[wwzlgxwhx]

从数据库中读出word后，如何显示？也就是说byte 如何转化为可显示的内容，包括word表格

[wwzlgxwhx]

[Quote=引用 14 楼 xjh_net 的回复:]
1.写到数据库
string sql = "insert into test values ('1',:t1)";// 在SQL中 :t1 表示一个Parameter，名字叫t1
SqlConnection connect = new SqlConnection(nn);
SqlCommand cmd1 = new SqlCommand(sql);
cmd1.Connection = connect; //数据库连接
cmd1.Parameters.Add("t1", SqlDbType.I…
[/Quote]
好像并没有将word内容保存到数据库中！

[wwzlgxwhx]

高手们，加油啊！！！

[lvfeng19806001]

6楼！谢了

[net5i]

搂主试试下面代码：

//读取word并存入sql数据库 
OpenFileDialog openFileDialog1 = new OpenFileDialog();
openFileDialog1.Filter = "doc文件(*.doc)|*.doc|所有文件(*.*)|*.*";
if (openFileDialog1.ShowDialog() == DialogResult.OK)
{
    if (openFileDialog1.FileName != "")
    {
        //存入代码
        FileStream fs = new FileStream(openFileDialog1.FileName, FileMode.Open);
        byte[] bytes = new byte[fs.Length];
        fs.Read(bytes, 0, (int)fs.Length);
        fs.Close();

        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = "server=localhost; database=hyz; User ID=sa;trusted_connection=true";
        conn.Open();
        SqlCommand com = new SqlCommand();
        com.Connection = conn;
        com.CommandText = "insert into test values('1', @t1)";

        SqlParameter param = new SqlParameter();
        param.ParameterName = "t1";
        param.SqlDbType = SqlDbType.Binary;
        param.Value = bytes;
        com.Parameters.Add(param);

        com.ExecuteNonQuery();
        conn.Close();
        

        //读取代码
        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = "server=localhost; database=hyz; User ID=sa;trusted_connection=true";
        conn.Open();
        SqlCommand com = new SqlCommand();
        com.Connection = conn;
        com.CommandText = "select doc from test where id='1'";

        object obj = com.ExecuteScalar();

        conn.Close();

        byte[] bytes = obj as byte[];

        string szFileName = Application.StartupPath + "\\test.doc";
        if (!File.Exists(szFileName))
            File.Create(szFileName);
        FileStream fs = new FileStream(szFileName, FileAccess.Write);
        fs.Write(bytes, 0, bytes.Length);
        fs.Close();
        fs.Dispose();
    }
}

注意：上面是假设搂主test表里面有两个字段，分别是id和doc，一个varchar类型的，一个是binary类型的

[net5i]

不好意思，需要把倒数第4行的代码：
FileStream fs = new FileStream(szFileName, FileAccess.Write);
改成：
fs = new FileStream(szFileName, FileAccess.Write);

[net5i]

呵呵，我自己的测试是：写入和读取是分开在两个地方写的，所以上面对象都声明了两次

再改成适合搂主的要求的吧，见下面：

//读取word并存入sql数据库
OpenFileDialog openFileDialog1 = new OpenFileDialog();
openFileDialog1.Filter = "doc文件(*.doc)|*.doc|所有文件(*.*)|*.*";
if (openFileDialog1.ShowDialog() == DialogResult.OK)
{
if (openFileDialog1.FileName != "")
{
//存入代码
FileStream fs = new FileStream(openFileDialog1.FileName, FileMode.Open);
byte[] bytes = new byte[fs.Length];
fs.Read(bytes, 0, (int)fs.Length);
fs.Close();

SqlConnection conn = new SqlConnection();
conn.ConnectionString = "server=localhost; database=hyz; User ID=sa;trusted_connection=true";
conn.Open();
SqlCommand com = new SqlCommand();
com.Connection = conn;
com.CommandText = "insert into test values('1', @t1)";

SqlParameter param = new SqlParameter();
param.ParameterName = "t1";
param.SqlDbType = SqlDbType.Binary;
param.Value = bytes;
com.Parameters.Add(param);

com.ExecuteNonQuery();
conn.Close();


//读取代码
conn.Open();
com.CommandText = "select doc from test where id='1'";

object obj = com.ExecuteScalar();

conn.Close();

bytes = obj as byte[];

string szFileName = Application.StartupPath + "\\test.doc";
if (!File.Exists(szFileName))
File.Create(szFileName);
fs = new FileStream(szFileName, FileMode.OpenOrCreate);
fs.Write(bytes, 0, bytes.Length);
fs.Close();
fs.Dispose();
}
}

[net5i]

注意：上面是假设搂主test表里面有两个字段，分别是id和doc，一个varchar类型的，一个是binary类型的

[mochencui]

顶

[gswwn]

同意net5i的。顶

[wwzlgxwhx]

问题解决，散分！！！！！！

[wwzlgxwhx]

多谢net5i，也谢谢大家的支持！帮顶的也有分！！！！！！！！！！！继续努力！！！！！！！

[gswwn]

怎么没人回答阿？高手们不要这样啊！

[gswwn]

请问各位高手：为什么word文档（包含表格）实现在数据库中存取后在richtextbox中显示的结果不一样？我在word中应该是第一列前三行的单元格合并，并在里面以回车换行的形式显示文字，显示结果是第一列前三行的单元格并没有合并，而且文字在第一行中显示，将第二列的内容向后推了。多谢