Ò»¶ÎÏòAccessÖб£´æÍ¼Æ¬µÄ³ÌÐò£¬Çë¸ßÊÖÖ¸µãÒ»ÏÂ
c# WinformÏÂÏòaccessÊäÈëͼƬ
Òª×öÒ»¸öµç×ÓÈËÔ±ÐÅÏ¢±í£¬°üÀ¨¸öÈ˵Ļù±¾ÐÅÏ¢ºÍÒ»ÕÅÕÕÆ¬£¬ÓõÄÊÇAccessÊý¾Ý¿â¡£
ÇëÎÊÈçºÎ°ÑÕÕÆ¬ÉÏ´«²¢±£´æµ½Êý¾Ý¿âÀïÃæ£¿¶øÇÒ²éѯµÄʱºò»¹¿ÉÒÔ°ÑÕÕÆ¬ÏÔʾ³öÀ´¡£
ÎҵijÌÐòÈçÏ£º
C# code:
string fullpath = E:\µçÄÔͼ±ê\BMPͼÀý\BestBMP48X48\2.bmp;//Îļþ·¾¶
FileStream fs = new FileStream(fullpath, FileMode.Open, FileAccess.Read);
byte[] imagebytes = new byte[fs.Length];
BinaryReader br = new BinaryReader(fs);
imagebytes = br.ReadBytes(Convert.ToInt32(fs.Length));
fs.Close();
//´ò¿ªÊýËù
OleDbConnection con1 = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + "¾·Ñ·ÖÎöÊý¾Ý¿â.mdb" + ";Persist Security Info=False");
con1.Open();
OleDbCommand cmd = con1.CreateCommand();
OleDbTransaction trans = con1.BeginTransaction();
cmd.Connection = con1;
cmd.Transaction = trans;
string strcomm = "insert into [µ¥Î»ÈËÔ±ÐÅÏ¢]([ÕÕÆ¬])";
strcomm += "values('" + imagebytes + "')";
cmd.CommandText = strcomm;
int intFalg = cmd.ExecuteNonQuery();
Ïà¹ØÎÊ´ð£º
access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôÔÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ
sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£
ÊÇ ......
ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......
DbgridÁ¬½Óaccess ÏÔʾÊý¾ÝʱÍ϶¯¹ö¶¯ÌõËÀ»ú£¿Ôõô½â¾ö°¡£¿
»úÆ÷Ì«²îÁ˰ɣ¿
ÊDz»ÊÇÄãÊý¾ÝÁ¿Ì«´óÁ˰¡
ÄãÊý¾ÝÉÙһЩ¿´¿´»¹ËÀ»úÂð£¿
Êý¾ÝºÜÉÙ°¡ ¾ÍÒ»Ò³¡£
ÎÒÔÚBCB6ÏÂ×ö¹ý²»ÉÙ DBGRID+ACCESS £¬´ÓÀ´Ã»ÓÐÓöµ½ ......
¸÷λ´óϺ£¬Ð¡µÜÓõÄÊÇADOÁ¬½ÓACCESSÊý¾Ý¿â£¬ÓÃDBGridÏÔʾ²éѯµÄÊý¾Ý£¬ÎÒ×öµÄÊǸöÊý¾Ý²É¼¯ÏµÍ³£¬¸ù¾Ý²»Í¬µÄµØÖ·°ÑÊý¾Ý·ÅÔÚACCESSÊý¾Ý¿âÖв»Í¬µÄ±íÀïÃæ£¬ÏÖÔÚÎÒÏë²éѯijһ¶Îʱ¼äÄÚËùÓбíÄÚµÄÊý¾Ý£¬²¢ÇÒÔÚDBGridÖÐÏÔʾ³ ......
ÎÒÓÐÁ½¸öaccessÊý¾Ý¿â£¬¼ÙÉè:a1.mdb£¬a2.mdb
ËüÃǶ¼ÓÐÒ»ÕŽṹһÑùµÄ±íproduct,ÎÒÏë°Ña2.mdbÀïÃæµÄproductµ¼Èëµ½a1.mdbµÄproductÀïÃæÈ¥£¬ÈçºÎʵÏÖ¿ìµã£¿Íû¸ßÊÖµãÏ¡£
ÒýÓÃ
Óõ¼Èëµ¼³ö²»ÐÐ??
......