ÎÒ×öµÄÊÇÒ»¸öDLL£¨MFC£©£¬Æô¶¯ÁËÒ»¸öỊ̈߳¬Ï̺߳¯ÊýÖзâ×°ÁËÏà¹ØµÄÊý¾Ý¿â²Ù×÷¡£
³õʼ»¯ole³É¹¦¡£
Á¬½ÓÊý¾Ý¿â³É¹¦¡£
µ«ÊÇrecordset openµÄʱºò±¨´í£¬MSJETOLEDB40.DLL ¶ÑÕ»Òç³ö¡£
Çë¸ßÊÖÃǰïæ·ÖÎöһϣ¬Ôõô½â¾ö¡£
·ÖÊýÉÙ¿ÉÒÔ¼ÓµÄ....
//Ï̺߳¯Êý
unsigned __stdcall ThreadOperateDB(LPV ......
ÎÒÏë¸ù¾ÝËù¸øµÄÄÚÈݲéѯһ¸öÊý¾Ý¿âÀïÄÚÈÝËùÔÚµÄÁÐ!
Ìõ¼þ:
¿ÉÄÜÊǶàÕűí,²¢²»ÖªµÀ±íÖнṹ.
Òª²éѯÿÕűíÖÐÊÇ·ñÓÐÕâÌõÐÅÏ¢,È»ºóÔÚ²é³öËûµÄÁÐÃûºÍ±íÃû.
¾ÙÀý˵Ã÷ÄãµÄÒªÇó
ÒªÓÃVBA´úÂëÀ´½â¾ö£¬ËÙ¶ÈÒ²²»»á¿ì
ͨ¹ýϵͳ±í»òÕßdao.tabledef£¬µÃµ½ËùÓбíÃû¡£
È»ºóͨ¹ ......
string sql =" select vm.[units],sum(ts.[Dealmoney]),sum(vm.[onbaoxiao]),sum(vm.[nianbaoxiao]) from VehicMessage vm LEFT JOIN TecSystem ts on vm.card=ts.card group by vm.[card],vm.[units]";
OleDbCommand com = new OleDbCommand(sql);
OleDbDataReader reader = com.ExecuteRead ......
ÒѾ½«Êý¾ÝÀàÐÍÉèÖÃΪ±¸×¢ÀàÐÍ
C# code:
FCKeditor1µÄÖµÈçÏ£º
string strcode="ertyrety<br />";
strcode+="tyit<br />";
strcode+="<input src="/B2C/UploadFiles/f2994d0cd90410525423500467de4a66.jpg" width="300" height="200" &q ......
ÎÒÁ¬½ÓÁËÁ½¸öÊý¾Ý¿â£¬mssql£¬access
ÈçºÎÔÚͬһ¸ö°´Å¥Ï²Ù×÷Á½¸öÊý¾Ý¿âµÄ±í
±ÈÈ磬ÎÒͨ¹ý¸´ÔÓµÄsqlÓï¾ä´ÓmssqlÊý¾Ý¿â¶à¸ö±íÈ¡µÃÁËÊý¾Ý
È»ºó²åÈëaccessÊý¾Ý¿âijһ¸ö±íÖÐ
SQL code:
SQL SERVER ºÍACCESSµÄÊý¾Ýµ¼Èëµ¼³ö
³£¹æµÄÊý¾Ýµ¼Èëµ¼³ö£º
ʹÓÃDTSÏòµ¼Ç¨ÒÆÄãµÄAccessÊý¾Ýµ½SQL Server£¬Äã¿ÉÒÔÊ ......
<?
$myDB=odbc_connect("Dogs","","");
$query="select name,weight from dog_list";
$result=odbc_do($myDB,$query);
while(odbc_fetch_row($result)){
print odbc_result($result,"name");
& ......