Results 1 to 7 of 7

Thread: [RESOLVED] visual studio 2017 query dosnt show result although there is a null value why?

  1. #1

    Thread Starter
    Enjoy the moment
    Join Date
    Feb 2011
    Location
    Barrio Del pilar madrid spain
    Posts
    5,204

    Resolved [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

  2. #2
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    110,297

    Re: visual studio 2017 query dosnt show result although there is a null value why?

    Quote Originally Posted by salsa31 View Post
    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?

  3. #3

    Thread Starter
    Enjoy the moment
    Join Date
    Feb 2011
    Location
    Barrio Del pilar madrid spain
    Posts
    5,204

    Re: visual studio 2017 query dosnt show result although there is a null value why?

    Quote Originally Posted by jmcilhinney View Post
    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

  4. #4
    PowerPoster
    Join Date
    Sep 2005
    Location
    Modesto, Ca.
    Posts
    5,195

    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.

  5. #5

    Thread Starter
    Enjoy the moment
    Join Date
    Feb 2011
    Location
    Barrio Del pilar madrid spain
    Posts
    5,204

    Re: visual studio 2017 query dosnt show result although there is a null value why?

    Quote Originally Posted by wes4dbt View Post
    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

  6. #6
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    110,297

    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.

  7. #7

    Thread Starter
    Enjoy the moment
    Join Date
    Feb 2011
    Location
    Barrio Del pilar madrid spain
    Posts
    5,204

    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
  •  



Click Here to Expand Forum to Full Width