ÔÚC#ÖÐÔËÓÃ SQLite
¡¡¡¡SQLite ÊÇÒ»¸öǶÈëʽµÄÁªÏµÊý¾Ý¿âϵͳ£¬ÔËÓÃÊ®·Ö¹ã·º¡£ÔÚһЩÊý¾ÝÁ¿²»´óµÄÔËÓà ³ÌÐòÖУ¬¼ÙÈçÔËÓà SQLite¿ÉÒÔ¼«´óµÄ½µµÍ²¿ÊðʱµÄ¹¤×÷Á¿¡£ ÒªÔÚC#ÖÐÔËÓà SQLiteÒ²ºÜ»ù±¾£¬Ö»ÒªÕÒÒ»¸öC#µÄwrapper¾Í¿ÉÒÔÁË£¬ÀýÈ磬ÎÒÔËÓõľÍÊÇÀ´×Ô
¡¡¡¡http://sqlite.phxsoftware.com/¡¡ µÄÒ»¸ödll£¬System.Data.SQLite. ÏÂÔØÏÂÀ´µÄÎļþÊÇSQLite-1.0.65.0-setup.exe¡£Ö»Òª°²×°Ò»Ï¾ͿÉÒÔÔËÓÃÁË£¬Ìر𷽱㡣¸Ã³ÌÐòÆõºÏ ADO.NETµÄ¹æ·¶£¬²¢ÇÒÖ§³Å Visual StudioµÄ¿ÉÊÓ»¯±íÉè¼ÆÆ÷¡£
¡¡¡¡´ò¿ªVisual Studio 2008£¬Ð½¨Ò»¸öConsole Application£¬Îª´ËÏîÄ¿Ìí¼ÓSystem.Data.SQLiteµÄÒýÓá£Ìí¼ÓÒ»¸öÊý¾Ý¿âÁ¬½Ó£¬´Ëʱ¿ÉÒÔ·¢¾õ£¬Ð½¨Á¬½ÓÖÐÓÐÁËÒ»¸öSQLite Database Connection£¬ÌôÑ¡´ËÀàÐ͵ÄÊý¾ÝÁ¬½Ó£¬²¢ÇÒн¨Ò»¸öÎļþ£¬
¡¡¡¡test.db3. ½ÓÏÂÀ´ÔÚÐÂÊý¾Ý¿âÖÐÌí¼ÓÒ»ÕÅ±í¡£
¡¡¡¡ÏÂÃæ¿ªÊ¼Îª´Ë±í½¨Á¢Ò»¸öData AccessÀ࣬ÒÔչʾÔÚC#ÖÐÈçºÎ ÔËÓà SQLite£¬¿ÉÒÔÏëÏ󣬺ͲÙ×÷ÆäËûÊý¾Ý¿âÊǼ¸ºõÒ»ÑùµÄ£¬¸ÐлADO.NETµÄ¹¦ÀÍ¡£
¡¡¡¡×îÏÈÊÇÒ»¸öʵÌåÀà Book.cs£º
public¡¡class¡¡Book
¡¡¡¡¡¡¡¡{
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡private¡¡int¡¡id;
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡private¡¡string¡¡bookName;
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡private¡¡decimal¡¡price;¡¡
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡public¡¡int¡¡ID
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡{
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡get¡¡{¡¡return¡¡id;¡¡}
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡set¡¡{¡¡id¡¡=¡¡value;¡¡}
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡}
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡public¡¡string¡¡BookName
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡{
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡get¡¡{¡¡return¡¡bookName;¡¡}
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡set¡¡{¡¡bookName¡¡=¡¡value;¡¡}
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡}
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡public¡¡decimal¡¡Price
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡{
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡get¡¡{¡¡return¡¡price;¡¡}
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡set¡¡{¡¡price¡¡=¡¡value;¡¡}
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡}
¡¡¡¡¡¡¡¡}¡¡
¡¡¡¡±àдDALÀࣺ
using¡¡System;
using¡¡System.Collections.Generic;
using¡¡System.Text;
using¡¡System.Data.SQLite;¡¡
namespace¡¡ConsoleApplication1
{
¡¡¡¡¡¡¡¡public¡¡class¡¡BookDAL
¡¡¡¡¡¡¡¡{
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡public¡¡static¡¡bool¡¡Create(Book¡¡book)
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡{
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡try
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡{
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡using¡¡(SQLiteConnection¡¡conn¡¡=¡¡new¡¡SQLiteConnection("Data¡¡Sourc
Ïà¹ØÎĵµ£º
ÕâÊÇÒ»¸öÓÃc#¿ØÖÆÌ¨³ÌÐòÏ£¬ ÓÃXmlDocument ½øÐÐXML²Ù×÷µÄµÄÀý×Ó£¬°üº¬Á˲éѯ¡¢Ôö¼Ó¡¢Ð޸ġ¢É¾³ý¡¢±£´æµÄ»ù±¾²Ù×÷¡£½ÏÍêÕûµÄÃèÊöÁËÒ»¸öXMLµÄÕû¸ö²Ù×÷Á÷³Ì¡£ÊʺϸÕÈëÃÅ.net XML²Ù×÷µÄÅóÓѲο¼ºÍѧϰ¡£
¼ÙÉèÓÐXMLÎļþ£ºbooks.xml
Xml´úÂ룺
<?xml version="1.0" encoding="UTF-8"?>
<books>
< ......
C#µÄToolTip£¨delphi½ÐHint£©»úÖÆ·Ç³£¹Ö£¬²»ÊÇÏñdelphiµÄÔª¼þÒ»Ñù£¬Ã¿¸öTControlÓÐÒ»¸öHintÊôÐÔ£¬C#ÓÐÒ»¸öToolTipÔª¼þ£¬µ±°ÑÕâ¸öÔª¼þ´Ó¹¤¾ßÏäÀµ½formÉϺó£¬Ñ¡ÖÐformÉϵÄÈκÎcontrolÔª¼þ£¬ÔÚÊôÐÔ´°Ì壨Object Inspector£©ÉϾͻá¶à³öÒ»¸öÊôÐÔ“toolTip1ÉϵÄToolTip”£¬Èç¹û¶àÀ¼¸¸ ......
Ò»¡¢½¨Á¢ÍøÒ³
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<script language="javascript" type="text/javascript">
<!-- Ìṩ¸øC#³ÌÐòµ÷Óõķ½·¨ -->
function messageBox(message)
{
alert(message);
}
</script>
</head>
& ......
xmlÎļþ:
<?xml version="1.0" encoding="utf-8" ?>
<bookstore>
<book>
<title lang="eng">Harry Potter</title>
<price>29.99</price>
</book>
<book>
......
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Microsoft.Office.Inter ......