社群
學習
工具庫
AI工具
休閒
搜尋
繁体中文
目錄
说明：
首頁 資料庫 mysql教程 [Access] C#通过COM组件访问Access文件

[Access] C#通过COM组件访问Access文件

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Jun 07, 2016 pm 03:37 PM
access com d 文件 組件 訪問 說明 透過 採用

说明： 1，采用dynamic调用COM组件，适用于.NET 4.0以上支持dynamic版本的才可以； 2，执行速度不敢恭维，只是因为要用于Silverlight OOB模式中才研究一二； 3，测试环境 .net 4.5 + Silverlight 5.0 + Visual Studio 2013 4，见如下helper类（需引用 using

说明：

1，采用dynamic调用COM组件，适用于.NET 4.0以上支持dynamic版本的才可以；

2，执行速度不敢恭维，只是因为要用于Silverlight OOB模式中才研究一二；

3，测试环境.net 4.5 + Silverlight 5.0 + Visual Studio 2013

4，见如下helper类（需引用using System.Runtime.InteropServices.Automation;）：

[Access] C#通过COM组件访问Access文件[Access] C#通过COM组件访问Access文件 

<span>  1</span> <span>public</span> <span>class</span><span> SLAccessHelper
</span><span>  2</span> <span>{
</span><span>  3</span>     <span>private</span> dynamic m_AccessApp;<span>//</span><span> Access.Application</span>
<span>  4</span>     <span>private</span> dynamic m_Database;<span>//</span><span> Database</span>
<span>  5</span>     <span>private</span><span> dynamic m_Recordset;
</span><span>  6</span> 
<span>  7</span>     <span>///</span> <span><summary></summary></span>
<span>  8</span>     <span>///</span><span> 构造函数
</span><span>  9</span>     <span>///</span> <span></span>
<span> 10</span>     <span>///</span> <span><param name="visible"></span><span>Access是否可见</span><span></span>
<span> 11</span>     <span>public</span> SLAccessHelper(<span>bool</span><span> visible)
</span><span> 12</span> <span>    {
</span><span> 13</span>         m_AccessApp = AutomationFactory.CreateObject(<span>"</span><span>Access.Application</span><span>"</span><span>);
</span><span> 14</span>         m_AccessApp.Visible =<span> visible;
</span><span> 15</span> <span>    }
</span><span> 16</span> 
<span> 17</span>     <span>///</span> <span><summary></summary></span>
<span> 18</span>     <span>///</span><span> 打开数据库
</span><span> 19</span>     <span>///</span> <span></span>
<span> 20</span>     <span>///</span> <span><param name="filePath"></span><span>Access数据库文件路径</span><span></span>
<span> 21</span>     <span>///</span> <span><param name="exclusive"></span><span>是否共享</span><span></span>
<span> 22</span>     <span>///</span> <span><param name="bstrPassword"></span><span>密码</span><span></span>
<span> 23</span>     <span>public</span> <span>void</span> OpenDb(<span>string</span> filePath, <span>bool</span> exclusive = <span>false</span>, <span>string</span> bstrPassword = <span>""</span><span>)
</span><span> 24</span> <span>    {
</span><span> 25</span> <span>        m_AccessApp.OpenCurrentDatabase(filePath, exclusive, bstrPassword);
</span><span> 26</span>         m_Database =<span> m_AccessApp.CurrentDb();
</span><span> 27</span> <span>    }
</span><span> 28</span> 
<span> 29</span>     <span>///</span> <span><summary></summary></span>
<span> 30</span>     <span>///</span><span> 获取当前数据库中所有表名称集合
</span><span> 31</span>     <span>///</span> <span></span>
<span> 32</span>     <span>///</span> <span><returns></returns></span><span>所有表名称集合</span><span></span>
<span> 33</span>     <span>public</span> Liststring><span> GetTableNames()
</span><span> 34</span> <span>    {
</span><span> 35</span>         Liststring> tableNames = <span>new</span> Liststring><span>();
</span><span> 36</span>         dynamic tableDefs =<span> m_Database.TableDefs;
</span><span> 37</span>         <span>foreach</span> (dynamic tableDef <span>in</span><span> tableDefs)
</span><span> 38</span> <span>        {
</span><span> 39</span> <span>            tableNames.Add(tableDef.Name);
</span><span> 40</span> <span>        }
</span><span> 41</span> 
<span> 42</span>         <span>return</span><span> tableNames;
</span><span> 43</span> <span>    }
</span><span> 44</span> 
<span> 45</span>     <span>///</span> <span><summary></summary></span>
<span> 46</span>     <span>///</span><span> 加载表数据
</span><span> 47</span>     <span>///</span> <span></span>
<span> 48</span>     <span>///</span> <span><param name="tableName"></span><span>表名称</span><span></span>
<span> 49</span>     <span>///</span> <span><returns></returns></span><span>表数据</span><span></span>
<span> 50</span>     <span>public</span> List<list>string>> LoadTable(<span>string</span><span> tableName)
</span><span> 51</span> <span>    {
</span><span> 52</span>         dynamic recordSet =<span> m_Database.OpenRecordset(tableName);
</span><span> 53</span>         <span>int</span> fieldsCount =<span> recordSet.Fields.Count;
</span><span> 54</span>         List<list>string>> data = <span>new</span> List<list>string>><span>();
</span><span> 55</span>         <span>if</span> (fieldsCount > <span>0</span><span>)
</span><span> 56</span> <span>        {
</span><span> 57</span>             <span>try</span>
<span> 58</span> <span>            {
</span><span> 59</span>                 Liststring> fieldNames = <span>new</span> Liststring><span>();
</span><span> 60</span>                 <span>for</span> (<span>int</span> i = <span>0</span>; i )
<span> 61</span> <span>                {
</span><span> 62</span> <span>                    fieldNames.Add(recordSet.Fields[i].Name);
</span><span> 63</span> <span>                }
</span><span> 64</span> <span>                data.Add(fieldNames);
</span><span> 65</span>                 <span>if</span> (!<span>recordSet.EOF)
</span><span> 66</span> <span>                {
</span><span> 67</span> <span>                    recordSet.MoveFirst();
</span><span> 68</span>                     <span>while</span> (!<span>recordSet.EOF)
</span><span> 69</span> <span>                    {
</span><span> 70</span>                         <span>object</span>[] dataRow = recordSet.GetRows();<span>//</span><span> 返回一维数组</span>
<span> 71</span>                         Liststring> dataRowStr = <span>new</span> Liststring><span>();
</span><span> 72</span>                         <span>for</span> (<span>int</span> i = <span>0</span>; i )
<span> 73</span> <span>                        {
</span><span> 74</span>                             dataRowStr.Add(dataRow[i] == <span>null</span> ? <span>""</span><span> : dataRow[i].ToString());
</span><span> 75</span> <span>                        }
</span><span> 76</span> <span>                        data.Add(dataRowStr);
</span><span> 77</span> <span>                    }
</span><span> 78</span> <span>                }
</span><span> 79</span> <span>            }
</span><span> 80</span>             <span>catch</span><span> (Exception ex)
</span><span> 81</span> <span>            {
</span><span> 82</span>                 <span>throw</span> <span>new</span><span> Exception(ex.Message);
</span><span> 83</span> <span>            }
</span><span> 84</span>             <span>finally</span>
<span> 85</span> <span>            {
</span><span> 86</span>                 <span>if</span> (recordSet != <span>null</span><span>)
</span><span> 87</span> <span>                {
</span><span> 88</span> <span>                    recordSet.Close();
</span><span> 89</span> <span>                    ((IDisposable)recordSet).Dispose();
</span><span> 90</span>                     recordSet = <span>null</span><span>;
</span><span> 91</span> <span>                }
</span><span> 92</span> <span>            }
</span><span> 93</span> <span>        }
</span><span> 94</span> 
<span> 95</span>         <span>return</span><span> data;
</span><span> 96</span> <span>    }
</span><span> 97</span> 
<span> 98</span>     <span>///</span> <span><summary></summary></span>
<span> 99</span>     <span>///</span><span> 添加新纪录
</span><span>100</span>     <span>///</span> <span></span>
<span>101</span>     <span>///</span> <span><param name="tableName"></span><span>表格名称</span><span></span>
<span>102</span>     <span>///</span> <span><param name="data"></span><span>数据</span><span></span>
<span>103</span>     <span>public</span> <span>void</span> AddNewRecord(<span>string</span> tableName, List<dictionary>string, <span>object</span>>><span> data)
</span><span>104</span> <span>    {
</span><span>105</span>         <span>try</span>
<span>106</span> <span>        {
</span><span>107</span>             m_Recordset = m_Database.OpenRecordset(tableName, <span>1</span>);<span>//</span><span> 1=RecordsetTypeEnum.dbOpenTable</span>
<span>108</span>             <span>int</span> fieldsCount =<span> m_Recordset.Fields.Count;
</span><span>109</span>             Liststring> fieldNames = <span>new</span> Liststring><span>();
</span><span>110</span>             <span>for</span> (<span>int</span> i = <span>0</span>; i )
<span>111</span> <span>            {
</span><span>112</span> <span>                fieldNames.Add(m_Recordset.Fields[i].Name);
</span><span>113</span> <span>            }
</span><span>114</span>             <span>for</span> (<span>int</span> rowIndex = <span>0</span>; rowIndex )
<span>115</span> <span>            {
</span><span>116</span> <span>                m_Recordset.AddNew();
</span><span>117</span>                 <span>foreach</span> (<span>string</span> fieldName <span>in</span><span> fieldNames)
</span><span>118</span> <span>                {
</span><span>119</span>                     m_Recordset.Fields[fieldName].Value =<span> data[rowIndex][fieldName];
</span><span>120</span> <span>                }
</span><span>121</span> <span>                m_Recordset.Update();
</span><span>122</span> <span>            }
</span><span>123</span> <span>        }
</span><span>124</span>         <span>catch</span><span>(Exception ex)
</span><span>125</span> <span>        {
</span><span>126</span>             <span>throw</span> <span>new</span><span> Exception(ex.Message);
</span><span>127</span> <span>        }
</span><span>128</span>         <span>finally</span>
<span>129</span> <span>        {
</span><span>130</span>             <span>if</span> (m_Recordset != <span>null</span><span>)
</span><span>131</span> <span>            {
</span><span>132</span> <span>                m_Recordset.Close();
</span><span>133</span> <span>                ((IDisposable)m_Recordset).Dispose();
</span><span>134</span>                 m_Recordset = <span>null</span><span>;
</span><span>135</span> <span>            }
</span><span>136</span> <span>        }
</span><span>137</span> <span>    }
</span><span>138</span> 
<span>139</span>     <span>///</span> <span><summary></summary></span>
<span>140</span>     <span>///</span><span> 更新表格数据
</span><span>141</span>     <span>///</span> <span></span>
<span>142</span>     <span>///</span> <span><param name="tableName"></span><span>表格名称</span><span></span>
<span>143</span>     <span>///</span> <span><param name="data"></span><span>数据</span><span></span>
<span>144</span>     <span>public</span> <span>void</span> UpdateTable(<span>string</span> tableName, List<dictionary>string, <span>string</span>>><span> data)
</span><span>145</span> <span>    {
</span><span>146</span>         <span>try</span>
<span>147</span> <span>        {
</span><span>148</span>             m_Recordset = m_Database.OpenRecordset(tableName, <span>1</span>);<span>//</span><span> 1=RecordsetTypeEnum.dbOpenTable</span>
<span>149</span> <span>            m_Recordset.MoveFirst();
</span><span>150</span>             <span>for</span> (<span>int</span> rowIndex = <span>0</span>; rowIndex )
<span>151</span> <span>            {
</span><span>152</span> <span>                m_Recordset.Edit();
</span><span>153</span>                 <span>foreach</span> (<span>string</span> fieldName <span>in</span><span> data[rowIndex].Keys)
</span><span>154</span> <span>                {
</span><span>155</span>                     m_Recordset.Fields[fieldName].Value =<span> data[rowIndex][fieldName];
</span><span>156</span> <span>                }
</span><span>157</span> <span>                m_Recordset.Update();
</span><span>158</span> <span>                m_Recordset.MoveNext();
</span><span>159</span> <span>            }
</span><span>160</span> <span>        }
</span><span>161</span>         <span>catch</span><span> (Exception ex)
</span><span>162</span> <span>        {
</span><span>163</span>             <span>throw</span> <span>new</span><span> Exception(ex.Message);
</span><span>164</span> <span>        }
</span><span>165</span>         <span>finally</span>
<span>166</span> <span>        {
</span><span>167</span>             <span>if</span> (m_Recordset != <span>null</span><span>)
</span><span>168</span> <span>            {
</span><span>169</span> <span>                m_Recordset.Close();
</span><span>170</span> <span>                ((IDisposable)m_Recordset).Dispose();
</span><span>171</span>                 m_Recordset = <span>null</span><span>;
</span><span>172</span> <span>            }
</span><span>173</span> <span>        }
</span><span>174</span> <span>    }
</span><span>175</span> 
<span>176</span>     <span>///</span> <span><summary></summary></span>
<span>177</span>     <span>///</span><span> 关闭
</span><span>178</span>     <span>///</span> <span></span>
<span>179</span>     <span>public</span> <span>void</span><span> Close()
</span><span>180</span> <span>    {
</span><span>181</span>         <span>if</span> (m_Database != <span>null</span><span>)
</span><span>182</span> <span>        {
</span><span>183</span> <span>            m_Database.Close();
</span><span>184</span> <span>            ((IDisposable)m_Database).Dispose();
</span><span>185</span>             m_Database = <span>null</span><span>;
</span><span>186</span> <span>        }
</span><span>187</span>         <span>if</span> (m_AccessApp != <span>null</span><span>)
</span><span>188</span> <span>        {
</span><span>189</span> <span>            m_AccessApp.CloseCurrentDatabase();
</span><span>190</span>             <span>//</span><span> m_AccessApp.Quit();</span><span>//</span><span> 导致最后会弹出Access主页面</span>
<span>191</span> <span>            ((IDisposable)m_AccessApp).Dispose();
</span><span>192</span>             m_AccessApp = <span>null</span><span>;
</span><span>193</span> <span>        }
</span><span>194</span> <span>        GC.Collect();
</span><span>195</span> <span>    }
</span><span>196</span> }</dictionary></dictionary></list></list></list>
登入後複製
View Code

 

