نیما حتمی
یک شنبه 01 خرداد 1390, 16:27 عصر
با سلام
من دو جدول رو با هم join کردم اررور زیرو می ده:
70210
اینم کدم:
SqlDataAdapter r = new SqlDataAdapter(@"select * from EmissionDoc inner join AccCoding On EmissionDoc.AccCode=AccCoding.AccCode
where (ISNULL(AccCode, '') = '' or ISNULL(Center1, '') = '' or ISNULL(Center2, '') = '' or ISNULL(Center3, '') = '' or ISNULL(DocAccount, '') = '' or ISNULL(ArzKind, '') = '' or ISNULL(Amount, '') = '' or (ISNULL(Debtor, '') = '' And ISNULL(Creditor, '') = '') or ISNULL(NumPey, '') = '' or ISNULL(Datepey, '') = '' or ISNULL(NumOrder, '') = '' )
and " + condition, connect);
من دو جدول رو با هم join کردم اررور زیرو می ده:
70210
اینم کدم:
SqlDataAdapter r = new SqlDataAdapter(@"select * from EmissionDoc inner join AccCoding On EmissionDoc.AccCode=AccCoding.AccCode
where (ISNULL(AccCode, '') = '' or ISNULL(Center1, '') = '' or ISNULL(Center2, '') = '' or ISNULL(Center3, '') = '' or ISNULL(DocAccount, '') = '' or ISNULL(ArzKind, '') = '' or ISNULL(Amount, '') = '' or (ISNULL(Debtor, '') = '' And ISNULL(Creditor, '') = '') or ISNULL(NumPey, '') = '' or ISNULL(Datepey, '') = '' or ISNULL(NumOrder, '') = '' )
and " + condition, connect);