Ò»¶ÎÏò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Êý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......
accessÊý¾Ý¿â£¬Ö±½ÓʹÓà select ×Ö¶Î from ±í ¶ÁÈ¡Êý¾Ý
È»ºóÔÚÒ³ÃæÖÐʹÓÃRepeaterÀ´ÏÔʾ
ÕâÕűíÓÐ2000ÌõÊý¾Ý£¬ËùÒÔÒ³Ãæ´ò¿ªµÄºÜÂý
Çë½Ì¸÷λÅóÓÑ£¬ÓÐûÓа취½â¾ö£¬Ìá¸ßµãËÙ¶È£¡
Ò»´ÎÈ«²¿¶ÁÍê ......
ÎÒÓÐÁ½¸öaccessÊý¾Ý¿â£¬¼ÙÉè:a1.mdb£¬a2.mdb
ËüÃǶ¼ÓÐÒ»ÕŽṹһÑùµÄ±íproduct,ÎÒÏë°Ña2.mdbÀïÃæµÄproductµ¼Èëµ½a1.mdbµÄproductÀïÃæÈ¥£¬ÈçºÎʵÏÖ¿ìµã£¿Íû¸ßÊÖµãÏ¡£
ÒýÓÃ
Óõ¼Èëµ¼³ö²»ÐÐ??
......