Znn3bq.jpeg
²é¿´: 706  |  »Ø¸´: 3

liusing712

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

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

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

» ²ÂÄãϲ»¶

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

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

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µÄ»ØÌû

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µÄ»ØÌû

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µÄ»ØÌû
Ïà¹Ø°æ¿éÌø×ª ÎÒÒª¶©ÔÄÂ¥Ö÷ liusing712 µÄÖ÷Ìâ¸üÐÂ
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] Çóµ÷¼Á288 +5 ioodiiij 2026-04-10 6/300 2026-04-10 09:10 by potatoÃÃ
[¿¼ÑÐ] 083200 305·Ö Çó¶þÂÖµ÷¼Á ²»½ÓÊÜ¿çרҵ +6 Claireyyyy 2026-04-09 6/300 2026-04-10 09:09 by ÎÒÏëÉÏÑо¿Éú.
[¿¼ÑÐ] Ò»Ö¾Ô¸»ªÄÏÀí¹¤´óѧ331·Ö²ÄÁÏÇóµ÷¼Á +5 ÌìÏÂww 2026-04-09 5/250 2026-04-10 08:36 by 5268321
[¿¼ÑÐ] 275Çóµ÷¼Á +6 1624447980 2026-04-08 7/350 2026-04-10 08:06 by ̽123
[¿¼ÑÐ] ²ÄÁÏÀà284µ÷¼Á +32 Ïë»»ÊÖ»ú²»Ïë½âÊ 2026-04-08 37/1850 2026-04-09 23:20 by parmtree
[¿¼ÑÐ] 086003µ÷¼ÁÇóÖú +19 ËÕß®Íò 2026-04-09 20/1000 2026-04-09 20:48 by bljnqdcc
[¿¼ÑÐ] 265Çóµ÷¼Á +4 ·ç˵ËýÔçÍüÁË 2026-04-07 4/200 2026-04-09 13:59 by onlyÖÜ
[¿¼ÑÐ] һ־Ը³¶«´óѧ071000ÉúÎïѧѧ˶³õÊÔ·ÖÊý276Çóµ÷¼Á +3 Ľ¾øcc 2026-04-09 3/150 2026-04-09 09:57 by liuhuiying09
[¿¼ÑÐ] Ò»Ö¾Ô¸±±¾©2£¬²ÄÁÏÓ뻯¹¤308Çóµ÷¼Á +17 ÐܶþÏëÉϰ¶ 2026-04-04 18/900 2026-04-09 09:13 by leyan1127
[¿¼ÑÐ] Çóµ÷¼Á +7 chenxrlkx 2026-04-05 9/450 2026-04-09 09:04 by wj165256
[¿¼ÑÐ] ÍÁľˮÀûר˶276·ÖÇóµ÷¼Á +6 ÎÒÏëÉÏѧ£¡£¡6 2026-04-05 9/450 2026-04-08 17:45 by ËÎС±¦HQ
[¿¼ÑÐ] Ò»Ö¾Ô¸211£¬»¯Ñ§Ñ§Ë¶£¬310·Ö£¬±¾¿ÆÖصãË«·Ç£¬Çóµ÷¼Á +20 ŬÁ¦·Ü¶·112 2026-04-07 21/1050 2026-04-08 14:54 by screening
[¿¼ÑÐ] 287Çóµ÷¼Á +6 Fnhc 2026-04-07 6/300 2026-04-08 10:05 by xingguangj
[¿¼ÑÐ] 293Çóµ÷¼Á +3 ÓÂÔ¶¿â°®314 2026-04-06 3/150 2026-04-07 11:15 by hugr
[ÂÛÎÄͶ¸å] Decision: Revise for Editor»¹»áËÍÉóÂð 100+3 CccccccccFD 2026-04-04 5/250 2026-04-07 10:58 by ±±¾©À³ÒðÈóÉ«
[¿¼ÑÐ] 22408 ×Ü·Ö320£¬Ò»ÆªÂÛÎĶþ×÷£¬Á½¸ö¹úÈý£¬Çóµ÷¼Á +3 Leomulufu 2026-04-04 5/250 2026-04-05 19:04 by chongya
[¿¼ÑÐ] 085500»úеר˶³õÊÔ288Çóµ÷¼Á +3 GZJguo666- 2026-04-05 3/150 2026-04-05 18:06 by jkddd
[¿¼ÑÐ] 313Çóµ÷¼Á +5 º£ÈÕº£ÈÕ 2026-04-04 7/350 2026-04-05 13:58 by imissbao
[¿¼ÑÐ] 400·ÖÇóµ÷¼Á +3 ÞÏÞÎÇÒÄÓÍ· 2026-04-04 3/150 2026-04-04 08:41 by jp9609
[¿¼ÑÐ] 294Çóµ÷¼Á +6 Grey_Ey 2026-04-03 6/300 2026-04-03 20:46 by ÐÀϲ777
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û