如何通过MS Word将数据存储在数据库中 [英] how to store data in database through MS Word

问题描述

我想将MS Word中的数据上传到数据库表(Sqlserver 2008).我该怎么做?

I want to upload data from MS Word in to the database table(Sqlserver 2008).How can i do this?

推荐答案

您需要查看字词互操作 [

You need to look at Word interop[^] to acquire the data - can''t be more specific since I have no idea of you document layout.

Then store it to the database:

using (SqlConnection con = new SqlConnection(strConnect))
    {
    con.Open();
    using (SqlCommand com = new SqlCommand("INSERT INTO myTable (myColumn1, myColumn2) VALUES (@C1, @C2)", con))
        {
        com.Parameters.AddWithValue("@C1", myValueForColumn1);
        com.Parameters.AddWithValue("@C2", myValueForColumn2);
        com.ExecuteNonQuery();
        }
    }

尝试
http://chiragrdarji.wordpress.com/2007 /08/31/storing-and-retrieving-docpdfxls-files-in-sql-server/ [

Try
http://chiragrdarji.wordpress.com/2007/08/31/storing-and-retrieving-docpdfxls-files-in-sql-server/[^]

这篇关于如何通过MS Word将数据存储在数据库中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！