Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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();


Ïà¹ØÎĵµ£º

Access(jet sql)ÓëMS SQL Server(t

 ÍøÉÏËѼ¯£¬±¸ÓÃ
ϱíÁгöÁË ANSI SQL Êý¾ÝÀàÐͺ͵ÈЧµÄ Microsoft Jet Êý¾Ý¿âÒýÇæ SQLÊý¾ÝÀàÐÍ»¹ÓÐËüÃǵÄÓÐЧͬÒå×ÖÒÔ¼° µÈЧµÄ Microsoft SQL ServerÊý¾ÝÀàÐÍ¡£
ANSI SQL
Êý¾ÝÀàÐÍ
Microsoft Access
SQL Êý¾ÝÀàÐÍ
ͬÒå´Ê
Microsoft SQL
Server Êý¾ÝÀàÐÍ
BIT¡¢BIT VARYING
BINARY£¨²Î¼û×¢ÊÍ£©
VARBINARY¡¢ ......

³¤ÄÚÈÝ×Ô¶¯·ÖÒ³µÄʵÏÖ (asp.net C#)

 
public class t3 : System.Web.UI.Page
        {  
                private string str;//×Ö·û
            &n ......

JavaÓëC#Ë­ÊÇÓ¢ÐÛ?


¡¡¡¡»¥ÁªÍøµÄáÈÆð£¬Ê¹µÃPC´Ó²úÒµÖÐÐÄÏò±ßÔµ¹ý¶É£¬¶øÀú¾­20ÓàÄêµÄ·¢Õ¹£¬PCÊг¡Ò²Ç÷ÓÚ±¥ºÍ£¬´½Íö³Ýº®£¬Õâ½Ð¿¿PC³Ô·¹µÄ΢ÈíÈçºÎ²»¼±£¿ÎüÈ¡Á˵±Ä꿪·¢ä¯ÀÀÆ÷Èí¼þµÄ½Ìѵ£¬2000Äê6Ô£¬Î¢ÈíÆô¶¯.Net¼Æ»®£¬½ø¾üÍøÂç·þÎñÊг¡£¬±È¶û·¸Ç´Ä×ÔÐŵسƣº"ÊÀ½çÉÏËùÓÐÒ»Çж¼½«°üÀ¨ÔÚ»¥ÁªÍø·þÎñÖС£" 
¡¡¡¡.NETµÄ˼ÏëÆäʵÊÇÀ´Ô ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