C#²Ù×÷AccessÀà
Re
using System;
using System.Data;
using System.Data.OleDb;
namespace AccessDb
{
/**//// <summary>
/// AccessDb µÄժҪ˵Ã÷£¬ÒÔÏÂÐÅÏ¢ÇëÍêÕû±£Áô
/// ÇëÔÚÊý¾Ý´«µÝÍê±Ïºóµ÷ÓÃClose()·½·¨£¬¹Ø±ÕÊý¾ÝÁ´½Ó¡£
/// </summary>
public class AccessDbClass
{
±äÁ¿ÉùÃ÷´¦#region ±äÁ¿ÉùÃ÷´¦
public OleDbConnection Conn;
public string ConnString;//Á¬½Ó×Ö·û´®
#endregion
¹¹Ô캯ÊýÓëÁ¬½Ó¹Ø±ÕÊý¾Ý¿â#region ¹¹Ô캯ÊýÓëÁ¬½Ó¹Ø±ÕÊý¾Ý¿â
/**//// <summary>
/// ¹¹Ô캯Êý
/// </summary>
/// <param name="Dbpath">ACCESSÊý¾Ý¿â·¾¶</param>
public AccessDbClass(string Dbpath)
{
ConnString = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=";
ConnString += Dbpath;
Conn = new OleDbConnection(ConnString);
Conn.Open();
}
/**//// <summary>
/// ´ò¿ªÊý¾ÝÔ´Á´½Ó
/// </summary>
/// <returns></returns>
public OleDbConnection DbConn()
{
Conn.Open();
return Conn;
}
/**//// <summary>
/// ÇëÔÚÊý¾Ý´«µÝÍê±Ïºóµ÷Óøú¯Êý£¬¹Ø±ÕÊý¾ÝÁ´½Ó¡£
/// </summary>
public void Close()
{
Conn.Close();
}
#endregion
Êý¾Ý¿â»ù±¾²Ù×÷#region Êý¾Ý¿â»ù±¾²Ù×÷
/**//// <summary>
/// ¸ù¾ÝSQLÃüÁî·µ»ØÊý¾ÝDataTableÊý¾Ý±í,
/// ¿ÉÖ±½Ó×÷ΪdataGridViewµÄÊý¾ÝÔ´
/// </summary>
/// <param name="SQL"></param>
/// <returns></returns>
public DataTable SelectToDataTable(string SQL)
{
OleDbDataAdapter adapter = new OleDbDataAdapter();
OleDbCommand command = new OleDbCommand(SQL, Conn);
adapter.SelectCommand = command;
DataTable Dt = new DataTable();
adapter.Fill(Dt);
Ïà¹ØÎĵµ£º
½üÆÚÓиöСCMSÏîÄ¿£¬ÓÉÓÚ·þÎñÆ÷¡¢ÈËÔ±ÒÔ¼°¹ÜÀíÖÆ¶ÈµÈһϵÁÐÎÊÌ⣬²»µÃ²»²ÉÓÃJava Web+AccessÕâÖÖ²»Âײ»ÀàµÄ×éºÏ½øÐпª·¢£¬ÆÚ¼äÓöµ½ÁËÒ»¸öСÎÊÌ⣬ÄǾÍÊÇÎÄÕÂÄÚÈݲÉÓÃAccessµÄ“±¸×¢”ÀàÐÍ´æÈ¡Ê±£¬·¢Éú×Ô¶¯½Ø¶ÏµÄÎÊÌâ¡£Ò²¾ÍÊÇ˵£¬´æ½øÈ¥10000×ÖµÄÎÄÕ£¬Ö»ÄÜÏÔʾ³ö3000 ......
¸ù¾Ý¿í¶ÈÀ´¾ö¶¨ÏÔʾµÄ×Ö·û´®³¤¶È (C#,VS2005)
Èç¹û lable³¤¶È¹Ì¶¨µ«×Ö·û´®³¤¶È¿É±ä£¬Èç¹û³¬¹ýÁËlableÏÔʾµÄ³¤¶Èʱ£¬Ï£ÍûÓà ...´úÌæÊ£ÏµÄ×Ö·û£¬ÕâʱÐèÒªÒ»¸öº¯Êý
Graphics.MeasureString
¾ßÌå´úÂëÈçÏÂ
public string Abbreviation(string str)
{
&nbs ......
±¾ÕÂΪ½Ó¿Ú¿Î³ÌµÄ×ÛºÏÁ·Ï°¡£
±¾´ÎÁ·Ï°Õ¹Ê¾ÁËÒ»¸ö¼ò»¯µÄÒøÐÐÒµÎñÁ÷³Ì£¬ÌåÏÖÁËÒøÐкÍÓû§Êý¸ö½ÇÉ«µÄ¹ØÏµ¡£¿´ÏÂͼ£º
ÕË»§ÀࣨAccount£©¶ÔÏó´æ´¢ÔÚÊý¾Ý¿âÀࣨDatabase£©¶ÔÏóÖУ»¼ÆËã»ú£¨Computer£©Àà¶ÔÏóÁ¬½Óµ½Êý¾Ý¿âÀà¶ÔÏóÉÏ£»ÒøÐйñ̨£¨BankCounter£©Àà¶ÔÏóÓµÓÐһ̨¼ÆËã»ú¶ÔÏó×÷Ϊ˽ÓгÉÔ±£¬ÀûÓøöÔÏó¶ÔÊý¾Ý¿â½øÐвÙ×÷£»AT ......
¡¾ÆªÊ×Óï¡¿Æäʵ±¾ÎĽéÉܵķ½·¨ÊÇÒ»¸ö˼·£¬µ«ÊÇÎҸоõ°ÉÎÊÌâ¸ã¸´ÔÓÁË¡£ÀÏÍâµÄÕâ¸öC#µ÷ÓÃC++µÄdll·½Ê½Í¦ºÃµÄ£¬Ò²ºÜÎȶ¨£¬¿ÉÒÔ¿´¿´http://www.codeproject.com/KB/cs/DynamicInvokeCSharp.aspx¡£
Õª Òª£ºÔÚ¡¶csdn¿ª·¢¸ßÊÖ¡·2004ÄêµÚ03ÆÚÖеġ¶»¯¹¦´ó·¨ ——½«DLLǶÈëEXE¡·Ò»ÎÄ£¬½éÉÜÁËÈçºÎ°ÑÒ»¸ö¶¯Ì¬Á´½Ó¿â×÷Ϊһ¸ ......
ÍêÉÆÁË“ÈçºÎÔÚC#ÖÐʹÓÃWin32ºÍÆäËû¿â”ÖйØÓÚEnumDesktops()º¯ÊýµÄ»Øµ÷´úÂ룬¿ÉÔËÐС£
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Runtime.InteropServices;
namespace ConsoleApplication1
{
class Program
{
delegate bool EnumDesk ......