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();
Ïà¹ØÎĵµ£º
//¶ÁÈ¡±ê×¼Áбí
private void setModelList()
{
OleDbConnection Connection = null;
&n ......
ÎÊÌâ:
Óжþ¸ö±í
A±í:
id Comment yuyan lanmuid
1 aaaa chinese 1
2 bbbb english 1
3 cccc chinese 2
4 ddddd english 2
B±í:
id lanmu
1 ¹«Ë¾¼ò½é
2 ÁªÏµ·½Ê½
3 ¾Óª·¶Î§
ÔÚɾ³ýB±íµÄÒ»ÐÐÊý¾Ýʱ»á°ÑA±í¹ØÁªIDµÄÊý¾ÝҲɾ³ý,ÇëÎÊÓÐʲôºÃ·½·¨?ÎÒ²»Ïë²Ù×÷2´Îɾ³ýµÄÓï¾ä.
½â¾ö·½ ......
Double action
fingerprint
and access code security door lock for your home,
office or small business. Get modern biometric security at your entry point with
this standard door handle style double action doorlock.
This is the most secure and convenient method in assuring only authorized peo ......
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
Ô ......