Thursday, July 2, 2009

Menu Control:

.aspx

Menu ID="Menu1"
runat="server"
orientation="Horizontal"/"Vertical"
StaticEnableDefaultPopOutImage="false"



.aspx.cs

Single Menu


MenuItem fixmenu =new MenuItem();
fixmenu.Text = "Home";
fixmenu.NavigateUrl = "~/Sample1.aspx";
Menu1.Items.Add(fixmenu);


Parent and there child :

//PARENT1
MenuItem parentMenu = new MenuItem();
parentMenu.Text = "Parent";
parentMenu.NavigateUrl = "~/Sample.aspx";
//CHILD1
MenuItem childMenu = new MenuItem();
childMenu.Text = "Child1";
childMenu.NavigateUrl = "~/ChildMenu.aspx";
parentMenu.ChildItems.Add(childMenu);
//CHILD2
MenuItem childMenu2 = new MenuItem();
childMenu2.Text = "Child2";
childMenu2.NavigateUrl = "~/ChildMenu.aspx";
parentMenu.ChildItems.Add(childMenu2);

Menu1.Items.Add(parentMenu);

In SQL Server 2005 How to Find Tables With Primary Key Constraint in Database?

USE database
GO
SELECT i.name AS IndexName,
OBJECT_NAME(ic.OBJECT_ID) AS TableName,
COL_NAME(ic.OBJECT_ID,ic.column_id) AS ColumnName
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic
ON i.OBJECT_ID = ic.OBJECT_ID
AND i.index_id = ic.index_id
WHERE i.is_primary_key = 1