Sunday, March 20, 2005

sql server db design diagram move

This step-by-step article describes how to move a database diagram that was created in SQL Server Enterprise Manager. Database diagrams are contained in the dtproperties system table of the database.
How to Move a Database Diagram in SQL Server 7.0 and 2000
1.
Expand the Databases folder.
2.
Right-click the database that contains the diagram that you want to copy, click All Tasks, and then click Export Data
3.
In the Data Transformation Services Import/Export Wizard, click Next.
4.
On the Choose a Data Source page, click Next.
5.
On the Choose a Destination page, select the server and database to which you want to transfer the database diagram. Click Next.
6.
On the Specify Table Copy or Query page, click to select the Use a Query to specify the database to transfer check box, and then click Next.
7.
On the Type SQL Statement page, type the following line, and then click Next:select * from dtproperties

How to set focus on control in asp.net

How to set focus on control in asp.net

private void SetFocus(Control ctrl) // Define the JavaScript function for the specified control. string focusScript = "script language="'javascript'"" + "document.getElementById('" + ctrl.ClientID + "').focus();script
"; // Add the JavaScript code to the page. Page.RegisterStartupScript("FocusScript", focusScript);

Posting form data from ASP.NET page to another URL

http://www.c-sharpcorner.com/Code/2004/Sept/ASP.NetPostURL.asp

Removing White Chars from ASP.NET Output using Response.Filter property

http://www.codeproject.com/aspnet/RemovingWhiteSpacesAspNet.asp