Asp.net Specials

Convert rows to column select * from (   select distinct  lm.LeaveDescription, lb.EmpId, usr.UserId,   usr.UserFirstName +' ' + usr.UserLastName as EmpName, [dbo].[GetBalanceLeave](lb.EmpId, lb.LeaveType) as BalanceLeave       from Leave_BalanceLeave lb       left join  tm_User usr on usr.EmpId=lb.EmpId     inner join Leave_Master lm on lm.LeaveId = lb.LeaveType ) as src pivot (   sum(BalanceLeave)   for LeaveDescription in ([Casual Leave], [Earned Leave], [Sick Leave],[Compensatory Off]) ) as piv;

Send mail in asp.net public bool sendEMail(string leavs, string uniqueCode)         {             try             {                 //string subject = "";                 string emailMsg = "";                 LeavePersistence objLeavePersistence = new LeavePersistence();                 System.Net.Mail.MailMessage Msg = new System.Net.Mail.MailMessage();                 // Msg.From = new MailAddress(currentEmailId);                 Msg.From = new MailAddress(ConfigurationManager.AppSettings["Sender"].ToString());                 DataSet ds = objLeavePersistence.GetEmailContentByEmpId(uniqueCode, "Leave2...

Convert rows to column select * from (   select distinct  lm.LeaveDescription, lb.EmpId, usr.UserId,   usr.UserFirstName +' ' + usr.UserLastName as EmpName, [dbo].[GetBalanceLeave](lb.EmpId, lb.LeaveType) as BalanceLeave       from Leave_BalanceLeave lb       left join  tm_User usr on usr.EmpId=lb.EmpId     inner join Leave_Master lm on lm.LeaveId = lb.LeaveType ) as src pivot (   sum(BalanceLeave)   for LeaveDescription in ([Casual Leave], [Earned Leave], [Sick Leave],[Compensatory Off]) ) as piv;