Adding custom field into sharepoint

Hi,
First of all thanx to SharePointKings site
First in my Control.ascx i have written as below and had put in 12hive\TEMPLATE\CONTROLTEMPLATES path
<%@Assembly Name="Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>
<%@Register TagPrefix="SharePoint" Assembly="Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" namespace="Microsoft.SharePoint.WebControls"%>



After that in my fldtypes_control.xml I have written as below and had put in 12hive\TEMPLATE\XML



SPKings Textbox
SPKings Textbox
SPKings Textbox
Text
SharePointKings.CustomControls.SPKingsTextBoxField, SharePointKings.CustomControls, Version=1.0.0.0, Culture=neutral, PublicKeyToken=0dcfd7c46d44c992
TRUE
TRUE


After that in SPKingsTextboxControl.cs I have written as follows
using System;
using System.Collections.Generic;
using System.Text;
using System.Web;
using System.Web.UI;
using Microsoft.SharePoint.WebControls;
using System.Web.UI.WebControls;
namespace SharePointKings.CustomControls
{
public class SPKingsTextboxControl:BaseFieldControl
{
protected TextBox txtTextBox;
///

/// setting template name
///

protected override string DefaultTemplateName
{
get
{
return @"SPKingsTextbox";
}
}

///

/// get set value
///

public override object Value
{
get
{
EnsureChildControls();
return txtTextBox.Text.Trim();
}

set
{
EnsureChildControls();
txtTextBox.Text = (string)this.ItemFieldValue;
}
}
///

/// create child control
///

protected override void CreateChildControls()
{
if (Field == null) return;
base.CreateChildControls();
}

}
}

After that in SPKingsTextBoxField.cs I have written as
using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SharePoint;
namespace SharePointKings.CustomControls
{
class SPKingsTextBoxField:SPFieldText
{
#region Contstructors
public SPKingsTextBoxField(SPFieldCollection fields, string fieldName): base(fields, fieldName)
{
}
public SPKingsTextBoxField(SPFieldCollection fields, string typeName, string displayName) : base(fields, typeName, displayName)
{

}

#endregion
public override string GetValidatedString(object value)
{
string strTxtValue = Convert.ToString(value).Trim();

if (!strTxtValue.ToUpper().StartsWith("HTTP") &&
!strTxtValue.ToUpper().StartsWith("FTP"))
{
throw new SPFieldValidationException("Web address does not start with HTTP or FTP");
}
return strTxtValue;
}
}
}

Matching the site urls with list item urls

Recently we had an requirement of webpart where it should fetch all the site under that Web Application and check the urls from the list where some urls are already saved.After checking it should display URL's that are available in the list,List of all the sites under the current Web Application,sites that are not available in the list,list URL's are not available in the current Web Application and soon as user clicks the Delete button it should delete the urls in the list which are not alive

using System;

using System.Linq;

using System.Text;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.HtmlControls;

using System.Collections;

using System.Collections.Generic;

using System.Collections.Specialized;

using System.IO;

using Microsoft.SharePoint;

using Microsoft.SharePoint.Administration;

using Microsoft.SharePoint.WebPartPages;

using System.Web.UI.WebControls.WebParts;

namespace RequestSiteDocument

