Description: C# SQL efficient operation class source
Features:
Extremely flexible and can be very easy to use and efficient operation of the database is up and ease of operation of sql2005 over Mysql,
Most suitable for making corporate Web site, developed highly efficient operation is very simple.
Use examples:
Object [] str = {biaoti.Text,
neirong.Text,
DateTime.Now
}
Conn.Add ("news", "biaoti, neirong, date", str)
Review:
int id = System.Convert.ToInt32 (myid.Text)
Object [] str = {Request ["biaoti"],
Request ["neirong"],
DateTime.Now
}
Conn.Edit ("news", "biaoti, neirong, date", str, "id =" id)
Delete example:
int id = System.Convert.ToInt32 (Request.QueryString ["id"])
Conn.Delete ("news", "id =" id) // Note that where no increase
Response.Redirect ("Default.aspx")
List of examples:
// Output paging receiver sub-pa
To Search:
File list (Check if you may need any files):
Jd_sql.sln
Jd_sql.suo
......\add.aspx
......\add.aspx.cs
......\add.aspx.designer.cs
......\bin\Jd_Conn.dll
......\...\Jd_Conn.pdb
......\...\Jd_sql.dll
......\...\Jd_sql.pdb
......\Default.aspx
......\Default.aspx.cs
......\Default.aspx.designer.cs
......\delete.aspx
......\delete.aspx.cs
......\delete.aspx.designer.cs
......\edit.aspx
......\edit.aspx.cs
......\edit.aspx.designer.cs
......\Jd_sql.csproj
......\Jd_sql.csproj.user
......\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache
......\...\.....\Jd_sql.csproj.FileListAbsolute.txt
......\...\.....\Jd_sql.dll
......\...\.....\Jd_sql.pdb
......\...\.....\ResolveAssemblyReference.cache
......\Properties\AssemblyInfo.cs
......\Scripts\jquery-1.4.1-vsdoc.js
......\.......\jquery-1.4.1.js
......\.......\jquery-1.4.1.min.js
......\Web.config
......\Web.Debug.config
......\Web.Release.config
......\write.aspx
......\write.aspx.cs
......\write.aspx.designer.cs
......\obj\Debug\TempPE
......\...\Debug
......\App_Data
......\bin
......\obj
......\Properties
......\Scripts
Jd_sql
Download