c#²Ù×÷accessÊý¾Ý¿â
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
namespace AddressList
{
public partial class FrmAccessUse : Form
{
public FrmAccessUse()
{
InitializeComponent();
}
#region µ÷ÓÃaccess±ê×¼·½·¨
// using System.Data.OleDb;
// using System.Data;
// Á¬½Ó×Ö·û´®£ºString connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=product.mdb";
// ½¨Á¢Á¬½Ó£ºOleDbConnection connection = new OleDbConnection(connectionString);
// ʹÓÃOleDbCommandÀàÀ´Ö´ÐÐSqlÓï¾ä£º
// OleDbCommand cmd = new OleDbCommand(sql, connection);
// connection.Open();
// cmd.ExecuteNonQuery();
#endregion
#region Á¬½Ó×Ö·û´®
//string strcon = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\³ÌÐòÊé¼®Èí¼þ\c#³ÌÐò´úÂë\accessÊý¾Ý¿â²Ù×÷\addressList.mdb"; //¾ø¶Ô·¾¶
string strcon = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Environment.CurrentDirectory+"\\addressList.mdb"; //Ïà¶Ô·¾¶
#endregion
#region ²éѯ
private void tsbQuery_Click(object sender, EventArgs e)
{
query();
}
#endregion
#region ²éѯÓï¾ä
private void query()
{
try
{
gridView1.Columns.Clear();
OleDbConnection connet1 = new OleDbConnection(strcon);
string sql = "select * from new1";
connet1.Open();
OleDbDataAdapter myadapter = new OleDbDataAdapter();
DataSet ds = new DataSet();
myadapter.SelectCommand = new OleDbCommand(sql, connet1);
myadapter.Fill(ds);
gridControl1.DataSource = ds.Tables[0];
connet1.Close();
Ïà¹ØÎĵµ£º
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 ......
µÚÒ»ÖÖ·½·¨£º
<?php
class Access{
function getConn(){
$conn = @new COM("ADODB.Connection") or die ("ADOÁ¬½Óʧ°Ü!");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath(__IMP ......
½ñÌìÔÚÐÞ¸ÄÒÔÇ°¿ª·¢µÄÒ»¸öÍøÕ¾µÄʱºòÓöµ½Ò»¸öÎÊÌ⣬ÒòΪ¹¦ÄܵÄÐèÒª£¬ÒÔÇ°µÄÒ»¸öÊý×ÖÀàÐÍ×ֶθıäΪÎı¾×ֶΣ¬ÒòΪÕâ¸ö×Ö¶ÎÐèÒª°üº¬¶à¸öÀà±ðµÄID£¬ÒÔÇ°Õâ¸ö×Ö¶ÎÖ»¶ÔÓ¦Ò»¸öIDµÄ¡£
ÍøÕ¾ÊÇASP VBÓïÑԵģ¬Êý¾Ý¿âʹÓõÄÊÇAccess
ÐÞ¸ÄÊý¾ÝÀàÐÍÖ®ºóǰ̨µÄ²éѯ´úÂë¾Í²»ÄÜʹÓÃÖîÈçxID=1ÕâÖÖÌõ¼þÁË¡£ÓÉÓÚÏÖÔÚ¸Ã×ֶαäΪÎı¾ÀàÐ ......
public class t3 : System.Web.UI.Page
{
private string str;//×Ö·û
&n ......
´ó¸ÅµÄ¹¦ÄܾÍÊÇÈÕÆÚÌáÐÑ£¬°ÑͨѶ¼ºÍÈÕÆÚÌáÐÑÏà½áºÏ¡£
ÌáÐÑ·½Ãæ×öµÄºÜ²î£¬¼¼ÊõÓÐÏÞ¡£
Ƥ·ôÓõÄÊÇSkin++
µÚÒ»´Î·¢£¬µ«Ö®Ç°Ð޸Ĺý¼¸´Î£¬Ä¿Ç°°æ±¾0.7
×öÕâ¸ö¶«Î÷ÍêÈ«ÊÇÒòΪÎÒ¸öÈËÐèÒª¡£
ÊÇÒ»¸ö¶àÓû§µÄ¹¤¾ß¡£
ÓÐ×Ô¶¯Éý¼¶¹¦ÄÜ¡£
Ó¦Ó÷¶Î§ºÜÕ¡£
ÏÂÔصØÖ·£ºhttp://www.cppblog.com/Files/pencil/GoodFriendV0.7.rar
Ô ......