{

public class RequestSiteDocument : System.Web.UI.WebControls.WebParts.WebPart

{

Button btnCreate;

Button btnDelete;

Label lblException;

private bool customMessage = true;


SPWeb oweb = SPContext.Current.Web;

SPSite objsite = SPContext.Current.Site;

SPList objlist = null;



ArrayList arrListofWebHierarchy = new ArrayList();

ArrayList arrListURLInfo = new ArrayList();

ArrayList arrListofsitenames = new ArrayList();

ArrayList arrListURLInfoinDeletebutton = new ArrayList();

ArrayList arrListListofWebHierarchyinDeletebutton = new ArrayList();

ArrayList arrListfordeletelist = new ArrayList();

ArrayList arrListofsitenamesinDeletebutton = new ArrayList();


protected override void CreateChildControls()

{

base.CreateChildControls();



if (DisplayButton)

{

btnCreate = new Button();

btnCreate.ID = "btnCreate";

btnCreate.Text = "Create";

btnCreate.Click += new EventHandler(btnCreate_Click);

btnCreate.Visible = true;

this.Controls.Add(btnCreate);

btnDelete = new Button();

btnDelete.ID = "btnDelete";

btnDelete.Text = "Delete";

btnDelete.Click += new EventHandler(btnDelete_Click);

btnDelete.Visible = true;

this.Controls.Add(btnDelete);

}

lblException = new Label();

lblException.ID = "";

lblException.Visible = true;

this.Controls.Add(lblException);

}

void btnCreate_Click(object sender, EventArgs e)

{

throw new NotImplementedException();

}



[Personalizable(PersonalizationScope.Shared),

WebBrowsable(true),

WebDisplayName("Display button"),

WebDescription("Display button"),

SPWebCategoryName("Display button")]

public bool DisplayButton

{

get { return customMessage; }

set { customMessage = value; }

}



protected override void Render(System.Web.UI.HtmlTextWriter writer)

{

base.Render(writer);

//SPSite objsite = SPContext.Current.Site;


SPWebCollection objspw = objsite.AllWebs;

try

{

objlist = oweb.Lists["RequestASiteList"];

if (objlist != null)

{

writer.Write("");

writer.Write("");

writer.Write("");

writer.Write("");

foreach (SPListItem itmlist in objlist.Items)

{

writer.Write("");

writer.Write("");

writer.Write("");

arrListURLInfo.Add(strurl);

writer.Write("");

}

writer.Write("

URL's that are available in the list
Site Title	Site URL
"); string strsitetitle = (itmlist["Title"].ToString().ToLower()); writer.Write(strsitetitle); writer.Write("	"); string strurl = (itmlist["url"].ToString()).ToLower(); writer.Write(strurl); writer.Write("

");

}

writer.Write("");

writer.Write("");

writer.Write("");

writer.Write("");

//fetching all the site names and site urls

foreach (SPWeb objweb in objspw)

{

writer.Write("");

writer.Write("");

writer.Write("");

writer.Write("");

//adding all site url's to the array list called arrListofWebHierarchy

arrListofWebHierarchy.Add(objwebfullurl);

arrListofsitenames.Add(objweb.Title);

}

writer.Write("

List of all the sites under the current Web Application
Site Name	Site URL
"); writer.Write(objweb.Title); writer.Write("	"); writer.Write(objweb.Url); string objwebfullurl = (objweb.Url).ToLower() + "/default.aspx"; writer.Write("

");

writer.Write("");

writer.Write("Below sites are not available in the list");

int sitefoundflag = 0;

//Compare arrListofWebHierarchy with arrListURLInfo

for (int i = 0; i < arrListofWebHierarchy.Count; i++) { for (int j = 0; j < arrListURLInfo.Count; j++) { if (arrListofWebHierarchy[i].ToString().CompareTo(arrListURLInfo[j].ToString().Trim()) == 0) { sitefoundflag = sitefoundflag + 1; } } if (sitefoundflag <= 0) { writer.Write("
");

writer.Write("Site Name:" + arrListofsitenames[i]);

writer.Write("");

writer.Write("URL:" + arrListofWebHierarchy[i]);

writer.Write("");

}

else

{

sitefoundflag = 0;

}

}

writer.Write("");

writer.Write("Below list URL's are not available in the current Web Application");

int listflag = 0;

//Compare arrListURLInfo with arrListofWebHierarchy

for (int i = 0; i < arrListURLInfo.Count; i++) { for (int j = 0; j < arrListofWebHierarchy.Count; j++) { if (arrListURLInfo[i].ToString().CompareTo(arrListofWebHierarchy[j].ToString().Trim()) == 0) { listflag = listflag + 1; } } if (listflag <= 0) { writer.Write("
");

writer.Write(arrListURLInfo[i]);

arrListfordeletelist.Add(arrListURLInfo[i]);

writer.Write("");

}

else

{

listflag = 0;

}

}

}

catch (Exception ex)

{

lblException = new Label();

lblException.Text = ex.ToString();

}

}


void btnDelete_Click(object sender, EventArgs e)

{

try

{

SPWebCollection objspw = objsite.AllWebs;

//get the url's that are available in the list field called url

objlist = oweb.Lists["RequestASiteList"];

if (objlist != null)

{

foreach (SPListItem itmlist in objlist.Items)

{

string strurl = (itmlist["url"].ToString()).ToLower();

arrListURLInfoinDeletebutton.Add(strurl);

}

}

//fetching all the site names and site urls

foreach (SPWeb objweb in objspw)

{

string objwebfullurl = (objweb.Url).ToLower() + "/default.aspx";

//adding all site url's to the array list called arrListListofWebHierarchyinDeletebutton

arrListListofWebHierarchyinDeletebutton.Add(objwebfullurl);

arrListofsitenamesinDeletebutton.Add(objweb.Title);

}

int listflag = 0;

//Compare arrListURLInfoinDeletebutton with arrListListofWebHierarchyinDeletebutton

for (int i = 0; i < arrListURLInfoinDeletebutton.Count; i++)

{

for (int j = 0; j < arrListListofWebHierarchyinDeletebutton.Count; j++)

{

if (arrListURLInfoinDeletebutton[i].ToString().CompareTo(arrListListofWebHierarchyinDeletebutton[j].ToString().Trim()) == 0)

{

listflag = listflag + 1;

}

}

if (listflag <= 0)

{

arrListfordeletelist.Add(arrListURLInfoinDeletebutton[i]);

}

else

{

listflag = 0;

}

}

SPList olist = oweb.Lists["RequestASiteList"];

SPListItemCollection itmcollection = olist.Items;

for (int i = 0; i < arrListfordeletelist.Count; i++)

{

for (int j = 0; j < itmcollection.Count; j++)

{

SPListItem objsplistitem = itmcollection[j];

if (arrListfordeletelist[i].ToString() == (objsplistitem["url"].ToString()).ToLower())

{

itmcollection.Delete(j);

}

}

}

}

catch (Exception ex)

{

lblException.Text = ex.ToString();

}


}

}

}

Customising Welcome message of the site

Hi,

There may be the situation where you may have to customise the welcome message which will be on the right top of the site.For that i got the good link.Now my requirement was displaying the message based upon the intranet/extranet site.For that initially i have written the below code in welcome.ascx but the problem is it use to execute if condition always

Finally after seeing the link

http://www.wictorwilen.se/Post/Having-fun-with-the-SharePoint-Welcomeascx-control.aspx

what i did is

I took a custom user controlcustomwelcome.ascx and copy pasted the code of welcome.ascx in it and I have wriiten code in webpart as

namespace CustomWelcome {

public class Welcome : Microsoft.SharePoint.WebControls.Welcome {

protected Welcome() {

}

[SharePointPermission(SecurityAction.Demand, ObjectModel = true)]

protected override void OnLoad(EventArgs e)

{

base.OnLoad(e);

if (HttpContext.Current.User.Identity.IsAuthenticated)

{

if (HttpContext.Current.User.Identity.AuthenticationType==”Forms”)

{

PostCacheSubstitutionText pt = base.ExplicitLogout.MenuControl.Controls[0]

as PostCacheSubstitutionText;

pt.TextType = PostCacheSubstitutionTextType.UserName;

pt.SuffixHtml=”(Extranet)”

}

Else

{

PostCacheSubstitutionText pt = base.ExplicitLogout.MenuControl.Controls[0]

as PostCacheSubstitutionText;

pt.TextType = PostCacheSubstitutionTextType.UserName;

pt.SuffixHtml=”(Intranet)”

}

}

}

}

}

Dynamic Navigation

DynamicNavigation.cs

There is a list called DocListNames.Now I shld display the items of the Title field in the form of the table.Actually the items in Title field of MBIADocListNames list are document library names of the site and based upon the Display Indicator field value Yes it has to display the document library names

For this the code is

protected override void Render(System.Web.UI.HtmlTextWriter writer)

{

SPSite objsite = SPContext.Current.Site;

SPWeb objweb = SPContext.Current.Web;

SPList objlist = objweb.Lists["DocListNames"];

string camlquery = " Yes";

SPQuery query = new SPQuery();

query.Query = camlquery;

SPListItemCollection listItemCollection = objlist.GetItems(query);

if (listItemCollection.Count > 0)

{

writer.Write("

");

writer.Write("

");

foreach (SPListItem itmlist in listItemCollection)

{

string title = (itmlist["Title"]).ToString();

writer.Write("

");

}

writer.Write("

");

writer.Write("

"); writer.Write("&nbsp"); writer.Write(""); writer.Write(title); writer.Write(""); writer.Write("&nbsp"); writer.Write("

");

}

}

Form Based Authentication in WSS/MOSS 2007

Create Database using-C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727

Create a asp.net site and add new item web.config- add the below entry For Extranet and for Internet sites

Use asp.net web site administration tool to add user

Extend the web site for Internet - set proper setting

======================================

For Extranet and for Internet sites

====================

connectionString="server=servername;database=databasename;Integrated Security=SSPI;"

providerName="System.Data.SqlClient"/>

====================

In Central Admin

type="System.Web.Security.SqlMembershipProvider, System.Web,Version=2.0.0.0, Culture=neutral,PublicKeyToken=b03f5f7f11d50a3a"

connectionStringName="AcSqlConnString"

enablePasswordRetrieval="false"

enablePasswordReset="true"

requiresQuestionAndAnswer="false"

applicationName="/"

requiresUniqueEmail="false"

passwordFormat="Hashed"

maxInvalidPasswordAttempts="5"

minRequiredPasswordLength="1"

minRequiredNonalphanumericCharacters="0"

passwordAttemptWindow="10"

passwordStrengthRegularExpression=""

/>

type="System.Web.Security.SqlRoleProvider, System.Web,Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"

connectionStringName="AcSqlConnString"

applicationName="/"

/>

==========================

Now add the users to parent sites

==============================

Start testing the extended sites.

==================================

Best of luck

MOSS 2007 interview Questions

Hi,

After attending so many interviews i am posting the questions.Go through and i wish you All the Best

//Honeywell interview questions
1)Difference b/w SqlDataReader and DataSet?
2)How do u return values from stored procedure to C# Windows Application?
3)Through DataReader could you return multiple values like if i write query as 'select * from emp,acc'?
4)what is EnsureChildControls?
5)If Manager approves the mail only Delivery Manager has to get the alerts what wil u do?
6)If you wanna to add the exe file format in the Document library what will u do?

//Envaiya Infotech questions
1)Diff b/w site definition and site template?
http://www.sharepoint4arabs.com/AymanElHattab/Lists/Posts/Post.aspx?ID=85
http://www.c-sharpcorner.com/uploadfile/Roji.Joy/differences-between-site-definition-and-site-templates/
http://www.getproductprice.com/Ads-difference-between-site-definition-and-site-template.aspx
2)what is ghosting?
http://www.a2zdotnet.com/View.aspx?Id=87
3)what is .stp?
4)what is the purpose of XSLT?
5)what are event handlers?
6)Diff b/w WSS and MOSS 2007?
http://blogs.thirdm.com/?p=24
http://www.c-sharpcorner.com/uploadfile/sarav82/features-of-wss-3-0-and-moss-2007/
7)what is Infopath?
8)what is DWP?
9)how will you filter the data through designer?
10)After installing MOSS 2007 exactly after 180 days u will get one error what is that error?

