快捷導(dǎo)航

ASP.NET(C#)中操作SQLite數(shù)據(jù)庫(kù)實(shí)例

更新時(shí)間：2009年12月24日 01:26:57 作者：

最近項(xiàng)目中有使用到SQLite數(shù)據(jù)庫(kù),于是查找資料,編寫(xiě)了一個(gè)ASP.NET基于C#語(yǔ)言的SQLite數(shù)據(jù)庫(kù)操作實(shí)例.大家看代碼就可以看懂了,和以往使用ADO.NET操作SQL數(shù)據(jù)庫(kù)類(lèi)似.

要想在ASP.NET項(xiàng)目中使用SQLite數(shù)據(jù)庫(kù),先需下載一個(gè)ADO.NET 2.0 SQLite Data Provider,下載地址為:http://sourceforge.net/project/showfiles.php?group_id=132486&package_id=145568,下載后安裝完畢后,該安裝程序自動(dòng)在在系統(tǒng)注冊(cè)(即可在"添加引用"中看到所安裝的Provider).

然后,在項(xiàng)目中添加上圖所選項(xiàng)即可.

aspx頁(yè)面僅包含一按鈕btnTest,在頁(yè)面aspx.cs頁(yè)面中,引入命名空間,貼入以下類(lèi)似代碼即可.

復(fù)制代碼代碼如下:

using System; 
using System.Data; 
using System.Web.UI.WebControls; 
using System.Data.SQLite; 

public partial class _Default : System.Web.UI.Page 
{ 
protected void Page_Load(object sender, EventArgs e) 
{ 
} 
protected void btnTest_Click(object sender, EventArgs e) 
{ 
SQLiteConnection.ClearAllPools(); 
SQLiteConnection.CreateFile(Server.MapPath("~") + "/UserData.dbx"); 
SQLiteConnection conn = new SQLiteConnection("Data Source=" + Server.MapPath("~" + "/UserData.dbx")); 
conn.Open(); 
Response.Write("打開(kāi)數(shù)據(jù)庫(kù)成功~~<br />"); 
SQLiteCommand cmd = new SQLiteCommand(); 
cmd.CommandText = "create table Users (UserID int primary key,UserName varchar(100) not null,UserPassword varchar(100) not null)"; 
cmd.Connection = conn; 
cmd.ExecuteNonQuery(); 
for (int i = 0; i < 100;i++ ) 
{ 
cmd.CommandText = "insert into Users (UserID,UserName,UserPassword) values (" + i + ",'TestUser_" + i + "','" + DateTime.Now.ToString().Replace(" ", "-").Replace(":", "-") + "')"; 
cmd.ExecuteNonQuery(); 
} 
Response.Write("插入成功~~<br />"); 
cmd.CommandText = "select Username from Users where UserID=1"; 
cmd.Connection = conn; 
string tempUserName = cmd.ExecuteScalar().ToString(); 
Response.Write("單個(gè)值查詢(xún)結(jié)果為:" + tempUserName + "<br /><br />"); 

cmd.CommandText = "select * from Users "; 
cmd.Connection = conn; 
SQLiteDataReader sdrInfo = cmd.ExecuteReader(); 
if (sdrInfo!= null) 
{ 
int userID = 0; 
string userName = string.Empty; 
string userPassword = string.Empty; 
while(sdrInfo.Read()) 
{ 
userID = Convert.ToInt32(sdrInfo["UserID"]); 
userName = sdrInfo["UserName"].ToString(); 
userPassword = sdrInfo["UserPassword"].ToString(); 
Response.Write("UserID:"+userID+"<br />"); 
Response.Write("UserName:" + userName+ "<br />"); 
Response.Write("UserPassword:" + userPassword + "<br />"); 
Response.Write("<br />"); 
} 
sdrInfo.Close(); 
sdrInfo.Dispose(); 
} 
cmd.CommandText = "update Users set UserPassword='linxiang'"; 
cmd.Connection = conn; 
cmd.ExecuteNonQuery(); 
Response.Write("更新數(shù)據(jù)庫(kù)中的數(shù)據(jù)成功."); 
Response.Write("以下結(jié)果為查詢(xún)從數(shù)據(jù)庫(kù)中經(jīng)過(guò)編輯過(guò)后的數(shù)據(jù)項(xiàng)<br /><br />"); 
cmd.CommandText = "select * from Users "; 
cmd.Connection = conn; 
sdrInfo = cmd.ExecuteReader(); 
if (sdrInfo != null) 
{ 
int userID = 0; 
string userName = string.Empty; 
string userPassword = string.Empty; 
while (sdrInfo.Read()) 
{ 
userID = Convert.ToInt32(sdrInfo["UserID"]); 
userName = sdrInfo["UserName"].ToString(); 
userPassword = sdrInfo["UserPassword"].ToString(); 
Response.Write("UserID:" + userID + "<br />"); 
Response.Write("UserName:" + userName + "<br />"); 
Response.Write("UserPassword:" + userPassword + "<br />"); 
Response.Write("<br />"); 
} 
sdrInfo.Close(); 
sdrInfo.Dispose(); 
} 
conn.Clone(); 
conn.Dispose(); 
} 
} 