TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Farhana Khan
NA
16
48.7k
Displaying a table based on where clause matching the field
Mar 9 2013 5:21 AM
i am having a table named Vacancies the fields here are Category,CompanyName,Designation,etcand another table named JS_Professional_Detail the fields here are FunctionalArea, TotalExperience,keyskills,etc..
I want to display the table of vacancies where the Vacancies.Category shoul match the JS_Professional_Detail.FunctionalArea
The code i tried is
SelectCommand="SELECT Vacancies.Category, Vacancies.CompanyName, Vacancies.RequiredExperience, Vacancies.Designation, Vacancies.RequiredEducation, Vacancies.RequiredAge, Vacancies.RequiredGender, Vacancies.MinimumJoiningTime, JS_Professional_Detail.FunctionalArea FROM Vacancies FULL OUTER JOIN JS_Professional_Detail ON Vacancies.Category = JS_Professional_Detail.FunctionalArea ">
where Vacancies.Category=JS_Professional_Detail.FunctionalArea">
but i need to display the vacany table based on the ctegory of the loginned candidate. based on the username i need to select category and match it with the vacancy and then display it thank you
Reply
Answers (
2
)
the text box item to be displayed in the row wise in the dgv
C# file compilation