//2nd Round Envaiya Infotech questions
1)what are the characteristics of polymorphism?
2)How do u configure MOSS 2007?
3)Reg Ghosting and unghosting?
4)what are the types of JIT Compilers?
5)Characteristics of OOPS?
http://www.indiastudychannel.com/resources/22135-Characteristics-OOP.aspx

//Emc2 interview questions
1)If i add 'Reader' permission in Central Administration and 'Contributor' permission in Site Collection which would have the first priority?
2)Have you created any site based on the geographical locations?
3)In infopath if i enter your name manager name should get visible what will you do for that?
4)If any user is not able to login what would be your first step to fix it?
5)Have you worked on Lotus Notes?
6)what changes you have noticed after migrating the portal?
7)Virtual funcion in C#?
8)Difference b/w virtual and abstract?

//Enviya infotech final round questions
what are the different types of validation controls?
what is an identity in SQL 2005?
what is .NET Frame work 2.0?
what is an o/p paramter in stored procedure?
what is the diff b/w stack and heap?
Diff b/w DataGrid and GridView?
what is object data source?
Diff b/w Array and ArrayList?
How do u call sp1 in sp2?
what is the membership of Login control in ASP.NET?
what are the state management techniques in ASP.NET?
Diff b/w session and view state?
what are enums?
Let us assume that there is an enum called color and items are red,blue,yellow then how will u add the enum to get all items in drop down list?
Characteristics of OOPS?
what is data encapsulation?
Diff b/w authorisation and authentication?
what are cursors?
what are triggers?
Diff b/w session and application?
what is the use of Hash Table?

