Displaying single line validation summary for multiple controls.

protected void Page_Load(object sender, EventArgs e)
{
Page.ClientScript.RegisterOnSubmitStatement(this.GetType(), "mykey", "if (typeof(ValidatorOnSubmit) == \"function\" && ValidatorOnSubmit() == false) alert('Information marked with * must be filled properly.');return false;");
}

Failed to access IIS metabase problem

Possible Cause:-

         When you install IIS AFTER .NET 2.0 framework, the rights of the ASPNET user had not been set correctly.

Resolution
         Repair (Uninstall if repair does not work for you)  .NET Framework 2.0

Simply run the following from command line to reset the IIS registry settings for aspnet user. Usually framework directory for .Net Framework 2.0 resides under C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regiis -i

References:-

• http://support.microsoft.com/?kbid=267904 http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=116989&SiteID=1
• http://support.microsoft.com/kb/555583

Using merge statement in SQL Server 2008

Using MERGE to perform INSERT and UPDATE operations on a table in a single statement.

A common scenario is updating one or more columns in a table if a matching row exists, or inserting the data as a new row if a matching row does not exist. This is usually done by passing parameters to a stored procedure that contains the appropriate UPDATE and INSERT statements. 

With the MERGE statement, you can perform both tasks in a single statement. The following example shows a stored procedure that contains both an INSERT statement and an UPDATE statement. The procedure is then modified to perform the equivalent operations by using a single MERGE statement.

CREATE PROCEDURE dbo.InsertUnitMeasure @UnitMeasureCode nchar(3), @Name nvarchar(25) AS 

BEGIN SET NOCOUNT ON; 

-- Update the row if it exists. 

UPDATE Production.UnitMeasure 

SET Name = @Name WHERE UnitMeasureCode = @UnitMeasureCode 

-- Insert the row if the UPDATE statement failed. 

IF (@@ROWCOUNT = 0 ) 

BEGIN 

INSERT INTO Production.UnitMeasure (UnitMeasureCode, Name) VALUES (@UnitMeasureCode, @Name) END END; GO 

-- Test the procedure and return the results. EXEC InsertUnitMeasure @UnitMeasureCode = 'ABC', @Name = 'Test Value'; 

SELECT UnitMeasureCode, Name FROM Production.UnitMeasure WHERE UnitMeasureCode = 'ABC'; GO 

-- Rewrite the procedure to perform the same operations using the MERGE statement. 

ALTER PROCEDURE dbo.InsertUnitMeasure @UnitMeasureCode nchar(3), @Name nvarchar(25) 

AS 

BEGIN SET NOCOUNT ON;

MERGE Production.UnitMeasure AS target USING (SELECT @UnitMeasureCode, @Name) AS source (UnitMeasureCode, Name) ON (target.UnitMeasureCode = source.UnitMeasureCode) 

WHEN MATCHED THEN 

UPDATE SET Name = source.Name 

WHEN NOT MATCHED THEN 

INSERT (UnitMeasureCode, Name) VALUES (source.UnitMeasureCode, source.Name) OUTPUT deleted.*, $action, inserted.*; END; GO

 -- Test the procedure and return the results.

 EXEC InsertUnitMeasure @UnitMeasureCode = 'ABC', @Name = 'New Test Value'; EXEC InsertUnitMeasure @UnitMeasureCode = 'XYZ', @Name = 'Test Value'; -- Cleanup DELETE FROM Production.UnitMeasure WHERE UnitMeasureCode IN ('ABC','XYZ');

Unable to start T-SQL debugging. could not attach to sql server process in sql server 2008

This error occurs when the debugger cannot register the user with SQL Server 2005 for debugging. 

The most likely cause is the lack of necessary permissions on the SQL 2005 instance. Connecting with system administrator to SQL Server is not sufficient; the Windows login of the Visual Studio user must also be a member of the system administrator role in SQL Server.