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;
//download?by?http://down.liehuo.net
using?System.Data.OleDb;

namespace?Case05_4
{
????public?partial?class?Form1?:?Form
????{
????????public?Form1（）
????????{
????????????InitializeComponent（）;
????????}

????????OleDbConnection?mycon;
????????string?bookname;

????????public?void?getScoure（string?str_name）
????????{
????????????string?mysql?=?“select?*?from?mytable?where?書名?=?‘“?+?bookname?+?“‘“;??????//Sql查詢語句
????????????OleDbCommand?mycom?=?new?OleDbCommand（mysql?mycon）;?????????????????????//定義OleDbCommand對象實例并連接數據庫
????????????OleDbDataReader?myread?=?mycom.ExecuteReader（）;?????????????????????????//定義OleDbDataReader對象實例
????????????while?（myread.Read（））
????????????{
????????????????this.textBox1.Text?=?myread[1].ToString（）;???//把數據庫表中的記錄顯示在相應的文本框中
????????????????this.textBox2.Text?=?myread[2].ToString（）;
????????????????this.textBox3.Text?=?myread[3].ToString（）;
????????????????this.textBox4.Text?=?myread[4].ToString（）;
????????????????this.textBox5.Text?=?myread[5].ToString（）;
????????????}
????????????myread.Close（）;
????????????myread.Dispose（）;
????????}

????????private?void?Form1_Load（object?sender?EventArgs?e）
????????{
????????????string?mypath?=?Application.StartupPath?+?“\\mydata.accdb“;???//連接數據庫的路徑及數據庫名
????????????string?constr?=?“Provider?=?Microsoft.ACE.OLEDB.12.0;?Data?Source?=“?+?mypath;??//生成連接數據庫字符串
????????????mycon?=?new?OleDbConnection（constr）;???//定義OleDbConnection對象實例并連接數據庫
????????????mycon.Open（）;
????????????string?mysql?=?“select?*?from?mytable“;????????????????//Sql查詢語句
????????????OleDbCommand?mycom?=?new?OleDbCommand（mysql?mycon）;???//定義OleDbCommand對象實例并連接數據庫
????????????OleDbDataReader?myread?=?mycom.ExecuteReader（）;???????//定義OleDbDataReader對象實例
????????????listView1.FullRowSelect?=?true;
????????????while?（myread.Read（））
????????????{
????????????????ListViewItem?mylv?=?new?ListViewItem（myread[1].ToString（））;??
????????????????listView1.Items.Add（mylv）;???????????????//把數據庫表中“出版社”字段信息添加到ListView控件中
????????????}
????????????myread.Close（）;
????????????myread.Dispose（）;
????????}

????????private?void?listView1_Click（object?sender?EventArgs?e）
????????{
????????????bookname?=?listView1.SelectedItems[0].SubItems[0].Text;
????????????if?（bookname?!=?null）
????????????{
????????????????getScoure（bookname）;
????????????}
????????}
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件??????11776??2021-02-06?14:38??C#學習教程\Case05_4\bin\Debug\Case05_4.exe

?????文件??????24064??2021-02-06?14:38??C#學習教程\Case05_4\bin\Debug\Case05_4.pdb

?????文件?????458752??2021-02-06?14:44??C#學習教程\Case05_4\bin\Debug\mydata.accdb

?????文件???????3955??2021-02-06?14:38??C#學習教程\Case05_4\Case05_4.csproj

?????文件???????2821??2010-09-14?08:22??C#學習教程\Case05_4\Form1.cs

?????文件???????9054??2010-09-14?08:22??C#學習教程\Case05_4\Form1.Designer.cs

?????文件???????5814??2008-06-10?18:56??C#學習教程\Case05_4\Form1.resx

?????文件?????????42??2021-02-06?14:38??C#學習教程\Case05_4\obj\Debug\Case05_4.csproj.CoreCompileInputs.cache

?????文件????????955??2021-02-06?14:38??C#學習教程\Case05_4\obj\Debug\Case05_4.csproj.FileListAbsolute.txt

?????文件????????847??2021-02-06?14:38??C#學習教程\Case05_4\obj\Debug\Case05_4.csproj.GenerateResource.cache

?????文件???????9076??2021-02-06?14:39??C#學習教程\Case05_4\obj\Debug\Case05_4.csprojAssemblyReference.cache

?????文件??????11776??2021-02-06?14:38??C#學習教程\Case05_4\obj\Debug\Case05_4.exe

?????文件????????180??2021-02-06?14:38??C#學習教程\Case05_4\obj\Debug\Case05_4.Form1.resources

?????文件??????24064??2021-02-06?14:38??C#學習教程\Case05_4\obj\Debug\Case05_4.pdb

?????文件????????180??2021-02-06?14:38??C#學習教程\Case05_4\obj\Debug\Case05_4.Properties.Resources.resources

?????文件????????855??2021-02-06?14:44??C#學習教程\Case05_4\obj\Debug\DesignTimeResolveAssemblyReferences.cache

?????文件???????6942??2021-02-06?14:39??C#學習教程\Case05_4\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件???????3584??2021-02-06?14:39??C#學習教程\Case05_4\obj\Debug\TempPE\Properties.Resources.Designer.cs.dll

?????文件????????489??2008-06-10?18:25??C#學習教程\Case05_4\Program.cs

?????文件???????1372??2008-06-10?18:25??C#學習教程\Case05_4\Properties\AssemblyInfo.cs

?????文件???????2872??2021-02-06?14:38??C#學習教程\Case05_4\Properties\Resources.Designer.cs

?????文件???????5612??2008-06-10?18:25??C#學習教程\Case05_4\Properties\Resources.resx

?????文件???????1108??2021-02-06?14:38??C#學習教程\Case05_4\Properties\Settings.Designer.cs

?????文件????????249??2008-06-10?18:25??C#學習教程\Case05_4\Properties\Settings.settings

?????文件???????1130??2021-02-06?14:38??C#學習教程\Case05_4.sln

?????目錄??????????0??2021-02-06?14:47??C#學習教程\Case05_4\obj\Debug\TempPE

?????目錄??????????0??2021-02-06?14:47??C#學習教程\Case05_4\bin\Debug

?????目錄??????????0??2021-02-06?14:47??C#學習教程\Case05_4\obj\Debug

?????目錄??????????0??2021-02-06?14:47??C#學習教程\Case05_4\bin

?????目錄??????????0??2021-02-06?14:47??C#學習教程\Case05_4\obj

............此處省略6個文件信息