//Intelli group questions
1)what are the files you get while installing solution package?
2)Site content types?
3)Publishing in MOSS 2007?
4)Difficulties faced while migrating 2003 to 2007?
5)diff b/w stored procedure and udf?
6)where content db comes into the picture?
7)how many web app's you can create?
8)can web app come under 2 SSP's?
9)life time of a view state?
10)diff types of session management techniques?
11)diff b/w executescalar,dataset,executenonquery?
12)what is a safe control tag in web config file?
13)what is AllowUnsafeUpdates?
http://rameshsps2010.blogspot.com/2011/06/allowunsafeupdates-vs.html
14)what is cab file,ddf file?
15)what is crawling?
16)how many site collections you can create?

//CGI Interview Questions(ultimate questions)
1)What is partial class?
2)what is a sub query.Can you write it?
3)what is an extended stored procedure?
4)what are generics?How will u declare.Can you just write and show it to me?
5)In stored procedure how will you return the value just write it down?
6)what is the tool that you have used while converting portal from SPS2003 to MOSS 2007?
7)If i want to add some option in the Site Actions of the site what will u write in feature just write it down?
8)Have you created site template.How will you use it in another site?
9)There are two sites called as site A and site B.Through object model i should display all the items in document libraries of site A in site B but i don't have the persmissions for site A at all then how should i manage this?
10)Through variance how will you manage through object model?
11)How will change the themes.Can you tell me the procedure?
12)what are the different security permission levels in MOSS 2007?

