using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Text;
using?System.Windows.Forms;
using?System.Data.SQLite;

namespace?CShape_Sqlite
{
????public?partial?class?Form1?:?Form
????{

????????DataTable?stuDT?=?new?DataTable（）;

????????int?pageSize?=?0;
????????int?total?=?0;
????????int?pageCount?=?0;
????????int?pageCurrent?=?0;
????????int?currentRow?=?0;

????????public?Form1（）
????????{
????????????InitializeComponent（）;
????????}

????????/*查詢數據庫*/
????????public?DataTable?SelectDB（）
????????{
????????????string?dbPath?=?“DB//studentInfo.db3“;

????????????/*打開數據庫連接*/
????????????string?strconn?=?“Data?Source?=?“?+?dbPath?+?“;“;
????????????SQLiteConnection?sqlconn?=?new?SQLiteConnection（strconn）;??//創建連接
????????????sqlconn.Open（）;????????????????????????????????????????????//打開連接

????????????/*執行sql命令*/
????????????string?strSQL?=?“select?*?from?studentInfo“;
????????????SQLiteDataAdapter?sqd?=?new?SQLiteDataAdapter（strSQL?sqlconn）;
????????????DataTable?dt?=?new?DataTable（）;
????????????sqd.Fill（dt）;??????????????????????????????????????????????//將SQL語句執行結果放入dt中

????????????/*關閉連接*/
????????????sqlconn.Close（）;

????????????return?dt;
????????}

????????private?void?button1_Click（object?sender?EventArgs?e）
????????{
????????????stuDT?=?SelectDB（）;

????????????/*處理數據庫無數據的情況*/
????????????if?（stuDT?==?null?||?stuDT.Rows.Count?==?0）
????????????{
????????????????MessageBox.Show（“沒有學生信息可顯示！“）;
????????????}

????????????/*為dataGridView1綁定數據源*/
????????????else
????????????{
????????????????InitDataSet（）;
????????????????//this.dataGridView1.DataSource?=?stuDT;
????????????}
????????}

????????/*初始化顯示頁面*/
????????private?void?InitDataSet（）
????????{
????????????pageSize?=?10;??????//設置頁面行數
????????????total?=?stuDT.Rows.Count;
????????????pageCount?=?（total?/?pageSize）;????//計算出總頁數

????????????if?（（total?%?pageSize）?>?0）
????????????{
????????????????pageCount++;
????????????}
????????????pageCurrent?=?1;????//當前頁數從開始
????????????currentRow?=?0;?????//當前記錄數從開始

????????????/*載入DataTable保存的數據庫信息*/
????????????LoadData（）;
????????}

????????/*載入DataTable保存的數據庫信息*/
????????private?void?LoadData（）
????????{
????????????int?nStartPos?=?0;???//當前頁面開始記錄行
????????????int?nEndPos?=?0;?????//當前頁面結束記錄行

????????????DataTable?dtTemp?=??this.stuDT.Clone（）;???//克隆DataTable結構框架

????????????if?（pageCurrent?==?pageCount）
????????????{
????????????????nEndPos?=?total;
????????????}
????????????else
????????????{
????????????????nEndPos?=?pageSize?*?pageCurrent;
????????????}
????????????nStartPos?=?currentRow;

????????????/*將對應信息顯示在菜單欄和總數統計Label中*/
????????????toolStripLabel2.Text?=?“/?“?+?pageCount.ToString（）;
????????????if?（stuDT.Rows.Count?==?0）
????????????{
????????????????toolStripTextBox1.Text?=?“0“;
????????????}
????????????else
????????????{
?????????????

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

?????文件????????928??2013-05-31?14:02??CShape_Sqlite\CShape_Sqlite.sln

????..A..H.?????14336??2013-05-31?18:11??CShape_Sqlite\CShape_Sqlite.suo

?????文件???????3647??2013-05-31?18:08??CShape_Sqlite\CShape_Sqlite\CShape_Sqlite.csproj

?????文件????????472??2013-05-31?14:02??CShape_Sqlite\CShape_Sqlite\Program.cs

?????文件??????92102??2013-05-31?18:05??CShape_Sqlite\CShape_Sqlite\stu.ico

?????文件???????5350??2013-05-31?18:08??CShape_Sqlite\CShape_Sqlite\Form1.cs

?????文件??????10590??2013-05-31?18:08??CShape_Sqlite\CShape_Sqlite\Form1.Designer.cs

?????文件?????144887??2013-05-31?18:08??CShape_Sqlite\CShape_Sqlite\Form1.resx

?????文件???????5612??2013-05-31?14:02??CShape_Sqlite\CShape_Sqlite\Properties\Resources.resx

?????文件????????249??2013-05-31?14:02??CShape_Sqlite\CShape_Sqlite\Properties\Settings.settings

?????文件???????1188??2013-05-31?14:02??CShape_Sqlite\CShape_Sqlite\Properties\AssemblyInfo.cs

?????文件???????2882??2013-05-31?14:02??CShape_Sqlite\CShape_Sqlite\Properties\Resources.Designer.cs

?????文件???????1098??2013-05-31?14:02??CShape_Sqlite\CShape_Sqlite\Properties\Settings.Designer.cs

?????文件???????5632??2005-11-11?22:25??CShape_Sqlite\CShape_Sqlite\bin\Debug\CShape_Sqlite.vshost.exe

?????文件?????208896??2013-05-31?18:08??CShape_Sqlite\CShape_Sqlite\bin\Debug\CShape_Sqlite.exe

?????文件??????28160??2013-05-31?18:08??CShape_Sqlite\CShape_Sqlite\bin\Debug\CShape_Sqlite.pdb

?????文件???????3072??2013-05-31?15:53??CShape_Sqlite\CShape_Sqlite\bin\Debug\DB\studentInfo.db3

?????文件????????988??2013-05-31?18:11??CShape_Sqlite\CShape_Sqlite\obj\CShape_Sqlite.csproj.FileListAbsolute.txt

?????文件???????4631??2013-05-31?15:24??CShape_Sqlite\CShape_Sqlite\obj\Debug\ResolveAssemblyReference.cache

?????文件??????92668??2013-05-31?18:08??CShape_Sqlite\CShape_Sqlite\obj\Debug\CShape_Sqlite.Form1.resources

?????文件????????180??2013-05-31?15:24??CShape_Sqlite\CShape_Sqlite\obj\Debug\CShape_Sqlite.Properties.Resources.resources

?????文件?????208896??2013-05-31?18:08??CShape_Sqlite\CShape_Sqlite\obj\Debug\CShape_Sqlite.exe

?????文件??????28160??2013-05-31?18:08??CShape_Sqlite\CShape_Sqlite\obj\Debug\CShape_Sqlite.pdb

?????文件????????842??2013-05-31?18:08??CShape_Sqlite\CShape_Sqlite\obj\Debug\CShape_Sqlite.csproj.GenerateResource.Cache

?????文件???????3072??2013-05-31?15:53??CShape_Sqlite\CShape_Sqlite\DB\studentInfo.db3

?????文件????3172352??2013-04-18?21:32??CShape_Sqlite\附加文件\SQLite-1.0.66.0-setup.exe

?????文件?????470528??2013-05-31?18:11??CShape_Sqlite\附加文件\C#連接sqlite分頁顯示實用教程.doc

?????文件????????429??2013-05-31?18:16??CShape_Sqlite\項目使用說明.txt

?????目錄??????????0??2013-05-31?15:24??CShape_Sqlite\CShape_Sqlite\bin\Debug\DB

?????目錄??????????0??2013-05-31?14:02??CShape_Sqlite\CShape_Sqlite\obj\Debug\TempPE

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