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)
-