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
Edil Guardado
NA
32
642
Translate to LINQ
Aug 21 2017 4:00 PM
Hi everyone,
I'm writing a query using VB.NET and I'm having problems in my where clause.
If the value of [
rdbTitleAndSettlement.Checked
] then I want to return all records where app.ss is false, if the value of [
rdbProductAndServices.Checked]
then I want to return all records where app.ss is true, else I want to return app.ss where values are both true and false.
App.SS contains a boolean value.
What Am I doing wrong?
Thanks in advance
Dim
AppInfo = (From app
In
dc.APPLICATIONs
Where
If
(rdbTitleAndSettlement.Checked, app.SS =
False
,
If
(rdbProductAndServices.Checked, app.SS =
True
, app.SS <> Null))
Select
Reader = app.Examiner.Examinname,
Index = app.APPLICATIONSIDNUMBER,
Title_Number = app.TITLENO)
Reply
Answers (
2
)
MS Access Winform convert it to SQL
Can i Have Dropdowns inside the Gridview for a column