//Accenture interview
What did u do in share point administration?
what is SSP?
what will Manage properties will do in search settings of SSP?
what is infopath?
Is there any tool that will be helpful in generating workflows?
what is infopath?
what is a feature?
what is the command to install feature?
what is the command to uninstall feature?

//Interview questions of wipro
How did u change the themes in MOSS 2007?
How will u create custom site definition?
Have u worked on search?
How will u create List through object model?
How will u deploy the web part?
How will you find the broken links?
Have u created ur own appliction in that?
what is ur role in the project?
what is the diff b/w private & protected modifier?

Diff b/w session & view state?
Difference b/w method overloading and overriding?
http://www.freejobsreference.com/dotnetforums/111-What-is-the-difference-between-Method-Overloading-and-Method-Overriding-in-C-Sharp-NET.aspx
How will u declare the stored procedure and in that how will u declare i/p & o/p parameters.Just write down and show it?
what is @ in stored procedure?

//SLK Software
After installing fetures it should not be in list of features what will u do for that?
How will u deploy the web part?
I just want to see the coding standards when u write the code in web part?
what is major diff b/w user ctrl and custom control?
what will the override key does?
Instead of hard coding the listname how can u get the listname to fetch the data?
How can we interact the two web parts
Have u heard of wsp package?
what about the architecture in MOSS 2007?
why shld we do iisreset?

//Intelli group
what is CLR?
Diff b/w Stored procedure and UDF?
In table1 there are empno,empname and in table2 there are empno, deptname now what is the query to fetch the deptname?
Boxing and unboxing?
Diff b/w view state and session?
what are state management techniques?
what is disconnected architecture?
what is Page Lay out?

//Proteans interview questions
How do ASP.NET page knows that it should post back?
How many generations are there in garbage collector?
what is the structure of OOPS?
Does C# support multiple inheritance?
Can you tell me how will u declare delegate?
How polymorphism helps in C#?

//DELL-Perot Systems Interview questions
Page Life cycle in ASP.NET?
what are the state management techniques in ASP.NET?
Have u used any state management techniques?
what are the ctrls that you have used in ASP.NET?
To put the check box in each row of the grid view what will u do?
Have u used the user ctrl?
what is the data source?
what is stored procedure?
what is execution plan?
what is function?
Have u used joins?
what is self join?

//Aditi Technologies
what is SSP?
what is polymorphism?
what is the difference between Method overloading and method overriding?
Have u done any search web part?
In which moment i should i create a web application?
what is application pool?
I just want to set up the search with in the document library.How can i do that?
Puzzle:There are 3 boxes.On each of the boxes there is one label as Red,Green and Mix.Of course there may/may not be the correct color balls.In one shot you correct the labels of the boxes.How will you do that?
For suppose there are 2 users A and B.User A has full control on particular list just say List1 and B has only permission to view the particular row in the list.Now will user A will be able to see the list?
what is data abstraction?

//Innovation interview questions
Diff b/w Application pages and site pages?
where can u find the master pages(path)?
Suppose there are different sites under one site coll.I should have seperate master page for each site.How wil u do that?
Is there any other object in share point object model to work with mails?
Tell me the hierarchy of web app,site coll,sites,sub sites?
Should we include both SPWeb,SPSite while dealing with share point object model?
There is label and button in the web part.My requirement is after entering the value from textbox it should inserrt the item in the list.For that how wil u write the code?
Is there any field level permission in share point?