Click here to Skip to main content
12,950,272 members (63,677 online)
Rate this:
 
Please Sign up or sign in to vote.
Hello sir/Madam
i have a 1 query regarding my project. my project is to keep record of inward and outward documents. in this i have only one table to keep record for inward and outward. but now i want 2 access the inward document on 1 form in the datagridview and the outward documents on another form. in this table the TransactionType field is available to identify document type. plz give me the answer.
Posted 9-Oct-12 19:27pm
Comments
Maciej Los 12-Oct-12 16:16pm
   
What problem exactly do you have?
What have you done till now?

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

To get only inward documents:
SELECT *
FROM Documents
WHERE TransactionType = Inward

To get only outward documents:
SELECT *
FROM Documents
WHERE TransactionType = Outward


How to fetch data? Use ADO.NET[^]
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 5,829
CHill60 3,460
Maciej Los 2,953
Jochen Arndt 1,975
ppolymorphe 1,820


Advertise | Privacy | Mobile
Web01 | 2.8.170525.1 | Last Updated 12 Oct 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100