Hi, I would like to Upgrade the Publish page into latest version(Publish Web) in Visual Studio 2012. I still have the older page to publish my Application. How do i upgrade this. Please let me know.

Hi, My solution have 3 layers (Business class project, Data Class Project and Application (ASP.Net, C#)). I can build Business and Data Class project, but when i build solution my Visual studio freezes and not showing any result in Output. after 5 or 10 minutes will get pop up message "Visual studio stopped working" and restart visual studio. I tried the below solutions to sort this issue, but nothing did help me. 1) Deleted files from Temporary folders 1.1)C:\Users\\AppData\Local\Temp\Temporary ASP.NET Files 1.2)C:\Users\\AppData\Local\Microsoft\WebsiteCache 1.3) C:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files 1.4) C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Temporary ASP.NET Files 2) Repair Visual studio 3) Uninstall and Re-Install Visual studio 4) Delete the .SUO file I Can build this solution in my Personnel laptop(Windows 7) but in my workstation(Windows 8) have this problem. I am using Visual Studio 2012. Please help me to sort this issue.

I want to pass multiple parameters ( ID and Name ) to the autocomplete script. It works if i put only one parameter but not working with two parameters. This is not working

<script type="text/javascript">function BindEvents() {
$(document).ready(function () {
$("#<%=txtID.ClientID%>")+$("#<%=txtName.ClientID%>").autocomplete('../../Common_Search/Employee.ashx');
});
}

</script>

This is working

<script type="text/javascript">
function BindEvents() {
$(document).ready(function () {
$("#<%=txtID.ClientID%>").autocomplete('../../Common_Search/Employee.ashx');
});
}
</script>

I want to send Email to Many Users from One Email Address. I did configured the Database Mail. After Scheduled this Job, It is sending Emails to some users and failing to some users. Following are the Error Message am getting from the Log. 1)The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2014-12-08T16:01:56). Exception Message: Cannot send mails to mail server. (The operation has timed out.). 2)The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2014-12-08T16:02:05). Exception Message: Cannot send mails to mail server. (Failure sending mail.). I am getting this Time Out Message even after Updating the Time Out to 60 Sec

Some Users are receiving Emails and some not, below is the Error message from event log. "The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2014-11-11T06:09:35). Exception Message: Cannot send mails to mail server. (The operation has timed out.)." What could be the problem? How to sort this?

Some Users are receiving Emails and some not, below is the Error message from event log. "The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2014-11-11T06:09:35). Exception Message: Cannot send mails to mail server. (The operation has timed out.)." What could be the problem? How to sort this?

32:10 means 32 Hours and 10 Minutes, I want to find this Total Hours Difference in Hour and Minutes

I want to calculate Total Time difference like this eg: 32:10 - 26:10 = 06:00 How to do this with the sql query?

This sql not getting the correct Out put, it shows like this Dt MaxDT MinDT 2014-01-01 2014-01-01 00:00:00.000 2014-01-01 00:00:00.000 2014-01-04 2014-01-04 00:00:00.000 2014-01-04 00:00:00.000 2014-01-05 2014-01-05 00:00:00.000 2014-01-05 00:00:00.000 2014-01-06 2014-01-06 00:00:00.000 2014-01-06 00:00:00.000 2014-01-10 2014-01-10 00:00:00.000 2014-01-10 00:00:00.000 I want to get it like this way RowNumber StartDate EndDate 1 2014-01-01 00:00:00.000 2014-01-01 00:00:00.000 2 2014-01-04 00:00:00.000 2014-01-06 00:00:00.000 3 2014-01-10 00:00:00.000 2014-01-10 00:00:00.000

This is my table RowNumber TestDate 1 2014-01-01 00:00:00.000 2 2014-01-04 00:00:00.000 3 2014-01-05 00:00:00.000 4 2014-01-06 00:00:00.000 5 2014-01-10 00:00:00.000 I want to Make Out Put Like this RowNumber StartDate EndDate 1 2014-01-01 00:00:00.000 2014-01-01 00:00:00.000 2 2014-01-04 00:00:00.000 2014-01-06 00:00:00.000 3 2014-01-10 00:00:00.000 2014-01-10 00:00:00.000

