Javascript Adding in Codeside in Asp.net To Check Date Ranges

this.btnLoad.Attributes.Add(“onclick”,”javascript:return CheckDate();”);

<script language=”javascript” type=”text/javascript”>
function CheckDate()
{
var date1=document.getElementById(‘txtFromDate’).value;
var date2=document.getElementById(‘txtToDate’).value;

var datDate1=new Date();
var datDate2=new Date();

datDate1= Date.parse(date1);
datDate2= Date.parse(date2);
datediff = ((datDate2-datDate1)/(24*60*60*1000))
//To Check whether Days are greater than 7 days or not
if(datediff>7)
{
alert(‘You can not select more than 7 days’);
return false;
}
else
{
return true;
}

if(date1 > date2)
{
alert(‘please select proper dates’);
return false;
}
else
{
return true;
}
}
</script>

To add Serial Number in DataGrid

<asp:templatecolumn headertext=”S.No” >
<itemtemplate>
<%# Container.ItemIndex+1 %>
</itemtemplate>
</asp:TemplateColumn>

Transactions in Sql Server

To Check any active transactions which is not commited:

SELECT * FROM sys.dm_tran_session_transactions

/* This work like activity Monitor */

To See all Executing Queries:

sp_who2 active

DBCC inputbuffer(blkby) [To check sp_who2 blkby id executing query or procedure]

declare @table table(spid int,status varchar(50),[login] varchar(100),hostname varchar(100),
blkby varchar(100),dbname varchar(15),command varchar(100),cputime int,diskio int,
lastbatch varchar(100),programname varchar(100),spid1 int,requestid int)
insert into @table
exec sp_who2 active
select spid,status,login,hostname,cputime,command,blkby from @table where ltrim(rtrim(hostname))<>’.’ and dbname<>’master’
and ltrim(rtrim(blkby))<>’.’ and status<>’sleeping’ and isnull(login,”)<>”
order by hostname

DBCC inputbuffer(blkby)