資源簡介
c#源碼,訪問access數據庫,查詢表內數據。查詢語句返回datatable,在dataGridView上面顯示
代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Linq;
using?System.Text;
using?System.Windows.Forms;
using?System.Data.OleDb;
namespace?SelectAccess
{
????public?partial?class?Form1?:?Form
????{
????????OleDbConnection?Connection;
????????public?Form1()
????????{
????????????InitializeComponent();
????????}
????????private?void?Form1_Load(object?sender?EventArgs?e)
????????{
????????}
????????private?void?button1_Click(object?sender?EventArgs?e)
????????{
????????????DataTable?dt?=?ReturnDataSet(“select?*?from?測試“).Tables[0];
????????????dataGridView1.DataSource?=?dt;
????????}
????????public?DataSet?ReturnDataSet(string?strSQL)
????????{
????????????string?connStr?=?@“P
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????1282048??2018-12-05?16:12??SelectAccess\SelectAccess\bin\Debug\BZH.MDB
?????文件???????9216??2018-12-05?16:12??SelectAccess\SelectAccess\bin\Debug\SelectAccess.exe
?????文件??????24064??2018-12-05?16:12??SelectAccess\SelectAccess\bin\Debug\SelectAccess.pdb
?????文件??????14848??2018-12-05?16:12??SelectAccess\SelectAccess\bin\Debug\SelectAccess.vshost.exe
?????文件????????490??2009-06-11?05:14??SelectAccess\SelectAccess\bin\Debug\SelectAccess.vshost.exe.manifest
?????文件???????1502??2018-12-05?16:12??SelectAccess\SelectAccess\Form1.cs
?????文件???????2985??2018-12-05?16:10??SelectAccess\SelectAccess\Form1.Designer.cs
?????文件???????5814??2018-12-05?16:10??SelectAccess\SelectAccess\Form1.resx
?????文件????????655??2018-12-05?16:12??SelectAccess\SelectAccess\obj\Debug\SelectAccess.csproj.FileListAbsolute.txt
?????文件????????847??2018-12-05?16:10??SelectAccess\SelectAccess\obj\Debug\SelectAccess.csproj.GenerateResource.Cache
?????文件???????9216??2018-12-05?16:12??SelectAccess\SelectAccess\obj\Debug\SelectAccess.exe
?????文件????????180??2018-12-05?16:11??SelectAccess\SelectAccess\obj\Debug\SelectAccess.Form1.resources
?????文件??????24064??2018-12-05?16:12??SelectAccess\SelectAccess\obj\Debug\SelectAccess.pdb
?????文件????????180??2018-12-05?16:11??SelectAccess\SelectAccess\obj\Debug\SelectAccess.Properties.Resources.resources
?????文件????????493??2018-12-05?16:02??SelectAccess\SelectAccess\Program.cs
?????文件???????1374??2018-12-05?16:02??SelectAccess\SelectAccess\Properties\AssemblyInfo.cs
?????文件???????2874??2018-12-05?16:02??SelectAccess\SelectAccess\Properties\Resources.Designer.cs
?????文件???????5612??2018-12-05?16:02??SelectAccess\SelectAccess\Properties\Resources.resx
?????文件???????1097??2018-12-05?16:02??SelectAccess\SelectAccess\Properties\Settings.Designer.cs
?????文件????????249??2018-12-05?16:02??SelectAccess\SelectAccess\Properties\Settings.settings
?????文件???????3777??2018-12-05?16:11??SelectAccess\SelectAccess\SelectAccess.csproj
?????文件????????926??2018-12-05?16:02??SelectAccess\SelectAccess.sln
????..A..H.?????15872??2018-12-05?16:12??SelectAccess\SelectAccess.suo
?????目錄??????????0??2018-12-05?16:02??SelectAccess\SelectAccess\obj\Debug\TempPE
?????目錄??????????0??2018-12-05?16:13??SelectAccess\SelectAccess\bin\Debug
?????目錄??????????0??2018-12-05?16:13??SelectAccess\SelectAccess\obj\Debug
?????目錄??????????0??2018-12-05?16:13??SelectAccess\SelectAccess\bin
?????目錄??????????0??2018-12-05?16:13??SelectAccess\SelectAccess\obj
?????目錄??????????0??2018-12-05?16:13??SelectAccess\SelectAccess\Properties
?????目錄??????????0??2018-12-05?16:13??SelectAccess\SelectAccess
............此處省略4個文件信息
評論
共有 條評論