通过dynamic构建的COM对象，在使用完成后都要手动关闭销毁，比如代码中的m_AccessApp, m_Database, m_Recordset三个对象，否则只是将m_AccessApp关闭清空释放掉，Access进程还是无法关闭，在程序关闭之前，始终都会有一个空白的无法关闭的Access界面；

在循环中处理dynamic和C#类型转换会降低程序执行效率，就比如像GetTableNames方法中循环遍历表名，都要花两三秒时间，所以尽量像object[] dataRow = recordSet.GetRows();直接获取其中的所有数据，然后再遍历处理，会极大提高执行效率；

要修改Access中的数据时，一定要先m_Recordset.Edit();才会允许你编辑其中的内容；

本網站聲明
本文內容由網友自願投稿，版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容，請聯絡admin@php.cn

熱AI工具

Undresser.AI Undress

Undresser.AI Undress

人工智慧驅動的應用程序，用於創建逼真的裸體照片

AI Clothes Remover

AI Clothes Remover

用於從照片中去除衣服的線上人工智慧工具。

Undress AI Tool

Undress AI Tool

免費脫衣圖片

Clothoff.io

Clothoff.io

AI脫衣器

AI Hentai Generator

AI Hentai Generator

免費產生 AI 無盡。

顯示更多

熱門文章

