How to get open SQL connection of databases

SELECT
DB_NAME(dbid) AS DBName,

COUNT(dbid) AS NumberOfConnections,

loginame AS LoginName,

nt_domain AS NT_Domain,

nt_username AS NT_UserName,

hostname AS HostName

FROM
sys.sysprocesses

WHERE
dbid > 0

GROUP
BY dbid,

hostname,

loginame,

nt_domain,

nt_username

ORDER
BY NumberOfConnections DESC;

How to get values between two tags C#

How to get values between two tags C#


 private void df(string htmlTempate,  out int widthPersonal,  out int widthTimeLineLi)
      {
         widthPersonal = 0;
         widthTimeLineLi = 0;
         Regex regexPersonalInfo = new Regex("<widthpersonalstart>(.*)<widthpersonalend>");
         Regex regexTimelineLi = new Regex("<widthtimelinestart>(.*)<widthtimelinend>");
         var v = regexPersonalInfo.Match(htmlTempate);
         if (v.Groups != null && v.Groups.Count > 0) {
            string _widthPersonal = v.Groups[1].ToString().Trim();
            int.TryParse(_widthPersonal, out widthPersonal);
         }
         var v2 = regexTimelineLi.Match(htmlTempate);
         if (v2.Groups != null && v2.Groups.Count > 0) {
            string _widthTimeLineLi = v2.Groups[1].ToString().Trim();
            int.TryParse(_widthTimeLineLi, out widthTimeLineLi);
         }
      }
Where sample htmlTempate is as follows:
 " dasf afadf af adfadf af <widthpersonalstart> 800 <widthpersonalend>  afafadfa a adf af a adf af a adfa<widthtimelinestart>154<widthtimelinend> adfa f af adf adf ads";

Thanks
Mahesh