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++)
Ïà¹ØÎÊ´ð£º
IsSqlDataBase = 0 'Ö÷Êý¾Ý¿âÀàÐÍ(1=SQL£¬0=AC) '=========================================================================== SqlDatabaseName = "ads365" 'Ö÷Êý¾Ý¿âÃû S ......
ÄÄλ´ó¸çÓÐACCESSÊý¾Ý¿â °¡£¿ ¸øÐ¡µÜÒ»¸ö£¡ °²×°OFFICEʱѡÔñ°²×°ACCESS °²×°OFFICEʱѡÔñ°²×°ACCESS °²×°°ì¹«Èí¼þ£¬Ñ¡Ôñ×Ô¶¨Òå°²×°£¬È»ºóÑ¡ÉÏACCESS¾Í¿ÉÒÔÁË officeÍêÕ ......
±í½á¹¹£º ProductSeriesID ×Ô¶¯±àºÅ ProductSeriesName Îı¾ ProductSeriesRemark ±¸×¢ Ö´ÐÐǰ ProductSeriesID ProductSeriesName ProductSeriesRemark 2 LVϳµ¶ÏµÁÐ LVϳµ¶ÏµÁÐ 3 ÎÙ¸ÖÉá ......
DbgridÁ¬½Óaccess ÏÔʾÊý¾ÝʱÍ϶¯¹ö¶¯ÌõËÀ»ú£¿Ôõô½â¾ö°¡£¿ »úÆ÷Ì«²îÁ˰ɣ¿ ÊDz»ÊÇÄãÊý¾ÝÁ¿Ì«´óÁ˰¡ ÄãÊý¾ÝÉÙһЩ¿´¿´»¹ËÀ»úÂ𣿠Êý¾ÝºÜÉÙ°¡ ¾ÍÒ»Ò³¡£ ÎÒÔÚBCB6ÏÂ×ö¹ý²»ÉÙ DBGRID+ACCESS £¬´ÓÀ´Ã»ÓÐÓöµ½ ......
¸÷λ´óϺ£¬Ð¡µÜÓõÄÊÇADOÁ¬½ÓACCESSÊý¾Ý¿â£¬ÓÃDBGridÏÔʾ²éѯµÄÊý¾Ý£¬ÎÒ×öµÄÊǸöÊý¾Ý²É¼¯ÏµÍ³£¬¸ù¾Ý²»Í¬µÄµØÖ·°ÑÊý¾Ý·ÅÔÚACCESSÊý¾Ý¿âÖв»Í¬µÄ±íÀïÃæ£¬ÏÖÔÚÎÒÏë²éѯijһ¶Îʱ¼äÄÚËùÓбíÄÚµÄÊý¾Ý£¬²¢ÇÒÔÚDBGridÖÐÏÔʾ³ ......