【ASP】ASP.NET(C#)中操作SQLite数据库实例-NET-SQLite

欢迎您访问我爱IT技术网，今天小编为你分享的编程技术是：【ASP.NET(C#)中操作SQLite数据库实例】，下面是详细的讲解！

ASP.NET(C#)中操作SQLite数据库实例

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("打开数据库成功~~<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("单个值查询结果为:" + 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("更新数据库中的数据成功.");
Response.Write("以下结果为查询从数据库中经过编辑过后的数据项<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();
}
}

关于ASP.NET(C#)中操作SQLite数据库实例的用户互动如下：

　　相关问题：

　　答： >>详细

　　相关问题：

　　答： >>详细

　　相关问题：

　　答： >>详细