C#¶ÁдAccessÊý¾Ý¿âµÄOLE¶ÔÏó×Ö¶Î
£¨Ò»£©°ÑÎļþÄÚÈÝдÈëAccessÊý¾Ý¿âµÄOLE¶ÔÏó×Ö¶ÎÖУº
if (File.Exists(txtBrow.Text) != false) // Îı¾¿òtxtBrowÖÐÄÚÈÝΪÎļþ·¾¶¼°ÎļþÃû
{
//»ñÈ¡Îļþºó׺
FileInfo p = new FileInfo(txtBrow.Text.Trim());
F_str_Type = p.Extension.ToLower();
if (F_str_Type.Length > 5)
{
MessageBox.Show("²»¿Éʶ±ðµÄÎļþ¸ñʽ£¬ÇëÖØÐÂÈ·ÈÏ£¡","¾¯¸æ");
return;
}
//ÅжÏÎļþ´óС
if (p.Length == 0)
{
MessageBox.Show("ÎļþµÄ´óСΪ“0”£¬²»Äܱ£´æ£¡", "¾¯¸æ");
return;
}
//´´½¨Îļþ¶ÔÏóÒÔ´ò¿ªµÄÐÎʽ¶ÁÈ¡Îļþ
FileStream sFileStream = new FileStream(txtBrow.Text, FileMode.Open);
//·ÖÅäÊý×é´óС
byte[] bFile = new byte[sFileStream.Length];
//½«ÎļþÄÚÈݶÁ½øÊý×é
sFileStream.Read(bFile, 0, (int)sFileStream.Length);
//¹Ø±ÕÎļþ¶ÔÏó
sFileStream.Close();
//²éÕÒÎĵµÀà±ðºÅ
OleDbDataReader topicread = SaveConn.GetReader("select File_ID from FileTopic where File_Topic='" + cbbTopic.Text.Trim() + "'");
//Read()·½·¨ÓÃÀ´¶ÁÈ¡OleDbDataReader¶ÔÏóÖеļǼ
topicread.Read();
T_int_Topic=(int)topicread["File_ID"];
OleDbConnectio
Ïà¹ØÎĵµ£º
SqLite.netµÄdllΪSystem.Data.SQLite.dll£¬ÕâÖÖdll·ÖΪ32λ¡¢64λºÍÊÊÓÃÓÚcompactframeworkÈýÖÖ£¬ÔÚÒýÓÃʱҪעÒ⣬ѡÔñÕýÈ·µÄdll¡£
½«Òª±£´æͼƬµÄ×Ö¶ÎÀàÐÍÉèΪblob¡£´úÂëÈçÏ£º
private void savePicture£¨£©
{
using (SQLiteConnection cnn = new SQLiteConnection(dbPath))
......
Ç°Ò»¶Îʱ¼äÊÔ×ÅÓÃÕâÈýÖÖÓïÑÔ¼òµ¥µÄдÁ˹ØÓÚÎļþ¿½±´µÄ³ÌÐò£¬·¢ÏÖc#ºÍpythonµÄapi¾ªÈ˵ÄÏàËÆ£¬¶ÔÓÚÎļþµÄ²Ù×÷ÕâÁ½ÖÖÓïÑԷdz£µÄ·½±ã¡£¶¼Ã»ÓмÓÒì³£µÄ´¦Àí
C#Ô´´úÂ룺
public static void CopyFile(string source, string destination)
& ......
Ôõôͨ¹ýODBCʹÓÃwxWidgetsÁ¬½ÓAccessÊý¾Ý¿â
1¡¢wxWidgets¿âÖÐODBCµÄ±àÒë
ĬÈϱàÒëʱ£¬ODBC¿âÖеÄûÓе¼³ö£¬ÖÂʹµ÷ÓÃwxDbConnectInf£¬wxDbTableµÈÀຯÊýÊÇʱ³öÏÖÁ´½Ó´íÎóµÄÎÊÌ⣬¹ÊÊ×ÏÈÒª±àÒëODBC¿âΪµ¼³ö Àà¿â£¬ÕâÐèÒªÔÚ"Include"Ŀ¼ÏµÄ"Setup.h"ÖжÔ#define wxUSE_ODBC 0ÉèÖÃΪ1£¬ÖØбàÒë¼´¿É.
2¡¢Êý¾Ý¿âµÄÁ´½ÓÓ ......
ºÅ³ÆxmlhelperµÄÒ»¸öÀà
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Xml;
namespace WebApplication2
{
/// <summary>
/// XMLHelper XMLÎĵµ²Ù×÷¹ÜÀíÆ÷
/// </summary>
public class XMLHelper
{
public X ......
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
this.comboBox2.Items.Clear();
switch(this.comboBox1.SelectedIndex)
  ......