Sharepoint, WSS 3.0, C#, SQL server

tag:blogger.com,1999:blog-35198639573401405832024-10-07T08:11:22.060+03:00Sharepoint, WSS 3.0, C#, SQL serverC#,ASP.net,Ajax,SharePointMohamed Sharakyhttp://www.blogger.com/profile/14800891219932785203noreply@blogger.comBlogger29125tag:blogger.com,1999:blog-3519863957340140583.post-87126780581813854102011-02-20T22:55:00.003+03:002011-02-20T22:59:45.140+03:00Understanding the sharepoint index server and crawling of data

Within a SharePoint farm, one will typically have a server that performs the index function of the farm in order to manage crawling of searchable content and create an index file. I was always under the impression that this Index server performs all of the crawling for the crawlable entities, but recently discovered this is not the case. The Index server manages the crawl of all content,

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-3519863957340140583.post-53243249628347248432010-01-02T15:03:00.001+03:002010-01-02T15:05:46.164+03:00To hide unApproved content in query

To hid unapproved content in SPQuery object set the following property in code behindas the following.query.ViewAttributes = "Scope='Recursive' ModerationType='HideUnapproved'";

Mohamed Sharakyhttp://www.blogger.com/profile/14800891219932785203noreply@blogger.com0tag:blogger.com,1999:blog-3519863957340140583.post-6120001039831006822009-12-30T15:03:00.002+03:002009-12-30T15:12:20.026+03:00Problem of postBack in sharepoint

while dealing with Response.End() I found that the postback events are disabled. I posted to MSDN Forum and thy responded on my post by the following:Try to add this code to onClienClick event of the button to enable sharepoint post back event as the followingButtonName.OnClientClick = "_spFormOnSubmitCalled = false;_spSuppressFormOnSubmitWrapper=true;";my post on the following URL

Mohamed Sharakyhttp://www.blogger.com/profile/14800891219932785203noreply@blogger.com1tag:blogger.com,1999:blog-3519863957340140583.post-17966973561145103442009-12-29T12:09:00.001+03:002009-12-29T12:11:25.810+03:00Creating Custom properties in WebPart

For adding custom properties in webparts you can follow this article it is very useful.http://msdn.microsoft.com/en-us/library/dd584174(office.11).aspx

Mohamed Sharakyhttp://www.blogger.com/profile/14800891219932785203noreply@blogger.com0tag:blogger.com,1999:blog-3519863957340140583.post-90822084055974208762009-11-04T08:06:00.005+03:002009-11-04T08:55:49.627+03:00Export dataGrid to excel

if you need to export dataGrid to excel sheet you can do it as the following.1- get dataGrid object with data.2- create object of HtmlTextWriter.3- try to write the Grid using HtmlTextWriter in you response.as the following in button_Click event of any other location you want to perform this action. string attachment = "attachment; filename=RegisteredUsers.xls"; Response.ClearContent()

Mohamed Sharakyhttp://www.blogger.com/profile/14800891219932785203noreply@blogger.com0tag:blogger.com,1999:blog-3519863957340140583.post-77909156829961245302009-11-04T07:56:00.002+03:002009-11-04T08:06:06.644+03:00Changing machine name Problem in sharepoint

When I tried to change the machine name while I already have sharepoint server installed on this machine with many publishing webApplications, the problem is central administration and sharepoint websites can't load.So, you can do it as the following.1- change the machine name from computer settings to the name you want.2- open RUN3- goto the destination of stsadm (C:\Program Files\Common Files\

Mohamed Sharakyhttp://www.blogger.com/profile/14800891219932785203noreply@blogger.com0tag:blogger.com,1999:blog-3519863957340140583.post-47096940140942033102009-09-24T05:01:00.003+03:002009-09-24T05:06:20.630+03:00CAML Query that filters on the current user

CAML Queries are troublesome at the best of times. I find it best to use a tool or a tried and tested method like the one I use here Tip - Creating CAML Queries - Thinking out aloud - Dave Hunter's.When you create a view and you want to show only items that have been created by the current user you use the [Me] keyword.For example: filter by "Author" equals [Me].How can I do this using a CAML

