易截截图软件、单文件、免安装、纯绿色、仅160KB

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";
          


相关文档:

Access Code Fingerprint Door Lock

 HTML clipboard
Presidential edition double action fingerprint and access code security door
lock for your office, business or home. Get 100% safety at your entry point with
this maximum security style deadbolt double action lock.
This is one of the best and most secure methods in assuri ......

Access自动编号字段重新计数问题

  在设计access数据库时,表中字段属性有id项设为自动编号类型的,添加许多记录后,在该表中将所有记录删除,再新增记录并不会从1开始,如何操作可以使新增记录编号重新从1计数?
 
解决方法:删除表里所有数据  然后压缩修复数据库  再新增就从1编号了
注:
 2000-2003压缩修复数据库点击:工具 ......

Access字符串处理函数

 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 ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号