¹ØÓÚAccessÊý¾Ý¿âOleDbDataAdapterµÄÓ÷¨£¿£¿ÇóÖú..

Ô´´úÂëÈçÏ£º
[code=C#]
                        sqlstr   =   "select   *   from   Balancelist   bl   where   card_no   in(select   ca.card_no   from   CurrentAcc   ca   join   DebitCard   dc   on   ca.father_no= ' "   +   cardno     +   " '   union   select   ra.card_no   from   RegularAcc   ra   join   DebitCard   dc   on   ra.card_no= ' "   +   cardno     +   " '   union   select   fa.card_no   from   FinancialAcc   fa   join   DebitCard   dc   on   fa.card_no= ' "   +   cardno   +   " ') ";
                        this.OpenCon();
                        OleDbDataAdapter   adapter   =   new   OleDbDataAdapter(sqlstr,   sqlcon);
                        DataSet   ds   =   new   DataSet();