R.E.P.O.能量晶體解釋及其做什麼（黃色晶體）
1 個月前 By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O.最佳圖形設置
1 個月前 By 尊渡假赌尊渡假赌尊渡假赌
刺客信條陰影：貝殼謎語解決方案
3 週前 By DDD
Windows 11 KB5054979中的新功能以及如何解決更新問題
2 週前 By DDD
威爾R.E.P.O.有交叉遊戲嗎？
1 個月前 By 尊渡假赌尊渡假赌尊渡假赌
顯示更多

熱工具

記事本++7.3.1

記事本++7.3.1

好用且免費的程式碼編輯器

SublimeText3漢化版

SublimeText3漢化版

中文版，非常好用

禪工作室 13.0.1

禪工作室 13.0.1

強大的PHP整合開發環境

Dreamweaver CS6

Dreamweaver CS6

視覺化網頁開發工具

SublimeText3 Mac版

SublimeText3 Mac版

神級程式碼編輯軟體(SublimeText3)

顯示更多

熱門話題

gmail信箱登陸入口在哪裡
7559
15
CakePHP 教程
1384
52
steam的賬戶名稱是什麼格式
83
11
win11激活密鑰永久
59
19
NYT連接提示和答案
28
96
顯示更多
Related knowledge
deepseek怎麼轉換pdf deepseek怎麼轉換pdf Feb 19, 2025 pm 05:24 PM

