Image To Access
using System;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.IO;
using System.Windows.Forms;
namespace ImageDB
{
public partial class FormImageAccess : Form
{
#region ×Ô¶¨Òå¶ÔÏó
private OleDbConnection ole;
private DataTable table;
#endregion
public FormImageAccess()
{
#region
InitializeComponent();
openFileImage.Filter = "ͼÏñÎļþ|*.bmp;*.gif;*.jpg;*.jpeg;*.png|ËùÓÐÎļþ|*.*";
pictureBox1.SizeMode = PictureBoxSizeMode.Zoom; // ͼÏñ´óС°´ÆäÔÓеĴóС±ÈÀý±»Ôö¼Ó»ò¼õС¡£
table = new DataTable();
DataColumn column = table.Columns.Add("Name", typeof(String));
table.Columns.Add("Image", typeof(Image));
table.Constraints.Add("PK", column, true);
OleDbConnectionStringBuilder builder = new OleDbConnectionStringBuilder();
builder.Provider = "Microsoft.Jet.OLEDB.4.0"; // "Microsoft.ACE.OLEDB.12.0"
builder.DataSource = @"|DataDirectory|\Images.mdb";
 
Ïà¹ØÎĵµ£º
Take Equity Collection System as an example, Some other office collegues want to access it from home without VPN, The way to check is:
1. Check if it's limited in network, this needs to confirm with network people
2. If the step 1 passed, get the external IP address of the system, map ......
´ó¸ÅµÄ¹¦ÄܾÍÊÇÈÕÆÚÌáÐÑ£¬°ÑͨѶ¼ºÍÈÕÆÚÌáÐÑÏà½áºÏ¡£
ÌáÐÑ·½Ãæ×öµÄºÜ²î£¬¼¼ÊõÓÐÏÞ¡£
Ƥ·ôÓõÄÊÇSkin++
µÚÒ»´Î·¢£¬µ«Ö®Ç°Ð޸Ĺý¼¸´Î£¬Ä¿Ç°°æ±¾0.7
×öÕâ¸ö¶«Î÷ÍêÈ«ÊÇÒòΪÎÒ¸öÈËÐèÒª¡£
ÊÇÒ»¸ö¶àÓû§µÄ¹¤¾ß¡£
ÓÐ×Ô¶¯Éý¼¶¹¦ÄÜ¡£
Ó¦Ó÷¶Î§ºÜÕ¡£
ÏÂÔØµØÖ·£ºhttp://www.cppblog.com/Files/pencil/GoodFriendV0.7.rar
Ô ......
Á¬½ÓACCESSÊý¾Ý¿âµÄ¼òµ¥JSP´úÂ룺
<%@ page language="java" contentType="text/html; charset=GB18030"
pageEncoding="GB18030"%>
<%@ page import="java.sql.*" %>
<%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;
String url="jdbc:odbc:Driver={MicroSoft Access Drive ......
1.Asc
˵Ã÷:·µ»Ø×ÖĸµÄAcsiiÖµ
¾ÙÀý:select Asc("A")·µ»Ø65
2.Chr
˵Ã÷:½«asciiֵת»»µ½×Ö·û
¾ÙÀý:select chr(65)·µ»Ø"A"
3.Format
˵Ã÷:¸ñʽ»¯×Ö·û´®
¾ÙÀý:Select Format(now(),"yyyy-mm-dd")·µ»ØÀàËÆÓÚ"2008-04-03"
&n ......