-
Aug 7th, 2020, 11:42 AM
#1
Thread Starter
Enjoy the moment
[RESOLVED] visual studio 2017 query dosnt show result although there is a null value why?
code
Code:
Dim SqlQuery As String = "Select EventID,StartDateTime,EndDateTime,CustomPropertiesXMLData,SmsSent,CustomerName,Remarks,GoogleID,sName,IsPrivate,HairName,HairUserName,
EventTreatment,SmsSent,Remarks,IDUserWeb,HairGroupID From Event
INNER JOIN HairDressers ON Event.sName= HairDressers.HairName
Where GoogleID is Null Or GoogleID=@GoogleID1"
what i am missing?
tnx for any help
salsa
-
Aug 7th, 2020, 01:20 PM
#2
Re: visual studio 2017 query dosnt show result although there is a null value why?
Originally Posted by salsa31
what i am missing?
A FULL and CLEAR explanation of the problem. Why do we still need to drag the relevant information out of you after all this time?
-
Aug 7th, 2020, 01:37 PM
#3
Thread Starter
Enjoy the moment
Re: visual studio 2017 query dosnt show result although there is a null value why?
Originally Posted by jmcilhinney
A FULL and CLEAR explanation of the problem. Why do we still need to drag the relevant information out of you after all this time?
beacuse if googleid is null then i want to display the values in the listview
-
Aug 7th, 2020, 02:01 PM
#4
Re: visual studio 2017 query dosnt show result although there is a null value why?
All you've shown us is a String you created. Need to see more code. Also, an explanation of what happened when you run the code.
-
Aug 7th, 2020, 02:32 PM
#5
Thread Starter
Enjoy the moment
Re: visual studio 2017 query dosnt show result although there is a null value why?
Originally Posted by wes4dbt
All you've shown us is a String you created. Need to see more code. Also, an explanation of what happened when you run the code.
when i run the code there is nothing displayed in the listview while looping through.
i want to check if googleid is null in the event table then inner join with another table and display the results in the listview
-
Aug 7th, 2020, 10:57 PM
#6
Re: visual studio 2017 query dosnt show result although there is a null value why?
Your English seems pretty god but apparently you have no idea what the word "full" means. What database are you using? Have you executed that query in the appropriate management tool? What happened when you did? Show us the original data. Show us the result with no filter. How do we know that the issue is not in the code you used to populate this ListView? Why are you using a ListView instead of a DataGridView in the first place? Start using your head and making an effort to provide all the relevant information and stop making us drag it out of you every single time.
-
Aug 7th, 2020, 11:13 PM
#7
Thread Starter
Enjoy the moment
Re: visual studio 2017 query dosnt show result although there is a null value why?
the problem was in the data
Last edited by salsa31; Aug 8th, 2020 at 01:10 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|