Posted on: 6/5/2013 11:09:38 AM | Views : 362

Hi Friends,
I have created a css menu in masterpage in my web application. below is the code of masterpage :-
SqlConnection con = new SqlConnection(); con.ConnectionString = clsProperty.GetConnectionString; con.Open(); SqlDataAdapter daMenu = new SqlDataAdapter("SELECT DISTINCT UserPermissionDetails.PageGroupId, PageGroupDetails.PageGroupName FROM UserPermissionDetails INNER JOIN " + "UserGroupDetails ON UserPermissionDetails.UserGroupId = UserGroupDetails.UserGroupId INNER JOIN EmployeeDetails ON UserGroupDetails.UserGroupId = EmployeeDetails.UserGroup INNER JOIN " + "PageGroupDetails ON UserPermissionDetails.PageGroupId = PageGroupDetails.PageGroupDetailsId WHERE (EmployeeDetails.EmpId =" + Session["EmpId"].ToString() + ") AND (UserPermissionDetails.ViewPage = 1)", con); DataTable dtMenu = new DataTable(); daMenu.Fill(dtMenu); if (dtMenu.Rows.Count > 0)
Go to the complete details ...