資源簡介
常用的幾個SQLite數(shù)據(jù)庫 輔助類(C#版本)
代碼片段和文件信息
/**************************************
*?作用:SQLLite?Server操作實現(xiàn)
*?作者:Nick.Yan
*?日期:?2009-03-29
*?網(wǎng)址:www.redglove.net
**************************************/
using?System;
using?System.Collections;
using?System.Collections.Specialized;
using?System.Data;
using?System.Data.SQLite;//這個可以去網(wǎng)上下載
using?System.Configuration;
public?class?SQLiteHelper
{
????//數(shù)據(jù)庫連接字符串(web.config來配置),可以動態(tài)更改SQLString支持多數(shù)據(jù)庫.?
????public?static?string?connectionString?=?“Data?Source=“?+
????System.Web.HttpContext.Current.Server.MapPath(
????ConfigurationManager.AppSettings[“SQLString“]);
????public?SQLiteHelper()?{?}
????#region?公用方法
????public?static?int?GetMaxID(string?FieldName?string?TableName)
????{
????????string?strsql?=?“select?max(“?+?FieldName?+?“)+1?from?“?+?TableName;
?????
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件??????20056??2009-08-24?10:33??SQLiteHelper\SQLiteHelper0.cs
?????文件??????15883??2009-08-24?10:02??SQLiteHelper\SQLiteHelper1.cs
?????文件??????13781??2009-08-24?10:06??SQLiteHelper\SQLiteHelper2.cs
?????文件???????5315??2009-08-24?10:00??SQLiteHelper\SQLiteHelper3.cs
?????文件???????7964??2009-08-24?10:07??SQLiteHelper\SQLiteHelper4.cs
?????目錄??????????0??2009-08-25?15:22??SQLiteHelper
-----------?---------??----------?-----??----
????????????????62999????????????????????6
- 上一篇:Utility基礎(chǔ)類大全
- 下一篇:WebSocket4Net使用源碼
評論
共有 條評論