tag:blogger.com,1999:blog-26174883945005454732024-03-13T18:46:02.192+02:00Let's Share Our ExpertiseLet's Share Our Expertise blog collects tips and tricks which I gained from my practical experience, reading, coding and googling.
Let's Share Our Expertise blog is designed for IT Professionals and Developers who are using Visual Studio IDE (VB.NET, C# and ASP.NET), SQL, SharePoint and many other Microsoft products.Mahmoud Aleryanhttp://www.blogger.com/profile/11977054100268648774noreply@blogger.comBlogger32125tag:blogger.com,1999:blog-2617488394500545473.post-7968695406014263262012-02-05T21:14:00.003+02:002012-02-06T12:30:23.230+02:00Manage User Properties Change Display Order buttons are not workingManage User Properties Page enables the User Profiles Service Application administrator to manage the user profile properties. He can ِِِAdd, Edit, Map, or Change the Display Order of the properties in My Profile Page.
Figure (1) Manage User Profile Service Application Page
One of the problems which I faced with Change Display Order buttons shown in Figure (2), that when I press on Move Up Mahmoud Aleryanhttp://www.blogger.com/profile/11977054100268648774noreply@blogger.com4tag:blogger.com,1999:blog-2617488394500545473.post-257337672791959332011-11-28T18:10:00.003+02:002011-11-28T18:13:52.297+02:00Query Join between related lists in SharePoint 2010 using "SPQuery.Joins" propertyOne of the famous complains of the developers who switched from SQL background (For example Me :-)) to SharePoint development; is how to query related lists with joins instead on looping and filtering both of them using different queries.
You can Achieve this using the SPQuery.Joins Property.
Example:
Source: http://Mahmoud Aleryanhttp://www.blogger.com/profile/11977054100268648774noreply@blogger.com0tag:blogger.com,1999:blog-2617488394500545473.post-60135156533060824622011-10-06T13:13:00.002+02:002011-10-06T13:30:26.343+02:00PDF Documents Collaboration with SharePoint 2010SharePoint 2007/ 2010 mainly used for documents management and collocation; including all the features (Check In, Check Out, Version History, etc...) using Microsoft Office Suite. By default SharePoint does not support these features for PDF files. Adobe has released a product called Adobe Acrobat X which you can use it to achieve a good integration with SharePoint and use all its features Mahmoud Aleryanhttp://www.blogger.com/profile/11977054100268648774noreply@blogger.com2tag:blogger.com,1999:blog-2617488394500545473.post-86033309936595844622011-03-17T11:39:00.003+02:002011-03-18T22:19:34.096+02:00"Insert Related List" feature in SharePoint 2010
One of the helpful features in SharePoint 2010 is the "Related List" button.
Figure(1)
This button is used to add lists which are related to a specific list (one-to-many relationship) in the same page and filter the data according to the selected item in the primary list.
Example: In this example I’ll present a demo for Customers and Customer Orders, and how to relate the data and Mahmoud Aleryanhttp://www.blogger.com/profile/11977054100268648774noreply@blogger.com2tag:blogger.com,1999:blog-2617488394500545473.post-86167639316101929122011-02-20T19:06:00.002+02:002011-02-20T19:07:51.282+02:00Create Site Action (SharePoint Designer 2010 Workflow Actions)The actions can be downloaded here.
Add the “Create a Site” action to a SharePoint 2010 Designer Workflow
Configuration
URL: The url of the web site. You could either use an relative url to create the site direct under the current site or an absolute url to create the site under any site. The workflow initiator needs appropriate permissions. Or you can use an impersonation step to run the Mahmoud Aleryanhttp://www.blogger.com/profile/11977054100268648774noreply@blogger.com2tag:blogger.com,1999:blog-2617488394500545473.post-51017007693566032942011-02-14T09:50:00.001+02:002011-02-14T09:54:01.287+02:00SharePoint 2010 Training Series
Microsoft is providing the following training series for both IT Professionals and Developers. I hope that it adds something new for you.
SharePoint 2010 Advanced IT Professional Training Core Architecture of SharePoint 2010
Security in SharePoint 2010
IT Pro Management in SharePoint 2010
Upgrading to SharePoint 2010
Enterprise Search in SharePointMahmoud Aleryanhttp://www.blogger.com/profile/11977054100268648774noreply@blogger.com0tag:blogger.com,1999:blog-2617488394500545473.post-51125518841977288742011-02-05T00:38:00.005+02:002012-04-07T06:40:45.241+02:00SharePoint 2010 Branding Series
The following is a series of links for SharePoint 2010 Branding articles that goes step by step to implement the following design:
SharePoint 2010 Branding Series – Part One
SharePoint 2010 Branding Series – Part Two
SharePoint 2010 Branding Series – Part Three
SharePoint 2010 Branding Series – Part Four
SharePoint 2010 Branding Series – Part Five
The post will be updated Mahmoud Aleryanhttp://www.blogger.com/profile/11977054100268648774noreply@blogger.com1tag:blogger.com,1999:blog-2617488394500545473.post-60548465061549278482011-02-04T11:10:00.001+02:002011-02-04T11:27:19.993+02:00SharePoint 2010: Navigation Drop Down Styles
If you would like to stylize your navigation drop downs in SharePoint 2010 here are the 4 main key classes to update your CSS.
If you are looking for SharePoint 2007 styles see this blog post here.
The OOTB Navigation Drop Down CSS: “COREV4.CSS”
.s4-tn ul.dynamic{
/* [ReplaceColor(themeColor:"Light2")] */ background-color:white;
/* [ReplaceColor(themeColor:"Dark2-Lighter")] */ border:1px Mahmoud Aleryanhttp://www.blogger.com/profile/11977054100268648774noreply@blogger.com0tag:blogger.com,1999:blog-2617488394500545473.post-20369241727449487862011-01-26T21:07:00.000+02:002011-01-26T21:07:42.932+02:00The User Profile Synchronization service does not start on a stand-alone installation of SharePoint Server 2010SharePoint Server 2010 has two installation options:
1- Complete Installation:
You can add more Web Front End Servers, Application Services Servers, and DataBase servers to your
farm.
2- Stand-alone Installation:
This installs all the components of SharePoint on one server, and you don't have the possibility to join more
 Mahmoud Aleryanhttp://www.blogger.com/profile/11977054100268648774noreply@blogger.com1tag:blogger.com,1999:blog-2617488394500545473.post-10322655697349638792011-01-26T03:11:00.001+02:002011-03-06T15:33:29.386+02:00Configuring My Site in SharePoint 2010The following article explains how to configure My Site in SharePoint 2010.
http://sharepointgeorge.com/2010/configuring-my-site-sharepoint-2010/ Mahmoud Aleryanhttp://www.blogger.com/profile/11977054100268648774noreply@blogger.com0tag:blogger.com,1999:blog-2617488394500545473.post-818348148221229902011-01-24T10:31:00.000+02:002011-01-24T10:31:26.308+02:00Multilingual user interface overview (SharePoint Server 2010)Dears,
I found the following article from MSDN which explains
Use and benefits of the multilingual user interface
How the multilingual user interface works
What is supported by the multilingual user interface
Adding and modifying application content
Mahmoud Aleryanhttp://www.blogger.com/profile/11977054100268648774noreply@blogger.com0tag:blogger.com,1999:blog-2617488394500545473.post-69507786453300858102011-01-10T09:03:00.000+02:002011-01-10T09:03:17.322+02:00New SharePoint Developer Features in VS2010 SP1 – Unit Testing and IntelliTrace (Saaid Khan) As part of VS 2010 SP1 SharePoint developers can now take advantage of IntelliTrace as well as create unit tests that use SharePoint API’s. With 64-bit support now enabled in IntelliTrace, you can use IntelliTrace in your SharePoint farm solutions. You can set a break-point in your code or break execution and then view the IntelliTrace data. You can also collect IntelliTrace data and save the .Mahmoud Aleryanhttp://www.blogger.com/profile/11977054100268648774noreply@blogger.com0tag:blogger.com,1999:blog-2617488394500545473.post-44506906232539512392010-12-23T10:56:00.000+02:002010-12-23T10:56:29.905+02:00Display Success and Error messages in SharePoint 2010One of the common functions which is required from any developer; is to display a Success and Error messages to the user, and it’s always better to use the same style of the main application.
In SharePoint: SPUtility class contains two methods to achieve this.
Success Message:
SPUtility.TransferToSuccessPage: It is used to display a Success Message, and it has two overloads.
Mahmoud Aleryanhttp://www.blogger.com/profile/11977054100268648774noreply@blogger.com0tag:blogger.com,1999:blog-2617488394500545473.post-83189854562691644422010-12-15T23:26:00.000+02:002010-12-15T23:26:40.403+02:00SQL 2008 DateTime dataTypesSQL 2008 introduced new types of DateTime data type (Time, Date, DateTime, DateTime2, SmallDateTime and DateTimeOffset).
The following query example explains the difference between each one of them.
SELECT
CAST('2007-05-08 12:35:29. 1234567 +12:15' AS time(7)) AS 'Time'
,CAST('2007-05-08 12:35:29. 1234567 +12:15' AS date) AS 'Date'
,CAST('2007-05-08 12:35:29.123' AS smalldatetime) AS 'Mahmoud Aleryanhttp://www.blogger.com/profile/11977054100268648774noreply@blogger.com0tag:blogger.com,1999:blog-2617488394500545473.post-23201162859111284072010-12-12T21:00:00.002+02:002010-12-12T21:05:02.046+02:00Filter list of SQL objects in SQL Management StudioAs I believe that to increase your productivity; you have to master using the tools which you are using. SQL Management Studio is one of the tools which is used by any developer during the day.
If you are working in a large project and you have a large number of objects (Tables, Stored Procedures, Functions or Views) in the application database, and you want to edit a certain one. Instead of Mahmoud Aleryanhttp://www.blogger.com/profile/11977054100268648774noreply@blogger.com0tag:blogger.com,1999:blog-2617488394500545473.post-44423339680011839612010-12-10T15:27:00.001+02:002010-12-10T15:27:48.386+02:00How to repair a SQL Server 2005/ 2008 Suspect databaseSome times after Hardware or Power failure, when you open the SQL Management studio; you find that some of your databases are not accessible, and they are marked as “Suspect”
To fix this you can run the following query (replace “MyDataBaseName” with the database name):
ALTER DATABASE MyDataBaseName SET EMERGENCY
DBCC checkdb ('MyDataBaseName')
ALTER DATABASE MyDataBaseName SET SINGLE_USER WITH Mahmoud Aleryanhttp://www.blogger.com/profile/11977054100268648774noreply@blogger.com2tag:blogger.com,1999:blog-2617488394500545473.post-65303350049012103002010-12-10T15:13:00.001+02:002010-12-10T15:28:37.944+02:00Get list of Months Names in the current Thread languageOne of the functions which are required in the localized applications is to get the list of months names in the current culture language.
To do this, some people do this using resources and add it manually to the control (DropDownList, ListBox, etc...), but you can accomplish this by the following single line of code which returns the months names translated to the current Thread culture.
Mahmoud Aleryanhttp://www.blogger.com/profile/11977054100268648774noreply@blogger.com0tag:blogger.com,1999:blog-2617488394500545473.post-6772736186108897942010-12-08T00:54:00.020+02:002010-12-10T11:27:40.570+02:00Auto Sign out SharePointOne of the customer requirements was "If the user is not the using the SharePoint portal in the browser for more than 10 minutes; The session should be ended for security reasons".
To accomplish this I tried to enable the Session State for the SharePoint site "Which is disabled by default" and changed the Session time out, but it didn't work. So after a lot of research and googling, I Mahmoud Aleryanhttp://www.blogger.com/profile/11977054100268648774noreply@blogger.com0tag:blogger.com,1999:blog-2617488394500545473.post-79283419404951783042010-12-05T09:52:00.001+02:002010-12-11T12:36:01.082+02:00Insert multiple rows values in one Insert statement (SQL 2008)One of the nice tricks of insert statement; that it is possible to insert multiple rows values in one insert statement; you don’t need to insert each row in a separate statement.
CREATE TABLE DemoTable
(
ItemID INT IDENTITY
PRIMARY KEY,
FirstName VARCHAR(50),
LastName VARCHAR(50),
CountryCode VARCHAR(4),
)
INSERT [DemoTable]
(
Mahmoud Aleryanhttp://www.blogger.com/profile/11977054100268648774noreply@blogger.com0tag:blogger.com,1999:blog-2617488394500545473.post-81883293367990185212010-11-09T10:54:00.000+02:002010-11-09T10:54:48.923+02:00Using code to create InfoPath Custom Rule ConditionThe following article explains how to create a custom rule condition using .NET code, and use it by the infopath designer.
http://www.infopathdev.com/blogs/greg/archive/2004/09/15/Use-Code-to-Determine-a-Rule-Condition.aspx
I hope it helps you.Mahmoud Aleryanhttp://www.blogger.com/profile/11977054100268648774noreply@blogger.com0tag:blogger.com,1999:blog-2617488394500545473.post-20483875789498521962010-11-05T10:28:00.000+02:002010-11-05T10:28:16.874+02:005 Troubleshooting Tips and Tricks for New SharePoint DevelopersQ: I have a functioning web page, then after I deploy my solution package, I get a 404 error message. If I retract my solution, the page is still there. What happened?A: A 404 error indicates the page is truly gone. However, you've pointed out that the page isn't really gone; it's still there. That would leave you to believe that it's some other resource that's missing. Well, what other resource Mahmoud Aleryanhttp://www.blogger.com/profile/11977054100268648774noreply@blogger.com0tag:blogger.com,1999:blog-2617488394500545473.post-67936788301082447272010-11-05T01:00:00.001+02:002010-11-05T01:04:16.172+02:00Introduction to Aspect Oriented ProgrammingAspect Oriented Programming (AOP) is a new programming paradigm dealing with separating crosscutting concerns that are usually hard to do in object-oriented programming. An aspect is a software entity implementing a specific non-functional part of the application. Click Here to read this nice article which gives a valuable introduction about it.Mahmoud Aleryanhttp://www.blogger.com/profile/11977054100268648774noreply@blogger.com0tag:blogger.com,1999:blog-2617488394500545473.post-37173848303596709082010-10-29T22:01:00.001+02:002010-10-29T22:01:28.840+02:00Implementing Two interface having the same method signature in the same classI was searching for how to implement two interfaces having the same method, and I found this nice article by Sandeep P R describing this.
http://sandblogaspnet.blogspot.com/2008/05/implementing-two-interface-having-same.html
I hope it helps you.
Mahmoud Aleryanhttp://www.blogger.com/profile/11977054100268648774noreply@blogger.com0tag:blogger.com,1999:blog-2617488394500545473.post-85936026952091690522010-09-30T08:55:00.015+03:002010-12-10T11:59:51.000+02:00Log Exception.ToString(); never log only Exception.Message!When you are trying to log an exception, don't forget that you should always log
Exception.ToString();
And never use
Exception.Message
The first snippet of code gives you more information about the exception like Stack trace, Inner exception and Message.
If you only log Exception.Message, you'll only have something like "Object reference not set to an instance of an object".Mahmoud Aleryanhttp://www.blogger.com/profile/11977054100268648774noreply@blogger.com0tag:blogger.com,1999:blog-2617488394500545473.post-67049916621340690322010-08-12T14:36:00.000+02:002010-08-12T14:36:26.840+02:00Infragistics WebDatePicker AutoPostBackWebDatePicker is one of the nice controls provided by Infragistics company. This control has a nice user interface as well many other nice features
Figure(1) Infragistics WebDatePicker
To configure this control to fire postback when selecting a value from the calendar, there is a small trick you have to do. The default value of the property “Edit Mode” is “KeyboardAndCalendar” which causes the Mahmoud Aleryanhttp://www.blogger.com/profile/11977054100268648774noreply@blogger.com2