Remove blank rows from column in sql select query

Use distinct keyword and null or 'xyz' (blank values)

select distinct value as crimecategory, lu.Description from Investigation iv cross apply string_split(iv.crimecategory,',') Left join Lookup lu on value = lu.LookupID where (CrimeCategory != '' OR CrimeCategory != NULL) AND BranchId=30 

 reference:- https://stackoverflow.com/questions/10912237/sql-select-distinct-rows-and-ignore-row-if-blank

https://stackoverflow.com/questions/30284503/how-to-remove-blank-rows-from-sql-result-set

Select stored procedure- select query to XML

 ALTER PROCEDURE [dbo].[SSP_AllState] --1  

  

  

AS   

BEGIN  

SELECT CAST((SELECT [StateId]  

      ,[StateName]  

      ,[StateNameInLocal]  

      ,[StateCode]  

      ,[IsActive]  

      ,[CreatedBy]  

      ,[CreatedDate]  

      ,[UpdatedBy]  

      ,[UpdatedDate]  

If telerik controls are not working -asp.net

 add script manager

<asp:ScriptManager ID="ScriptManager1" runat="server" AsyncPostBackTimeout="300" EnablePartialRendering="True" EnablePageMethods="true" ScriptMode="Release">

https://docs.telerik.com/devtools/aspnet-ajax/controls/multiselect/getting-started

Telerik multi select - telerik combobox- asp.net

 https://docs.telerik.com/devtools/aspnet-ajax/controls/multiselect/getting-started

https://demos.telerik.com/aspnet-ajax/combobox/examples/functionality/checkboxes/defaultcs.aspx

https://www.telerik.com/forums/multiple-selection-of-radcombobox

How to resolve the error - This site can’t provide a secure connection - ASP.NET -WebApp

 

This site can’t provide a secure connection

localhost sent an invalid response.

• Try running Windows Network Diagnostics.

ERR_SSL_PROTOCOL_ERROR

https://stackoverflow.com/questions/63113831/this-site-can-t-provide-a-secure-connection-enable-ssl-configure-for-visual-st

Or Open Visual Studio

>Right click on web app

>Go to properties and 

>Click on web

> Than change the project url to 40516 or 44337,44338,44339, ..... 44399