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

Access ÊÇ/·ñ(ÖØÐ¿ª)

Select a.ID,a.Name,(Select IIF(Count(*)>0,true,false) from a where a.ID=¡®1%¡¯) As HasChild
from a
where a.ID=¡®1¡¯

¼ìË÷³öÀ´ºó£¬°ÑIsOK×Ö¶Îת»»²»³ÉbooleanÀàÐ͵ģ¬ÌáʾSystem.Int16²»ÄÜת»»³ÉSystem.Boolean

ÇëÎÊÈçºÎ½â¾ö£¬Ð»Ð»

HasChildÒâ˼ÊÇÊÇ·ñÓÐIDΪ¡®1¡¯µÄ×ÓÏîÄ¿


ÁíÍâ Cbool(Select IIF(Count(*)>0,true,false) from a where a.ID=¡®1%¡¯)
ÈÔÈ»³ö´í¡£

ÔÚDataTableÖбíÖÐÔ­ÊÇ ÊÇ·ñ ÀàÐ͵ÄÊý¾Ý£¬ÊÇFalse»òÕßTrue£¬µ«ÊÇHasChild×Ö¶ÎÊÇ0
ÈÃϵͳ×ÔÐд¦Àí£¬ÊÔÊÔ
Select a.ID,a.Name,(Select Count(*) from a where a.ID=1)>0 As IsOK
from a
where a.ID=1

ÒýÓÃ
ÈÃϵͳ×ÔÐд¦Àí£¬ÊÔÊÔ
Select a.ID,a.Name,(Select Count(*) from a where a.ID=1)>0 As IsOK
from a
where a.ID=1


°¦£¬ÈÔÈ»

ÄãһֱûÓн²£¬ÄãÊÇÔõÑùÀûÓÃÕâ¸ö½á¹û¼¯µÄ£¬ÔÚC££Öдò¿ª£¿Ìù´úÂë

C# code:

DataRow dataRow = dtrowColl[row]; //È¡³öµÚRowÐеÄÊý¾Ý
Type type = obj.GetType(); //½¨Á¢·´Éä

try
{
String colName = string.Empty;
PropertyInfo pInfo = null;
int count = dtcolColl.Count;
for (int i = 0; i < count; i++)


Ïà¹ØÎÊ´ð£º

asp¸úAccessÊý¾ÝÁ¬½ÓÎÊÌâ¡£

IsSqlDataBase = 0 'Ö÷Êý¾Ý¿âÀàÐÍ(1=SQL£¬0=AC)

'===========================================================================
SqlDatabaseName = "ads365" 'Ö÷Êý¾Ý¿âÃû
S ......

ÇóACCESSÊý¾Ý¿â

      ÄÄλ´ó¸çÓÐACCESSÊý¾Ý¿â °¡£¿
  ¸øÐ¡µÜÒ»¸ö£¡
°²×°OFFICEʱѡÔñ°²×°ACCESS

°²×°OFFICEʱѡÔñ°²×°ACCESS

°²×°°ì¹«Èí¼þ£¬Ñ¡Ôñ×Ô¶¨Òå°²×°£¬È»ºóÑ¡ÉÏACCESS¾Í¿ÉÒÔÁË

officeÍêÕ ......

¸ßÈ˽ø £¡£¡access Êý¾Ý¿âÎÊÌâ~~

±í½á¹¹£º
ProductSeriesID ×Ô¶¯±àºÅ
ProductSeriesName Îı¾
ProductSeriesRemark ±¸×¢

Ö´ÐÐǰ
ProductSeriesID ProductSeriesName ProductSeriesRemark
2 LVϳµ¶ÏµÁÐ LVϳµ¶ÏµÁÐ
3 ÎÙ¸ÖÉá ......

DbgridÁ¬½ÓaccessÍ϶¯¹ö¶¯ÌõËÀ»ú£¿

DbgridÁ¬½Óaccess ÏÔʾÊý¾ÝʱÍ϶¯¹ö¶¯ÌõËÀ»ú£¿Ôõô½â¾ö°¡£¿
»úÆ÷Ì«²îÁ˰ɣ¿

ÊDz»ÊÇÄãÊý¾ÝÁ¿Ì«´óÁ˰¡
ÄãÊý¾ÝÉÙһЩ¿´¿´»¹ËÀ»úÂð£¿

Êý¾ÝºÜÉÙ°¡ ¾ÍÒ»Ò³¡£

ÎÒÔÚBCB6ÏÂ×ö¹ý²»ÉÙ DBGRID+ACCESS £¬´ÓÀ´Ã»ÓÐÓöµ½ ......

¹ØÓÚDelphiÁ¬½ÓACCESSÊý¾Ý¿â²éѯÎÊÌâ

¸÷λ´óϺ£¬Ð¡µÜÓõÄÊÇADOÁ¬½ÓACCESSÊý¾Ý¿â£¬ÓÃDBGridÏÔʾ²éѯµÄÊý¾Ý£¬ÎÒ×öµÄÊǸöÊý¾Ý²É¼¯ÏµÍ³£¬¸ù¾Ý²»Í¬µÄµØÖ·°ÑÊý¾Ý·ÅÔÚACCESSÊý¾Ý¿âÖв»Í¬µÄ±íÀïÃæ£¬ÏÖÔÚÎÒÏë²éѯijһ¶Îʱ¼äÄÚËùÓбíÄÚµÄÊý¾Ý£¬²¢ÇÒÔÚDBGridÖÐÏÔʾ³ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