c#ÓïÑÔ²Ù×÷AccessÊý¾Ý¿â
±¾ÎĽ«c#ÓïÑÔ²Ù×÷AccessÊý¾Ý¿âµÄ·½·¨¼ÓÒÔ×ܽᣬÖ÷Òª½â¾öµÄÎÊÌâÈçÏ£º
´´½¨mdb
´´½¨table
¶ÁÈ¡tableÄÚÈÝ
²é
ѯtableÖеÄÄÚÈÝ
ÏòtableÖвåÈëÊý¾Ý
ɾ³ýtableÖеļǼ
ÏòtableÖвåÈëÕÕƬ
¶ÁÈ¡tableÖеÄÕÕƬµÈ¡£
ÎÄ
½éÉÜC#
·ÃÎʲÙ×÷AccessÊý¾Ý¿âµÄ»ù´¡ÖªÊ¶£¬²¢Ìá
¹©Ò»¸öÏà¹ØµÄÀý³Ì¡£C#µÄADO.NET»¹²»ÄÜͨ¹ý±à³Ì·½Ê½´´½¨È«ÐµÄACCESS(MDB)Êý¾Ý¿â£¬ËùÒÔ»¹Ö»ÄÜʹÓÃADOXÕâ¸öÀ´×ÔCOMµÄÁ´½Ó¿âÀ´²Ù
×÷¡£
Ö÷Ҫ֪ʶµãÈçÏ£º
using System.Data.OleDb;
using System.Data;
Á¬½Ó×Ö·û
´®£ºString connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=product.mdb";
½¨Á¢Á¬½Ó£ºOleDbConnection connection = new
OleDbConnection(connectionString);
ʹÓÃOleDbCommandÀàÀ´Ö´ÐÐSqlÓï¾ä£º
OleDbCommand
cmd = new OleDbCommand(sql, connection);
connection.Open();
cmd.ExecuteNonQuery();
1.´´½¨mdb¿â£¬Àý³ÌÈçÏ£º
ÐèҪעÒâµÄÊÇ£º²ÎÊýmdbPathÊÇmdbµÄÍêÕû·¾¶£¨²»°üº¬±íµÄÃû³Æ£©¡£ÀýÈ磺D:\\test.mdb
//´´½¨mdb
public static bool
CreateMDBDataBase(string mdbPath)
{
try
{
ADOX.CatalogClass cat = new ADOX.CatalogClass();
cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + mdbPath +
";");
cat = null;
return true;
}
catch { return false; }
}
2.´´½¨¾ßÌåµÄ±í£¬À
Ïà¹ØÎĵµ£º
public struct RECT
{
public int left;
public int Top;
public int Right;
public int Bottom;
}
public static bool CenterMouseOn(int hwnd)
{
......
public struct POINTAPI
{
public int x;
public int y;
}
public static void GetWindowfromPoint(ref int hwnd,ref StringBuilder winText,ref StringBuilder clsName,ref StringBuilder pText)
{
int parentHandle=0;
int maxLen=128;
POINTAPI pnt = new ......
ÎÞÒâÖп´µ½ref¹Ø¼ü×Ö£¬Ö»¼ÇµÃÒ»¿ªÊ¼Ñ§Ï°C#µÄʱºò£¬ÓкܶණÎ÷¶¼Ìø¹ýÈ¥ÁË¡£ ½ñÌì¸Õ¿´¼ûÕâ¸ö¹Ø¼ü×ÖµÄʱºò£¬»¹Õæ²»ÖªµÀËüÓÐʲôÌرðµÄµØ·½¡£googleÁËһϣ¬ÕÒµ½Ò»Æª½âÊÍµÄ±È½Ï ºÃµÄÎÄÕ¡£ÈçÏ£º C# ÖеıäÁ¿ C# ÖеÄÊý¾ÝÓÐÁ½ÖÖÀàÐÍ£ºÒýÓÃÀàÐÍ£¨reference types£©ºÍÖµÀàÐÍ£¨value types£©¡£ ¼òµ¥ÀàÐÍ£¨°üÀ¨int, long, doubleµÈ£ ......
c# SQLÊý¾Ý¿âÔ¶³ÌÁ¬½Ó¼°ÅäÖ÷½·¨
Ò»£ºC# Á¬½ÓSQLÊý¾Ý¿â
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;
Server=myServerAddress;D ......