DeepSeek 無法直接將文件轉換為 PDF。根據文件類型，可以使用不同方法：常見文檔（Word、Excel、PowerPoint）：使用微軟 Office、LibreOffice 等軟件導出為 PDF。圖片：使用圖片查看器或圖像處理軟件保存為 PDF。網頁：使用瀏覽器“打印成 PDF”功能或專用的網頁轉 PDF 工具。不常見格式：找到合適的轉換器，將其轉換為 PDF。選擇合適的工具並根據實際情況制定方案至關重要。

oracle怎麼讀取dbf文件 oracle怎麼讀取dbf文件 May 10, 2024 am 01:27 AM

Oracle 可以透過以下步驟讀取 dbf 檔案：建立外部表，引用 dbf 檔案；查詢外部表，檢索資料；將資料匯入 Oracle 表。

如何在Node.js環境中解決第三方接口返回403的問題？ 如何在Node.js環境中解決第三方接口返回403的問題？ Mar 31, 2025 pm 11:27 PM

在Node.js環境中解決第三方接口返回403的問題當我們在使用Node.js調用第三方接口時，有時會遇到接口返回403錯誤�...

Laravel Redis連接共享：為何select方法會影響其他連接？ Laravel Redis連接共享：為何select方法會影響其他連接？ Apr 01, 2025 am 07:45 AM

