Znn3bq.jpeg
²é¿´: 708  |  »Ø¸´: 3
µ±Ç°Ö»ÏÔʾÂú×ãÖ¸¶¨Ìõ¼þµÄ»ØÌû£¬µã»÷ÕâÀï²é¿´±¾»°ÌâµÄËùÓлØÌû

liusing712

ľ³æ (СÓÐÃûÆø)

[ÇóÖú] C#2010ºÍACCESS2010Êý¾Ý¶ÁдÎÊÌ⣿ ÒÑÓÐ1È˲ÎÓë

³ÏÐÄÇë½Ì¸÷λ´óÉñÒ»¸öÎÊÌ⣬ĿǰÔÙ×öÒ»¸ö³ÌÐò£¬ÓÉÓÚÊý¾ÝÁ¿Ì«´ó£¬ÏëҪͨ¹ýACCESS2010À´ÊµÏÖ¡£ÎÊÌâÃèÊö£º¶ÁÈ¡¸ø¶¨ACCESS2010ÖеÄÊý¾Ý---¸³Öµ¸ø³ÌÐòÖеļ¸×é±äÁ¿---ͨ¹ýC#2010Ëù±àÖÆµÄ³ÌÐò½øÐмÆËã---½«¼ÆËã½á¹ûÊä³öµ½excel»òÕßACCESSÖС£Çë¸÷λ´óÏÀ¸ø¸öÖ¸µ¼£¬Èç¹ûÓÐʵÀý´úÂëÄǾ͸üºÃÁË£¨¼òµ¥Ò»µãµÄ¶¼ÐУ©¡£¹òлÁË£¡
»Ø¸´´ËÂ¥

» ²ÂÄãϲ»¶

» ±¾Ö÷ÌâÏà¹Ø¼ÛÖµÌùÍÆ¼ö£¬¶ÔÄúͬÑùÓаïÖú:

×ÔÖúÕߣ¬ÌìÖúÖ®¡£
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

liusing712

ľ³æ (СÓÐÃûÆø)