Mohamed Sharakyhttp://www.blogger.com/profile/14800891219932785203noreply@blogger.com0tag:blogger.com,1999:blog-3519863957340140583.post-33531707218195464752009-08-18T01:00:00.003+03:002009-08-18T01:04:32.583+03:00SharePoint - using the rich text box in a custom user control

Frustration aplenty with this one. Logic dictated that the RichTextField control in SharePoint would have been the one to use...but no, it's not (as i found out)...so how do you use that shiny nice Rich Text Box control in a custom web part or user control.simple - so simple i'm sad to say it took me 1 1/2hrs discussing it with some like-minded fellows before we found out what it was (sad i know,

Mohamed Sharakyhttp://www.blogger.com/profile/14800891219932785203noreply@blogger.com0tag:blogger.com,1999:blog-3519863957340140583.post-39305639716501453992009-08-11T08:51:00.004+03:002009-08-11T09:14:52.166+03:00OutOfMemory Exception

I am using customList to add some requests from Anonymouse useres.But when I used EventHandler it gives me exception "OutOfMemory exception" while my code was as the following:SPSecurity.RunWithElevatedPrivileges(delegate(){SPWeb web = SPControl.GetContextWeb(Context);web.AllowUnsafeUpdates =true;SPListItem item = web.Lists["MyList"].Items.Add();item["RequestedName"] = textBoxName.Text;item["

Mohamed Sharakyhttp://www.blogger.com/profile/14800891219932785203noreply@blogger.com0tag:blogger.com,1999:blog-3519863957340140583.post-15159032309592241432009-06-23T14:13:00.005+03:002009-06-24T20:58:19.956+03:00Using Javascript to access a List Form Field in SharePoint Designer

An article was posted showing how to access and manipulate a List Form Field within SharePoint Designer using Javascript over at Microsoft SharePoint Designer Team Blog. The code in the article supported the following types of SharePoint 2007 form fields, but not the Radio Buttons Choice field:Single Line of TextMultiple Lines of TextNumberCurrencyChoice (dropdown)Lookup (single)Lookup (multiple)

Mohamed Sharakyhttp://www.blogger.com/profile/14800891219932785203noreply@blogger.com1tag:blogger.com,1999:blog-3519863957340140583.post-87597890509188955382009-06-23T09:25:00.007+03:002009-07-08T13:59:55.999+03:00compare dates in sharepoint using JavaScript

you can use the current code to check the differance between dates before saving data using JavaScript code.The following code I used to use it in case of check dates I hope it will be useful.function PreSaveAction() {var date1 = getTagFromIdentifierAndTitle("INPUT","DateTimeFieldDate","Letter Date"); var date2 = getTagFromIdentifierAndTitle("INPUT","DateTimeFieldDate","Decision Date"); var date3

Mohamed Sharakyhttp://www.blogger.com/profile/14800891219932785203noreply@blogger.com0tag:blogger.com,1999:blog-3519863957340140583.post-29593743488797396392009-06-22T09:00:00.004+03:002009-06-22T09:07:43.657+03:00To disable right click on webpage

you can disable the right click on webpage using the following javascript code:<script language="JavaScript1.1"> <!-- Begin function right(e){ if (navigator.appName == 'Netscape' && (e.which == 3 e.which == 2))return false;else if (navigator.appName == 'Microsoft Internet Explorer' && (event.button == 2 event.button == 3)){ alert(" "); return false;}return true;}

Mohamed Sharakyhttp://www.blogger.com/profile/14800891219932785203noreply@blogger.com0tag:blogger.com,1999:blog-3519863957340140583.post-59349984319686292992009-06-03T21:07:00.002+03:002009-06-22T09:09:32.214+03:00WPSC undefined JavaScript error.

While using Forms Authontication I met the following JS error "WPSC" object isnot defiend, and I added the following code then this error disappeared.<script type="text/javascript">if(typeof(WPSC) == "undefined"){WPSC = new Object();WPSC.Init = function(){//do nothing}WPSC.WebPartPage = new Object();WPSC.WebPartPage.Parts = new Object();WPSC.WebPartPage.Parts.Register = function(){//do

Mohamed Sharakyhttp://www.blogger.com/profile/14800891219932785203noreply@blogger.com0tag:blogger.com,1999:blog-3519863957340140583.post-15982701793564695522009-05-17T17:15:00.003+03:002009-06-22T09:12:59.387+03:00Printing WebPage using JavaScript

for printing a webpage using javascript you can use the following code it is very usefull for printing any HTML content.you can change elem with the content you want to print.function PrintPage(){ var elem= myBody(); var popup = window.open(' ','popup','toolbar=no,menubar=no,width=200,height=300'); popup.document.open(); popup.document.write("<html><

Mohamed Sharakyhttp://www.blogger.com/profile/14800891219932785203noreply@blogger.com0tag:blogger.com,1999:blog-3519863957340140583.post-16800249067568522942009-04-27T09:50:00.001+03:002009-06-23T10:15:02.910+03:00CAML query with Person or People and Groups column in Sharepoint 2007 (using in Event Handlers)

I was facing an issue with my simple CAML query where I was trying to filter the Field inside Sharepoint List and supplying value from the properties.AfterProperties of List Item event handler. This field was of Person or to say People and Groups kind of field. Internally inside sharepoint this value is stored as USERID and not as the display name. So I was using a simple CAML builder to build my

Mohamed Sharakyhttp://www.blogger.com/profile/14800891219932785203noreply@blogger.com0tag:blogger.com,1999:blog-3519863957340140583.post-37958473949743906192009-04-15T09:09:00.001+03:002009-06-23T10:14:49.304+03:00SharePoint Security Access Check Codeplex

A colleague of mine just pointed me to this interesting tool ...http://www.codeplex.com/AccessCheckerQuickly check what objects within a Sharepoint site hierarchy a user has access to. The Access Checker Web Part is a Windows Sharepoint Services Web Part, for use within Windows Sharepoint Services v3 and Microsoft Office Sharepoint Server 2007, that displays a tree view showing permissions on

Mohamed Sharakyhttp://www.blogger.com/profile/14800891219932785203noreply@blogger.com0tag:blogger.com,1999:blog-3519863957340140583.post-57955874449760019282009-03-20T20:20:00.001+03:002009-06-23T10:15:13.505+03:00How to Uninstall Microsoft SQL Server 2005 Embedded Edition (SSEE Instance)

you need to uninstall Microsoft SQL Server 2005 Embedded Edition (SSEE Instance) while uninstalling windows sharepoint services.Simply execute the following command in a windows console :(on 32-bit platforms)msiexec /x {CEB5780F-1A70-44A9-850F-DE6C4F6AA8FB} callerid=ocsetup.exe(on 64-bit platforms)msiexec /x {BDD79957-5801-4A2D-B09E-852E7FA64D01} callerid=ocsetup.exe

Mohamed Sharakyhttp://www.blogger.com/profile/14800891219932785203noreply@blogger.com0tag:blogger.com,1999:blog-3519863957340140583.post-56535963491359790612009-03-10T11:26:00.001+03:002009-06-23T10:15:30.165+03:00Add previlages to user to do some actions in WSS 3.0 / MOSS 2007

We can use this method for dealing with users that has low previlages over specific List.SPSecurity.RunWithElevatedPrivileges(delegate(){SPListItem NewUser = NewUsersList.Items.Add();NewUser["Username"] = _userNameTextBox.Text.Trim();NewUser["Password"] = _passwordTextBox.Text.Trim();NewUser["First Name"] = _firstNameTextBox.Text.Trim();NewUser["Last Name"] = _lastNameTextBox.Text.Trim();NewUser[

Mohamed Sharakyhttp://www.blogger.com/profile/14800891219932785203noreply@blogger.com0tag:blogger.com,1999:blog-3519863957340140583.post-60104487565608554682009-03-10T11:22:00.001+03:002009-06-23T10:15:41.246+03:00WSS 3.0 Allow Unsafe Updates

you can use the following property in custom WebPart:Web.AllowUnsafeUpdates = true;{ Your Code here }Web.AllowUnsafeUpdates = false;this property can be used with anonymous or user with low permissions.

Mohamed Sharakyhttp://www.blogger.com/profile/14800891219932785203noreply@blogger.com0tag:blogger.com,1999:blog-3519863957340140583.post-76680455440066986942009-03-03T08:43:00.002+03:002009-06-23T10:06:42.494+03:00Map of Reusable SharePoint JavaScript

JSRequestversion: WSS 3.0source file: init.js (ln 1621)mapped by: Itay Shakurypurpose: provides method to parse query string, filename, and pathname from URLexample:JSRequest.EnsureSetup();var qs = JSRequest.QueryString[value];var fn = JSRequest.FileName;var pt = JSRequest.PathName;PreSaveAction()version: WSS 3.0source file: n/a (ref: form.js ln 5909)mapped by: Edin Kapicpurpose: provides hook

Mohamed Sharakyhttp://www.blogger.com/profile/14800891219932785203noreply@blogger.com0tag:blogger.com,1999:blog-3519863957340140583.post-53352361959461483162009-03-02T20:57:00.003+03:002010-05-11T13:28:43.808+03:00Hide fields in NewForm.aspx without customization

You can use the following techniqe to hide flags that you add in custom list or document library without customization you can add the following code after the ContentPlaceHolder tage<asp:Content ContentPlaceHolderId=”PlaceHolderMain” runat=”server”>The script as the following:<script language="javascript" type="text/javascript">// set the function that will load in the page call.

Mohamed Sharakyhttp://www.blogger.com/profile/14800891219932785203noreply@blogger.com0tag:blogger.com,1999:blog-3519863957340140583.post-86432992761256891352009-02-22T21:39:00.002+03:002009-06-27T16:02:48.134+03:00TextBox accepts only numbers

<asp:TextBox " runat="server" id="txt1" onkeypress="return isNumberKey(event)" />This is the javascript method that will be called by the textbox on onkeyPress event<SCRIPT type="text/javascript" language=Javascript><!-- function isNumberKey(evt) { var charCode = (evt.which) ? evt.which : event.keyCode if (charCode > 31 && (charCode &lt

Mohamed Sharakyhttp://www.blogger.com/profile/14800891219932785203noreply@blogger.com0tag:blogger.com,1999:blog-3519863957340140583.post-7996130317007587472009-02-14T12:04:00.001+03:002009-06-23T10:11:03.986+03:00Get SelectedValue from sharepoint lookup Field

<SharePoint:FormField runat="server" id="ff30{$Pos}" ControlMode="New" FieldName="_x0627__x0644__x0628__x0646__x06" __designer:bind="{ddwrt:DataBind('i',concat('ff30',$Pos),'Value','ValueChanged','ID',ddwrt:EscapeDelims(string(@ID)),'@_x0627__x0644__x0628__x0646__x06')}" /><SharePoint:FieldDescription runat="server" id="ff30description{$Pos}" FieldName="_x0627__x0644__x0628__x0646__x06"

Mohamed Sharakyhttp://www.blogger.com/profile/14800891219932785203noreply@blogger.com0tag:blogger.com,1999:blog-3519863957340140583.post-57450852821420410152009-02-14T11:52:00.001+03:002009-06-23T10:11:34.045+03:00Get SelectedValue Of dropdownlist

Mohamed Sharakyhttp://www.blogger.com/profile/14800891219932785203noreply@blogger.com0tag:blogger.com,1999:blog-3519863957340140583.post-77239379595586203502009-02-08T12:36:00.001+03:002009-07-08T12:59:35.855+03:00Linking Sql Server 2005 to Oracle

This is copied article but I think it is usefull.Oracle-SS2005 Linked ServersHere is a quick guide to setting up linked servers so you can query Oracle through Sql Server.For my testing of this I used Sql Server Express 2005, and Oracle 9.2. This all uses simple commands that can be run via Query Analyzer or Query Tool.First, if you've been doing this and having issues, you need to clear out any

Mohamed Sharakyhttp://www.blogger.com/profile/14800891219932785203noreply@blogger.com0