How to remove underline from link - a href

Use style 

  text-decoration: none;

<a onclick="OpenManageJavaModal();" href="javascript:void(0);" style=" text-decoration: none;">Download Java Setup

                                        </a>

How to download a file from a href without opening it - Direct Downloading

 Use download attribute on a href

 <a title="Digital Signature User Manual" href="Download/DigitalSignature/Signer-UserManual.pdf" style=" text-decoration: none;" download>Download User Manual for Digital Signature

                                        </a>

href:- https://www.w3schools.com/tags/att_a_download.asp

ASP.NET Repeater - Cards Bootstrap

<asp:DataList runat="server" ID="repeaterInbox1" RepeatColumns="3" RepeatDirection="Horizontal">

            <ItemTemplate>

            <div class="card" style="width: 18rem;">

             <div "card-body">

                    <h5 class="card-title"><%#Eval("ApplicationId") %></h5>

                    <h6 class="card-subtitle mb-2 text-muted"><%#Eval("Subject") %>

                        

                    </h6>

                 <p class="card-text" ><%#Eval("FromUserName") %></p>

                 <p class="card-text"><%#Eval("ReceivedDate") %></p>

            </div>

        </div>

                </ItemTemplate>

            </asp:DataList>    

       

How to get select- 0 in dropdown list from database select query as first row - 0th index sql server

 ALTER PROCEDURE [dbo].[RPT_GetCrimeCategory]  

AS

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.

SET NOCOUNT ON;

select LKSCOMPLAINTSOURCE.LookupID, LKSCOMPLAINTSOURCE.Description from dbo.Lookup LKSCOMPLAINTSOURCE WITH(NOLOCK)where  LKSCOMPLAINTSOURCE.LookupCategory = 126

union 

select 0, 'Select'

END

How to convert comma separated column to single value column - comma separate to value

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 

or

 SELECT VALUE FROM string_split('1, 3, 5', ',')

reference:-  https://www.geeksforgeeks.org/how-to-turning-a-comma-separated-string-into-individual-rows-in-sql-server/