ËÄܸæËßÎÒÏÂaccessÖÐ×ֶεĴóСºÍ˵Ã÷Ôõô»ñÈ¡?
ÓеÄ×Ö¶ÎÓо«¶ÈºÍСÊý,Õâ¸öÓÃc#Ôõô¶Á?
ËÄܰïÏÂæ¹þ,ллÁË,ÔÚÏ߸ø·Ö.
ûÈËÖªµÀÂð?
ÔÙ¶¥
²»¶Ô°¡
"˵Ã÷"ÎÒÖªµÀÔõô»ñµÃÁË,ËÄܸæËßÎÒ×ֶδóСÔõô»ñµÃ°¡?
ÕûÊýλºÍСÊýλ
ÎÒÖÕÓÚŪÇå³þÁË,Ìù³öÀ´°É
string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=" + this.textBox1.Text;
OleDbConnection clientConnection = new OleDbConnection(strConnection); //½¨Á¢ACCESSÊý¾Ý¿âÁ¬½Ó
clientConnection.Open();
DataTable SchemaTable = clientConnection.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Columns,
new object[] { null, null, null, null });
System.Data.DataRowCollection drc=SchemaTable.Rows;
//int m=0;
// foreach (DataColumn sd in SchemaTable.Columns)
//{ MessageBox.Show(sd.ColumnName); }
FileStream fs = new FileStream(textBox2.Text + "ÌáÈ¡.txt", FileMode.OpenOrCreate, File
Ïà¹ØÎÊ´ð£º
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
ÄÄλ´ó¸çÓÐACCESSÊý¾Ý¿â °¡£¿
¸øÐ¡µÜÒ»¸ö£¡
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°°ì¹«Èí¼þ£¬Ñ¡Ôñ×Ô¶¨Òå°²×°£¬È»ºóÑ¡ÉÏACCESS¾Í¿ÉÒÔÁË
officeÍêÕ ......
ÎÒÔÚÄ£¿éÀï×Ô¶¨ÒåÁËÒ»¸öº¯Êý:stradd()
¿ÉÊÇÔÚadoquery1.sql.add('select stradd(author) from book');
ʱÌáʾstradd䶨Òå...
Õâ¸öÎÊÌâÓÐʲô°ì·¨¿ÉÒÔ½â¾öµÄÂð? ·Ç³£¸Ð¼¤!
(ÔÚA ......
ÕâÁ½Ììѧϰ¡¶Delphi¼¼Êõ·½°¸±¦µä¡·Ò»ÊéÖеÚÈýÕ¹ØÓÚÓû§µÇ¼·½°¸µÄÀý×Ó£¬ÀûÓõÄÊÇSQl ServerÊý¾Ý¿âʵÏÖÓû§µÇ¼£¬±àÒëÔËÐж¼Ã»ÎÊÌ⣬¸ÃʵÏֵŦÄÜÒ²¶¼ÊµÏֵĺܺ㬵«ÊÇÆæ¹ÖµÄÊÇ£¬·´¸´ÔËÐÐÒ»¶Îʱ¼äºó£¬ÓÐʱÔڹرÕÕû¸ö ......
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......