I'm using Visual Studio 2015 with SQL Server 2014, VB.
I have the command below and would like to add to it but don't know the correct syntax or even where to begin. I would like to add the ability to sense the condition where if DD1 (dropdownlist1) specifies the text "User Activity" then the select will look
for the column [CreatedBy] to be equal to DD4 (dropdownlist4). If DD1 does not equal "User Activity" then this condition is to be disregarded. What I have currently works fine as it stands.
Member
188 Points
352 Posts
Need help with adding sql select options to gridview select command
Jan 16, 2017 03:41 PM|Bulldog248|LINK
I'm using Visual Studio 2015 with SQL Server 2014, VB.
I have the command below and would like to add to it but don't know the correct syntax or even where to begin. I would like to add the ability to sense the condition where if DD1 (dropdownlist1) specifies the text "User Activity" then the select will look for the column [CreatedBy] to be equal to DD4 (dropdownlist4). If DD1 does not equal "User Activity" then this condition is to be disregarded. What I have currently works fine as it stands.
Any help will be greatly appreciated by this novice user. Thanks!
Member
188 Points
352 Posts
Re: Need help with adding sql select options to gridview select command
Jan 17, 2017 12:43 AM|Bulldog248|LINK
I figured it out, the solution is below:
Thanks all!