Tech
Forums
Jobs
Books
Events
Videos
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
2
Answers
Translate to LINQ
Edil Guardado
7y
226
1
Reply
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)
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
MS Access Winform convert it to SQL
Can i Have Dropdowns inside the Gridview for a column