Laravel框架中Redis連接的共享與select方法的影響在使用Laravel框架和Redis時，開發者可能會遇到一個問題：通過配置...

c#多線程的好處有哪些 c#多線程的好處有哪些 Apr 03, 2025 pm 02:51 PM

多線程的好處在於能提升性能和資源利用率，尤其適用於處理大量數據或執行耗時操作。它允許同時執行多個任務，提高效率。然而，線程過多會導致性能下降，因此需要根據 CPU 核心數和任務特性謹慎選擇線程數。另外，多線程編程涉及死鎖和競態條件等挑戰，需要使用同步機制解決，需要具備紮實的並發編程知識，權衡利弊並謹慎使用。

如何在 Golang 中並發讀取和寫入檔案？ 如何在 Golang 中並發讀取和寫入檔案？ Jun 05, 2024 pm 06:12 PM

並發讀取檔案：建立goroutine並發讀取資料區塊，使用管道通訊協調；並發寫入檔案：使用goroutine寫入數據，用互斥鎖保護寫入操作。

在Node環境中如何避免第三方接口返回403錯誤？ 在Node環境中如何避免第三方接口返回403錯誤？ Apr 01, 2025 pm 02:03 PM

Node環境下如何避免第三方接口返回403錯誤在使用Node.js調用第三方網站接口時，有時會遇到返回403錯誤的問題。 �...

無法以 root 身份登錄 mysql 無法以 root 身份登錄 mysql Apr 08, 2025 pm 04:54 PM

無法以 root 身份登錄 MySQL 的原因主要在於權限問題、配置文件錯誤、密碼不符、socket 文件問題或防火牆攔截。解決方法包括：檢查配置文件中 bind-address 參數是否正確配置。查看 root 用戶權限是否被修改或刪除，並進行重置。驗證密碼是否準確無誤，包括大小寫和特殊字符。檢查 socket 文件權限設置和路徑。檢查防火牆是否阻止了 MySQL 服務器的連接。

See all articles