ÒýÓûØÌû:
2Â¥: Originally posted by me_yu at 2015-03-11 23:00:48
Õâ¸öÌ«¼òµ¥ÁË
2¡¢ACCESS2007(*.accdb)
private void Form1_Load(object sender, EventArgs e)
{
            string ConStr = string.Format(@"Provider=Microsoft.ACE.OLEDB.12.0;Data source='{0}\tes ...

²»ºÃÒâ˼£¬ÔÙÎÊһϹþ¡£Æäʵ¾ÍÊÇÕâ¸öÏëÔõô´¦Àí¾ÍÔõô´¦ÀíÕâÒ»²½ÎÒ²»»á°¡¡£
±ÈÈçÎÒ¶¨ÒåÁËÒ»¸ö±äÁ¿double[] p£»ÎÒÒª½«Êý¾Ý¿âÖÐpËù¶ÔÓ¦µÄÄÇÒ»ÁÐËùÓÐÊý¾ÝÒÀ´Î¸³¸øp; ¼ÙÉèpÔÚÊý¾Ý¿âÖÐÊÇ×Ö¶ÎÃû½Ð¡°Ñ¹Á¦¡±£¬Î»ÓÚÊý¾Ý¿âµÚÈýÁУ¬×ܹ²ÓÐ30000¸öÊý¾Ý.»¹ÓоÍÊÇÊý¾Ý¿â¶ÁÈ¡µ½datasetÖÐÊÇʲôÐÎʽ£¬ºÍÊý¾Ý¿âÖÐÊÇÒ»ÑùµÄÂð£¿
Âé·³ÄúÁË£¡
×ÔÖúÕߣ¬ÌìÖúÖ®¡£
3Â¥2015-03-12 09:38:55
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
²é¿´È«²¿ 4 ¸ö»Ø´ð

me_yu

ľ³æ (ÕýʽдÊÖ)

¡¾´ð°¸¡¿Ó¦Öú»ØÌû

¸Ðл²ÎÓ룬ӦÖúÖ¸Êý +1
Õâ¸öÌ«¼òµ¥ÁË
2¡¢ACCESS2007(*.accdb)
private void Form1_Load(object sender, EventArgs e)
{
            string ConStr = string.Format(@"Provider=Microsoft.ACE.OLEDB.12.0;Data source='{0}\test.accdb'", Application.StartupPath);
            OleDbConnection oleCon = new OleDbConnection(ConStr);
            OleDbDataAdapter oleDap = new OleDbDataAdapter("select * from youtable", oleCon);
            DataSet ds = new DataSet();
            oleDap.Fill(ds, "±íÃû";
            //Êý¾ÝÈ¡µ½datasetºó¸ÃÔõô´¦Àí¾ÍÔõô´¦Àí
            //´¦ÀíÍêºóÔÙÓÃcreateÓï¾ä½¨Á¢ÐÂ±í¼°Ñ­»·datasetÊý¾Ý¼¯Ò»ÐÐÒ»ÐÐinsertµ½Ð½¨µÄ±í¾ÍºÃÁË
            //this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
            oleCon.Close();
            oleCon.Dispose();
}
Ìý£¬¼Å¾²µÄÒ¹ÀÌïÒ°ÀïÍÜÉùºÍ³æÃù£¬ºÃ²»»¶¿ì£¡
2Â¥2015-03-11 23:00:48
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

me_yu

ľ³æ (ÕýʽдÊÖ)

¡¾´ð°¸¡¿Ó¦Öú»ØÌû

¡ï ¡ï ¡ï ¡ï ¡ï
liusing712: ½ð±Ò+5, ¡ï¡ï¡ï¡ï¡ï×î¼Ñ´ð°¸, ·Ç³£¸Ðл¡£ 2015-03-13 09:28:19
ÒýÓûØÌû:
3Â¥: Originally posted by liusing712 at 2015-03-12 09:38:55
²»ºÃÒâ˼£¬ÔÙÎÊһϹþ¡£Æäʵ¾ÍÊÇÕâ¸öÏëÔõô´¦Àí¾ÍÔõô´¦ÀíÕâÒ»²½ÎÒ²»»á°¡¡£
±ÈÈçÎÒ¶¨ÒåÁËÒ»¸ö±äÁ¿double[] p£»ÎÒÒª½«Êý¾Ý¿âÖÐpËù¶ÔÓ¦µÄÄÇÒ»ÁÐËùÓÐÊý¾ÝÒÀ´Î¸³¸øp; ¼ÙÉèpÔÚÊý¾Ý¿âÖÐÊÇ×Ö¶ÎÃû½Ð¡°Ñ¹Á¦¡±£¬Î»ÓÚÊý¾Ý¿âµÚ ...

CODE:
using System; using System.Collections.Generic; using System.Text; using System.Data.OleDb; using System.Data;  namespace Demo20150312 {     class Program     {         static void Main(string[] args)         {             using (OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Test.accdb"))             {                 con.Open();                 using (OleDbCommand cmd = new OleDbCommand("select ѹÁ¦ from TEST_TABLE", con))                 {                     DataTable dt = new DataTable();                     dt.Load(cmd.ExecuteReader());                     double[] p = new double[dt.Rows.Count];                     int i = 0;                     foreach (DataRow item in dt.Rows)                     {                         string yali = item["ѹÁ¦"].ToString();                         p[i++] = Convert.ToDouble(yali);                         Console.WriteLine(yali);                     }                     Console.WriteLine("done!");                 }             }             Console.ReadKey();         }     } }

» ±¾Ìû¸½¼þ×ÊÔ´Áбí

  • »¶Ó­¼à¶½ºÍ·´À¡£ºÐ¡Ä¾³æ½öÌṩ½»Á÷ƽ̨£¬²»¶Ô¸ÃÄÚÈݸºÔð¡£
    ±¾ÄÚÈÝÓÉÓû§×ÔÖ÷·¢²¼£¬Èç¹ûÆäÄÚÈÝÉæ¼°µ½ÖªÊ¶²úȨÎÊÌ⣬ÆäÔðÈÎÔÚÓÚÓû§±¾ÈË£¬Èç¶Ô°æÈ¨ÓÐÒìÒ飬ÇëÁªÏµÓÊÏ䣺xiaomuchong@tal.com
  • ¸½¼þ 1 : Demo.zip
  • 2015-03-12 15:17:42, 236.79 K
Ìý£¬¼Å¾²µÄÒ¹ÀÌïÒ°ÀïÍÜÉùºÍ³æÃù£¬ºÃ²»»¶¿ì£¡
4Â¥2015-03-12 15:19:09
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] ²ÄÁÏÀà284µ÷¼Á +34 Ïë»»ÊÖ»ú²»Ïë½âÊ 2026-04-08 41/2050 2026-04-10 11:51 by wp06
[¿¼ÑÐ] Çóµ÷¼Á +16 ÐܶþÏëÉϰ¶ 2026-04-04 16/800 2026-04-10 11:24 by may_ÐÂÓî
[¿¼ÑÐ] 280Çóµ÷¼Á +11 Àîrien 2026-04-04 11/550 2026-04-10 10:11 by 314126402
[¿¼ÑÐ] Ò»Ö¾Ô¸211£¬»¯Ñ§Ñ§Ë¶£¬310·Ö£¬±¾¿ÆÖصãË«·Ç£¬Çóµ÷¼Á +16 ŬÁ¦·Ü¶·112 2026-04-06 18/900 2026-04-10 10:06 by may_ÐÂÓî
[¿¼ÑÐ] 266Çóµ÷¼Á +28 ÑôÑôÍÛÈû 2026-04-07 28/1400 2026-04-10 10:02 by cyh¡ª315
[¿¼ÑÐ] 307Çóµ÷¼Á +5 tzq94092 2026-04-10 5/250 2026-04-10 08:51 by yongzhesheng
[¿¼ÑÐ] Çóµ÷¼Á +15 ÕÅzic 2026-04-05 16/800 2026-04-10 08:12 by kangsm
[¿¼ÑÐ] 296Çóµ÷¼Á +6 Íô£¡£¿£¡ 2026-04-09 6/300 2026-04-09 20:49 by lbsjt
[¿¼ÑÐ] 349ѧ¿Æ»¯Ñ§045106Çóµ÷¼Á£¬»¯Ñ§Àà¶¼¿ÉÒÔ +8 ±£ºÃ¶®¶® 2026-04-08 8/400 2026-04-09 14:03 by xulei3024
[¿¼ÑÐ] ²ÄÁϵ÷¼Á +14 Ò»ÑùYWY 2026-04-05 15/750 2026-04-09 13:36 by ¹ÊÈË??
[¿¼ÑÐ] 070300»¯Ñ§Ñ§Ë¶311·ÖÇóµ÷¼Á +18 Áº¸»¹óÏÕÖÐÇó 2026-04-04 20/1000 2026-04-09 11:18 by ßÕßÕßÕßÉßÉßÉ
[¿¼ÑÐ] »úеר˶273ÇëÇóµ÷¼Á +6 ¸ýÉêÈÉÉê 2026-04-07 6/300 2026-04-08 22:41 by bljnqdcc
[¿¼ÑÐ] 283Çóµ÷¼Á +19 A child 2026-04-04 19/950 2026-04-08 14:26 by xingguangj
[¿¼ÑÐ] 313Çóµ÷¼Á +3 Ê®Áùʰ½ 2026-04-07 3/150 2026-04-07 23:20 by lbsjt
[¿¼ÑÐ] 298Çóµ÷¼Á +4 ²ÐºÉÐÂÁø 2026-04-07 4/200 2026-04-07 23:02 by lbsjt
[¿¼ÑÐ] ¿¼Ñе÷¼Á +3 WwwwwwwÍÛ 2026-04-06 3/150 2026-04-06 20:55 by lbsjt
[¿¼ÑÐ] ²ÄÁϵ÷¼Á +5 СÁõͬѧ߹߹ 2026-04-06 5/250 2026-04-06 18:34 by sherry_1901
[¿¼ÑÐ] 285Çóµ÷¼Á +5 mapmath 2026-04-06 6/300 2026-04-06 17:18 by À¶ÔÆË¼Óê
[¿¼ÑÐ] Ò»Ö¾Ô¸ÄÏÅ©090401£¬268£¬Çóµ÷¼Á +5 һľÄñÈ» 2026-04-04 5/250 2026-04-04 17:07 by babysonlkd
[¿¼ÑÐ] Çóµ÷¼Á +3 ũҵ¹¤³ÌÓëÐÅÏ¢¼ 2026-04-04 3/150 2026-04-04 12:19 by Éá¶øºóµÃ
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û