How can you set your ConnectionString on your Web part

Hi Folks,

This is a tricky post,alot of question i found on the web regarding how can i put the connection string for my web part once i finished my development and i want to be work with my sharepoint site. simply add your connection string on the web.config of your web site .

web.config of your site path :
D:\Inetpub\wwwroot\wss\VirtualDirectories\Port#\

simply add the connection string section after the sharepoint key and before system.web key as follows :


{sharepoint}
……….
{/sharepoint}

{connectionstrings}
{add providername=”System.Data.SqlClient” connectionstring=”Data Source=server;Initial Catalog=mydb;User ID=DotNetBoom;Password=DotNetBoom” name=”MyConnect”}
{/connectionstrings}

{system.web}……..

please replace {} with .

Hope this helps………….


Regards,
Mostafa arafa

Ready Tool for managing Asp.Net 2.0 Membership Data

Hi Folks,


Very useful tool i found it on CodePlex community site,this tools give you easily manage the membership tables,manage user roles,Roles,Reset passwords.

The tools is available with source code also…. :)

Download URL :
http://www.codeplex.com/CKS/Release/ProjectReleases.aspx?ReleaseId=7450

This tool is a very useful tool for web developers and you can download it and use it without writing a line of code or using VS2005 asp.net security configuration tool.

Happy .Netting.



Regards,
Mostafa arafa

This product requires at least Windows workflow foundation version 3.0.4203.2 which is part of Microsoft .NET Framework 3.0

Hi All,

If you are trying to install MOSS 2007,or installing .Net Framework 3.0 redistributable package perior of MOSS installation, you might face an error :

“Set up is unable to proceed due to the following errors: This product requires at least Windows workflow foundation version 3.0.4203.2 which is part of Microsoft .NET Framework 3.0″

I tried all possible scenarios to fix this error and i set almost 4 hours to get a solution for this error,and after long period of searching over the internet and trying all posibble solutions,the only solution which works with me,is the following: when installing the .net framework redistributable package is not enough to fix this problem because its not the Full Package of .Net Framework 3.0,which is not available over any MS internet web site and i get it though on of the .net product team.

The Full .Net Framework 3.0 installer package download URL :

http://go.microsoft.com/fwlink/?LinkId=70848

No more Nightmares with MOSS installation………..Thanks God :)

Different error messages for the same problem posted on below blog :
http://blogs.msdn.com/astebner/archive/2006/10/30/net-framework-3-0-setup-log-files.aspx



Regards,
Mostafa arafa

Problem when creating new sharepoint share services

Hi All,

When you try to create new sharepoint shared services or (SSP),if you faced that the created site is not coming on the web application list,you have to know that this means that your application is running under Network Service or local service account.

The Solution : change the serivce account which run your web application.

To Do that : open SharePoint Central Administration -> click on Operation Tab -> Services Account.

Select your web application and change the account which running your site.



Regards,
Mostafa arafa

Change SharePoint Site port

Hi Folks,

This post is a tricky post,i faced this problem,i had a sharepoint 2007 site,and i want to change its port,to change it do the following :

1) from IIS Manager,right click on the site,and change the port from the old to the new one.

2) From Sharepoint Central Administration,click on operation tab,and click on alternate access mapping (AAM) to map the new url to the created web application url.

For example : you changed the created site from port 9999 to 90 :

http://MyServer:90/ Map To http://myserver:9999/

This tells that if the sharepoint get a request on the port 90 from the iis,map it to the created url web application.


Another Tip :

If you want to change the port which is used from the sharepoint site to connect via SQL Server 2000/2005,simply by using SQL Configuration manager,follow this article:

http://kbalertz.com/889647/change-SharePoint-Portal-Server-connect-Server.aspx


Hope this helps ……………


Regards,
Moustafa arafa

Difference between SharePoint Web Services and API

Hi all,

One of the most tricky tasks to select the type of development task you will work to integrate your custom application with sharePoint portal as all know that you can work with sharepoint 2007 data either through SharePoint Services or SharePoint APIs.

You can use SharePoint Web Serivces in case your code is not resides on sharepoint server,and you would like to manipulate sharepoint data in oyur application.

In case your code resides on sharepoint server,you can use directly the sharepoint APIs to manipulate sharepoint data in an easy way.


Big enhancements have been done on Sharepoint services,you can manipulate all sharepoint compoenets by consumping sharepoint services such as : users,groups,permissions,meetings,BDC,Workflows,webparts pages,documents,lists…etc.


I recommend using Shapoint API in case your code resides on the sharepoint server than using the sharepoint web services because its OOP Object model and gives you little bit more features in some sharepoint classes than provided on the web services.

and the last decision is to you…..

Hope this helps.




Regards,
Moustafa arafa