中文字幕日韩一区二区_国产一区二区av_国产毛片av_久久久久国产一区_色婷婷电影_国产一区二区精品

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

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

    

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

     ASPx頁面僅包含一按鈕btnTest,在頁面ASPx.cs頁面中,引入命名空間,貼入以下類似代碼即可.    
復(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("打開數(shù)據(jù)庫成功~~<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è)值查詢結(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ù)庫中的數(shù)據(jù)成功.");
Response.Write("以下結(jié)果為查詢從數(shù)據(jù)庫中經(jīng)過編輯過后的數(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();
}
}

AspNet技術(shù)ASP.NET(C#)中操作SQLite數(shù)據(jù)庫實(shí)例,轉(zhuǎn)載需保留來源!

鄭重聲明:本文版權(quán)歸原作者所有,轉(zhuǎn)載文章僅為傳播更多信息之目的,如作者信息標(biāo)記有誤,請第一時(shí)間聯(lián)系我們修改或刪除,多謝。

主站蜘蛛池模板: 91久久伊人 | 精品国产乱码一区二区三区 | 久久不卡视频 | 免费在线观看成年人视频 | www.成人.com | 91亚洲国产精品 | 久久久久国产精品午夜一区 | 青青草一区二区三区 | 日韩成人精品一区 | 国产精品一级在线观看 | 99精品热视频| 日韩精品一区二区在线 | 国产在线精品一区二区三区 | 午夜男人天堂 | 日日碰狠狠躁久久躁96avv | 欧美精品一区在线发布 | 亚洲精品久久久一区二区三区 | 一区二区三区免费 | 免费人成在线观看网站 | 亚洲成人免费观看 | 日本免费一区二区三区四区 | 亚洲黄色片免费观看 | 男人的天堂久久 | 免费毛片网站在线观看 | 一级毛片中国 | 一道本一区二区 | 日韩综合网 | 亚洲精品亚洲人成人网 | 免费成年网站 | 春色av | 久草精品视频 | 黄色毛片在线播放 | 亚洲性视频 | 精品自拍视频 | 亚洲欧洲av在线 | 日韩视频在线免费观看 | 国产精品视频一区二区三区四蜜臂 | 久久1区| 国产精品久久久久久久免费大片 | 中文字幕不卡一区 | 国产精品不卡一区 |