I Cannot set it as Identity column, because based on the District ID should get the Next Rec_ID

Rec_ID Rec_Name Dist_ID 1 A 1 2 B 1 1 AA 2 2 AB 2 3 C 2 How can i write a Insert sql script for this table, eg: i should insert Rec_ID 3 while inserting Record for Dist_ID 1 and also Rec_ID 4 for Dist_ID 2, Suppose if many users inserting from different places, how to handle this situation. what is the best method? I have following 2 ideas, which is right idea or is there any other method to implement this 1) Select Max(Rec_ID) for the district, suppose if 2 people inserting at the same time will be a issue. 2) Put a Lock in the Stored Procedure

I want to insert the sql Error Message into the Error Table and return the user defined Error Message. Below is my code, if it sucess then Return Null else it should return Error message like 'Error on Inserting' at the same time it should save the actual error details in the Error table Create PROCEDURE addTitle AS SET NOCOUNT ON BEGIN TRY BEGIN TRANSACTION Create table #temp(ID int,fName varchar(20)) Insert into #temp(ID,fName)values('a1','test') COMMIT TRANSACTION END TRY BEGIN CATCH ROLLBACK TRANSACTION Insert into apl_Error(Error_Desc,Error_Date) select RTrim(LTrim(Cast(ERROR_STATE() as CHAR(10))))+','+ RTrim(LTrim(Cast(ERROR_LINE() as CHAR(5))))+','+ERROR_PROCEDURE()+','+ERROR_MESSAGE(),GETDATE() END CATCH Return

I want to Add Number of Days with the Date object and get the New Date. i used this method to add Days FromDate.setDate(FromDate.getDate() +12) But this method is not working, if the month is February EG: if the From Date is 20-02-2013, if i add 12 Days with this date, will get result as 01-03-2013. Is there any other method to add days and check its leap year or not

EmpID Leave_Year Taken Credit Balance 435 2014 0 22 22 435 2013 10 22 12 435 2012 24 22 0 435 2011 20 22 2 435 2010 23 22 0 435 2009 21 22 1 I want to Update this table Balance column value with the Next row Balance column value eg: Leave_Year 2011, Balance value (2) Update with Leave_Year 2012 Balance Value (0) 0 - 2 = -2 should get in 2011 Balance column, use with this where condition, where Next row (2012) Taken>0 How to write Update sql for this

How to Recover Deleted rows from sql 2000 Database using with some period parameter eg: from 01/01/2012 - 20/05/2012 Display all deleted records on this period.

I want to calculate the difference between two dates and the result should get in Year,Month and Date format. While calculating the difference it should take the end date also. eg: 01/09/2012 - 30/09/2012 = 1 Month 01/02/2012 - 29/02/2012 = 1 Month 01/08/2012 - 10/08/2012 = 1 Month and 10 Days 01/01/2012 - 31/12/2012 = 1 Year 01/01/2012 - 10/01/2013 = 1 Year and 10 days

Is it possible to make the sql dynamic, instead of hard code. eg: Day, Night some time the master table have more records.

I have two tables "CM_Master" and "CM_Details" and the sample records are below, i want to make a report like under the result. How can i join two tables and create table heading like the shift names in CM_Master table. CM_Master ShiftID ShiftName 1 Day 2 Night CM_Details CM_ID Site_ID Level_ID ShiftID Number 1 1 1 1 5 2 1 2 1 4 3 1 1 2 2 4 2 2 2 8 Result Site Level Day Night 1 1 5 2 1 2 4 0 2 2 0 8

I want to calculate the difference between two dates in Year, Month and Days Format. It should check the Leap Year also. Eg: 01/02/2012 - 29/02/2012 should get result as 1 Month 01/02/2012 - 30/03/2012 - Result should be 1 Month and 30 Days.