Thursday, September 2, 2010

Introducing SharePoint Designer 2010

Microsoft SharePoint Designer 2010 is a Web and application design program for building and customizing Web sites running on SharePoint Foundation 2010 and Microsoft SharePoint Server 2010.
With SharePoint Designer 2010, you can create data-rich Web pages, build powerful workflow-enabled solutions, and design the look and feel of your site. The sites you create may range from small project management team sites to dashboard-driven portal solutions for the enterprise.
Sites you create with SharePoint Designer 2010
SharePoint Designer 2010 delivers a unique site authoring experience by providing one place where you can create a SharePoint site; customize the components that make up the site; design the logic of the site around a business process; and deploy the site as a packaged solution. You can do all this without writing a line of code.
In the following sections, you’ll learn about SharePoint Designer 2010 and how you can get started using it in your organization.

The Microsoft SharePoint Designer 2010 experience

SharePoint sites are quickly becoming more complex as they scale to the needs of businesses of all types and sizes. They have moved from being a repository of documents, task lists, and schedules to become highly dynamic, data-rich, business process-driven sites.
For the site designer, this means not only understanding the needs of the business, but understanding a SharePoint site and all of the parts that make up the site. It’s especially important to understand the relationships between the many moving parts of the site, and to be able to manage all of this in one place.
SharePoint Designer 2010 provides a single environment where you can work on your site, its lists and libraries, pages, data sources, workflows, permissions, and more. Not only can you see these key ingredients of your site in one place, but you can see the relationships between these objects.
The framework is there for you to start designing and building highly customized business solution sites. Start by connecting to data sources, both inside and outside of SharePoint. Present this information to users and let them submit information back, using a SharePoint site or an Office client application. Create highly customized workflows that automate business processes. Lastly, customize the look and feel of the site so that it matches the branding of your organization.
By providing one environment for these tasks, you spend more time designing, building, and customizing solutions and less time searching for and updating the various components of a site using different tools and methods.
The following sections explore the SharePoint Designer 2010 experience and user interface:


Opening SharePoint Designer 2010

SharePoint Designer 2010 is a client program that installs on your local computer. It is also tightly integrated with SharePoint. As such, it can be launched directly from your machine using the Windows Start Windows Start button menu and various places in SharePoint, such as the Site Actions menu as shown here.
SharePoint Designer 2010 in Site Actions menu
There are a number of places where you can open SharePoint Designer 2010 from within SharePoint when customizing lists, views, workflows, and master pages.
 Note    If your organization chooses to restrict access to SharePoint Designer 2010 or some of its editing capabilities, these permissions can be managed from within SharePoint, such as the Site Settings page and in Central Administration. If you're a user of SharePoint Designer 2010 and you don't see it as described in this article, this may be the cause.
If you haven’t installed SharePoint Designer 2010 yet, the first time you launch it from SharePoint, you’re prompted to download and install it from the Web. The next time you open SharePoint Designer 2010, it opens immediately. It’s also available in the Windows Start menu.
Learn more about the different ways you can open SharePoint Designer 2010 in the See Also section.
 Note    SharePoint Designer 2010 is designed for sites running on SharePoint Foundation 2010 and Microsoft SharePoint Server 2010. It cannot be used with earlier versions of SharePoint.
Top of Page Top of Page

SharePoint Designer 2010 File tab

When you open SharePoint Designer 2010 from the Windows Start menu, the first thing you see is the File tab. You have the option to customize an existing site or create a new site on this screen.
SharePoint Designer 2010 illustration
To customize an existing site, you can browse to an existing site, customize your My Site, or select one of the recent sites you’ve opened in SharePoint Designer 2010.
To create a new site, you can use a blank template, choose from a list of templates, or choose from one of the featured templates. From here, just specify the server and a site name and create the site. Your site is created and then opens in SharePoint Designer 2010.
If you open SharePoint Designer 2010 from SharePoint, you won’t see this screen. Instead, you’ll see your site open in the SharePoint Designer 2010 interface.
Top of Page Top of Page

The SharePoint Designer 2010 user interface

SharePoint Designer 2010 provides one environment where you can create, customize, and deploy SharePoint sites and solutions. This is made possible by the user interface, which shows all of the components that make up your site and the relationships between those components.
When you first open your site, you see a summary of the site, including its title, description, current permissions, and subsites.
SharePoint Designer 2010 illustration

Three-part interface: Navigation, Summary, and Ribbon

There are three main areas of the SharePoint Designer 2010 user interface that you work in to design and build SharePoint sites:
  1. Navigation pane is used to navigate the major parts, or components, of your site
  2. Gallery and Summary pages to see lists of each component type and summaries of one particular component.
  3. Ribbon to perform actions on the selected component.
SharePoint Designer 2010 illustration
The Navigation pane shows the components that make up your site–its lists, libraries, content types, data sources, workflows, and more. To edit one of the components, an Announcements list for example, you open Lists and Libraries, and this takes you to a Gallery page showing all lists and libraries.
From there, you can open the Announcements list, and this takes you to a Summary page for that list. On the Summary page, you see its associated views, forms, workflows, and more. To edit one of the views, just open it directly from this page.
With the view open, you'll notice that the Ribbon changes to display the most common and contextually relevant editing tasks for editing views. If you’re familiar with the Ribbon in Microsoft Office applications, you know that it makes creating and editing tasks quick and easy. When you’re finished editing, use the Back button or the breadcrumb-style navigation at the top of the page to return to the summary of your site.
The SharePoint Designer 2010 interface makes it easy to identify the various components of a site, drill down and edit one of those components, and then return back to the main view of the site.

Opening the File tab

In addition to working on the various objects of your site in SharePoint Designer 2010, you may want to view and access larger site or application settings. This includes opening another site, adding pages, importing files, and changing SharePoint Designer 2010’s application settings. You perform these actions on the File tab, which is the first screen you see if you open SharePoint Designer 2010 from the Windows Start menu or a shortcut on your desktop.
Click the File tab in the upper left to go to this view. Click Back to return to the SharePoint Designer 2010 interface.
Top of Page Top of Page

Pillars of customization in SharePoint Designer 2010

SharePoint Designer 2010 can be used to perform nearly any level of site customization in SharePoint. You can use it, for example, to customize a view, add a data source, or modify a workflow. But you really start to harness the power and capabilities of SharePoint Designer 2010 when you turn an out of the box SharePoint site into a real business solution for your organization.
The following sections cover four pillars of site customization that you perform as you design and build solutions using SharePoint Designer 2010.

Connect to data inside and outside of SharePoint

With SharePoint Designer 2010, you can connect to numerous data sources and then integrate that data into your SharePoint site and Office client programs. Your users, as a result, can see and interact with business data on your site and from within the programs you choose rather than having to connect to those data sources separately.
SharePoint Designer 2010 illustration
Directly from the Ribbon, you can connect to an external database, SOAP Service, REST Service, and more.
Connecting to data sources is a powerful feature of SharePoint Designer 2010 because there are so many supported options you can use to make data available to your users. With data connections, you can bring together SharePoint lists and libraries, external databases and data sources, Web services, and more.
Here’s a preview of the data sources you can connect to using .


Lists and libraries

SharePoint lists and libraries are a common data source you’ll use on your SharePoint site. They’re unique compared to the other data sources in that they’re already part of SharePoint and use the same database as SharePoint. You don’t need to perform any steps to create a connection to these data sources – you just add them using the Lists and Libraries gallery in SharePoint Designer 2010 or add them in the browser using SharePoint. Once you create a list or library, you can customize its associated columns, content types, and other schema attributes.

External business data

One of the most powerful capabilities of Microsoft SharePoint Technologies is the ability to connect external business data sources—SQL Server, SAP and Siebel, Web services, and custom applications—to SharePoint Web sites and Office client applications. This is done using Business Connectivity Services (BCS), a SharePoint-based framework that provides standardized interfaces to existing business data and processes.
In SharePoint Designer 2010, you connect to the external data by creating external content types. External content types represent the data in the external data source by storing the details of the connection, objects used in the business application, methods to create, read, update, or delete, and actions users can take on the objects themselves.
The external content type is stored in the Business Data Catalog. Once you create the external content type, you and others in your organization can easily create SharePoint lists, views, forms, workflows, and even Office client integration based on it. The external data becomes part of SharePoint like any other component, which allows you to create completely customized user interfaces to these external data sources.

External databases

Adding a database as a data source allows you to integrate data from another database into SharePoint. You can connect to Microsoft SQL Server, Oracle, and any database that supports the OLE DB or ODBC protocols. You just need to know the name of the server where the database is located, the data provider, and the type of authentication to use. Once you add and configure the database as a data source, you create views and forms that allow your users to read and write data back to the data source without ever leaving the SharePoint site.

XML Web services via SOAP

Simple Object Access Protocol (SOAP) is a protocol for exchanging XML-based messages, making it possible to connect to various data sources using an XML Web service. In SharePoint Designer 2010, you can use this to connect to a data source on another site in your organization or a site on the Internet regardless of its technology, programming language, or platform. You could use an XML Web service to display a currency converter, stock quote, calculator, or weather service on your site.

Server-side scripts via REST

Representational state transfer (REST) is an architectural style of networked software that takes advantage of the technologies and protocols of the Web, not just a method for building Web services. You can use this type to get data from a site by reading a designated server-side script that describes the content. Similar to SOAP, you could use this in SharePoint Designer 2010 to connect to a data source on another site to display, for example, a currency converter, stock quote, calculator, or weather service. This type of data connection is simpler than SOAP to implement but is restricted to HTTP.

XML source files

If your organization stores data in XML files, you can connect to these files as a data source in SharePoint Designer 2010. To connect to the XML files as a data source, you can create them directly in SharePoint Designer 2010, import them from a location on your computer or network, or connect to them on an external location.
Learn more about connecting to data sources in SharePoint Designer 2010 in the See Also section.
Top of Page Top of Page

Create interactive data-rich interfaces

Once you establish connections to the necessary data sources, you’re ready to create interactive, data-rich interfaces for your users to these data sources. With SharePoint Designer 2010, you can create powerful and dynamic user interfaces for data sources, and you can make them available in a number of places, including your SharePoint site and custom windows, panes, and fields in Office business applications.
Open site in SharePoint Designer 2010
The interfaces you create include custom views, forms, Web Parts, navigation, and custom Office client windows and task panes. This kind of flexibility allows you to create completely customized user experiences to your business data.
You might combine multiple data sources into a single view, create dashboards with related item views, design custom forms tailored to individual roles, and customize the available toolbars and Ribbon commands associated with the data.
Here are the many ways you can customize the user interface associated with your data using .


Views

Views allow you to see live data in different ways. Whether you’re looking at a SharePoint list or library or an external data source, you can use views to show the information that is relevant to you and your users. In SharePoint Designer 2010, every view you create is a Data View that displays in XSLT (Extensible Stylesheet Language Transformation), and it leverages Microsoft ASP.NET technology. In a view, you can show and hide fields, sort, filter, calculate, apply conditional formatting, and more. There are several View Styles that you can choose from as well to quickly get started. Ultimately, you can create and customize any view to fit your data model, your users, and your business.

Forms

To collect information from users, you create forms. With highly customized Web-based forms, users can easily write data back to a data source. Similar to views, you can customize the appearance of fields based on the state of the data, user role, and more. Forms can be used to display data, edit data, and create data, and you can design forms using SharePoint Designer 2010’s built-in forms editor (for .aspx files) or Microsoft InfoPath (for .xsn files). Forms can be created and customized for specific data sources, such as a task list, and they can be used to collect user information in a workflow, as explained later.

Custom actions

Using the Custom Action builder in SharePoint Designer 2010, you can create custom actions, such as links, icons, and scripts to the SharePoint Ribbon, toolbar, and list item menus. Anytime you add new functionality to the site, you can make it easier for your users to discover it and use it by exposing that functionality in a SharePoint menu. You can also use custom actions to encourage users to perform certain tasks on a given object, such as starting a workflow on a list.

Web Parts

Web Parts are modular units of information—a self-contained data or feature—that is added to a SharePoint page. The views and forms described earlier are stored in Web Parts, but in addition to these, you can add Web Parts that perform a number of functions and ways to interact with data. Users can further customize Web Parts in the browser if you add them to a Web Part zone in SharePoint Designer 2010. Web Parts and Web Part Pages are a powerful and effective way to customize the Web interface for your users in SharePoint.

Client integration

For external data sources that use external content types, you can surface that information in client applications like Microsoft Outlook 2010 and SharePoint Workspaces. You can create an interface for users to read, write, and delete the external business data just as if it were part of the application. You do this with client forms, regions, and task panes. Your users, as a result, get to work with their business data on the SharePoint sites and Office applications they know best and are already using.

Navigation

Navigation plays a key part in the interfaces you create for your users, and it’s an area that you manage throughout SharePoint, not just SharePoint Designer 2010. For example, you might customize navigation links within a Data View or form, a Web Part, a workflow, or at the site level, such as the top link bar or Quick Launch. You want to make sure that the site and all of its parts have a well-planned navigation model that your users can follow.
Learn more about creating data-driven interfaces in SharePoint Designer 2010 in the See Also section.
Top of Page Top of Page

Manage business processes

Every business process in an organization consists of a set of activities that are tied together based on a common business need. SharePoint workflows are designed around this model by providing rules-based workflows consisting of sets of conditions and actions. You organize and run a series of actions that correspond to a work process based on a sequence of conditions and actions.
SharePoint Designer 2010 illustration
You can create workflows using SharePoint Designer 2010 that manage the simplest to the most complex business processes in an organization. Workflows do this by automating both business application processes and human collaborative processes. Workflows for business application processes might update one data source when another data source changes; and workflows for human collaborative processes might send a document to an employee's manager for approval.
A SharePoint workflow introduces application logic to your business processes without requiring you to write code. This is made possible by the powerful yet intuitive workflow designer in SharePoint Designer 2010 that allows nested logic, substeps, and more. Alternatively, you can design and share workflows using Microsoft Visio with its flowchart templates that can be exported to SharePoint Designer 2010.
SharePoint Designer 2010 illustration
Following are the building blocks of a workflow in .


Events

An event is what starts or initiates a workflow. A change to a data source—such as a new item created or an item changed—is one type of event. Another type of event is one activated by a user, a workflow participant. Workflows that start when a data source changes are typically part of an application focused workflow to automate a business process, such as copying files based on the state of data. Workflows that can be started by users are typically part of a human collaborative workflow, such as content approval. Workflows can be set up to recognize both types of events and can even be based on a combination of the two.

Conditions

Conditions determine when a workflow runs or performs an activity. Since workflows are associated with a data source, the condition specifies the change to the data source that must take place for the workflow to happen. Conditions typically start with the clause “If field equals value.” One condition can be used with multiple actions, and multiple conditions can be used with one action. Rules combine conditions with one or more actions: If all clauses in the condition are true, the associated action takes place.

Actions

Actions are the most basic units of work in a workflow. When you design a workflow, you identify the necessary sequence of actions, and then you assemble that sequence of actions in the Workflow Designer. You can set them up so that they occur one after the other (serial actions) or both at the same time (parallel actions). The workflow can contain any number of actions, performed by the workflow itself or the participants in the workflow. SharePoint Designer 2010 includes a rich selection of ready-made, reusable actions. Your workflows can, for example, send an email, check an item in or out of a list, send items for approval, copy an item from one list to another, do a calculation, and assign items for approval.

Steps

Workflows are comprised of one or more steps and substeps. Steps allow you to group conditions and actions so that one set of rules can be evaluated and performed before a second set. Each step may contain any number of conditions and actions. Your workflow can be designed as a sequence of actions in a step or a substep. The rules in one step are processed to conclusion before going on to the next step, so you want to group in the same step any rules necessary to effect the specific action or actions that you want. Steps can also be used as a way to organize your workflow, especially if it has numerous actions and very few conditions.

Forms

Workflows often contain forms that allow you to collect information from workflow participants at predefined times in the workflow. They also allow participants to interact with the tasks associated with a workflow. In a workflow, you can design initiation forms to gather information from users when they start the workflow, association forms to associate the workflow with a list or content type, forms for custom tasks associated with the Tasks list. When designing forms, you can use the native ASP.NET-based forms (.aspx pages) in SharePoint Designer 2010 or custom forms (.xsn pages) designed with Microsoft InfoPath 2010. InfoPath offers much more in customization and branding for your workflow forms.

Variables

A variable is a data storage location or cache inside a workflow. Using variables, you can store different types of data in a workflow and at a later point, reference that data using workflow lookups. There are many types of variables you can use in a workflow. You can use, for example, variables generated by initiation form parameters and local variables, which hold data associated with the current workflow. In a local variable, you can use numerous variable data types, including Boolean, Date/Time, List Item ID, Number, and String. After you create a variable and set it to a value, you can reference that variable in a condition or action later in the workflow.
Top of Page Top of Page

Design and brand

The final area of customization provided by SharePoint Designer 2010 is design and brand—that is, taking your corporate look and feel and applying it to your SharePoint site. You can incorporate a company logo, color scheme, headers and footers, supporting graphics, custom navigation, and more. As a result, every page on the site can be immediately recognized as being part of a larger corporate site. In SharePoint Designer 2010, you design and brand SharePoint sites using master pages, page layouts, and cascading style sheets.
SharePoint Designer 2010 illustration
Designing and branding a site is different from the other pillars of customization, where the focus is on creating custom business solutions. Branding is something you generally perform less often and at the top of a site collection—for example, an Intranet or Internet-facing portal. That custom brand is then inherited by the subsites created below it. The branding effort is also likely to be performed by a Web designer rather than a solution creator.
For these reasons, master pages, page layouts, and cascading style sheets are all disabled by default for all users except site collection administrators. This way, only those responsible for the site brand have access to these powerful, yet sensitive files. You can, of course, re-enable them for specific users.
As a site designer, here are the ways you can create a custom brand for your sites using .


Master pages

Master pages are a feature of ASP.NET, and they’re included with SharePoint as a way to design the layout of your site in one place and reuse it as a template for other pages across the enterprise. Every time you view a page on a SharePoint site, you’re viewing two pages merged together – a master page and a content page. The master page defines the common layout and navigation (which typically make up the left, top, and bottom portions of the page). The content page supplies page-specific content. SharePoint Designer 2010 provides a rich set of page editing tools that you can use to customize your master pages and share them with others.

Page layouts

If you’re working with a publishing site, you also design the appearance and layout of the site using page layouts. Page layouts serve as templates for the publishing pages created by users in your organization. In addition to the master page, they provide granular control and structure for a publishing page, such as designating where a title, body text, and graphics can be placed on a page. Publishing pages use the publishing infrastructure in SharePoint, and they help you streamline browser-based content authoring and publishing without all the overhead typically associated with the process.

Cascading Style Sheets

Like most Web sites and Web applications, SharePoint uses cascading style sheets (CSS) to apply colors, graphics, and positioning to the various objects that make up the pages on a site. In many cases, there are multiple style sheets applied to a page. To customize these styles, you can modify them directly in the master page, page layout, or site page, or modify the styles directly in the CSS file attached to the page – both of which you can do using the powerful CSS editing tools in SharePoint Designer 2010. You can also customize your SharePoint themes using CSS files. By customizing CSS files, you alter the look, or “skin,” of a SharePoint site so that it has your corporate look.
Top of Page Top of Page

Deploy custom SharePoint solutions

Everything up to this point has focused on how you can use SharePoint Designer 2010 to create real business solutions. You’ve seen that you can connect to and integrate with data both inside and outside of SharePoint, create powerful user interfaces to this data, manage business processes with workflows, and brand the site to match your corporate look and feel.
But now you need to do something with your solutions – such as deploying it to another server or across the enterprise, opening it in Visual Studio for additional customization, or saving it offline to take it on the road with you. You need a way to turn your solution into a package, and this is where the Save as Template option comes in.
SharePoint Designer 2010 illustration
The ability to save a solution as a template is a powerful feature of SharePoint. The template is saved as a Web Solution Package (a .wsp file) that contains the entire contents of your site, including data sources and structure, views and forms, workflows, and Web Parts.
Templates are granular too. You might be working on one specific part of the site, like a list, a view, or a workflow. You can save these as individual components as templates too, which presents a whole new way to collaborate on solution development.

Completing the business solution cycle in SharePoint

As you spend more time in SharePoint Designer 2010, you quickly realize that you can do much more than basic site customization. You can create real business solutions that contain data connections, data-rich user interfaces, custom workflows, and complete site branding. You can build it all on SharePoint, and you can follow an application development lifecycle that ends with a deployable solution.

Tuesday, August 31, 2010

How to display items of list in datagrid using silverlight in sharepoint 2010

<data:DataGrid AutoGenerateColumns="True" Canvas.Left="21" Canvas.Top="12" Height="136" Name="dataGrid1" Width="714" >

</data:DataGrid>

.CS File

using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Animation;
using System.Windows.Shapes;
using Microsoft.SharePoint.Client;
using SP = Microsoft.SharePoint.Client;
using System.Windows.Data;
namespace RegisterMemberInfo
{
public partial class MainPage : UserControl
{
public class Courses
{
public string Title { get; set; }
public string CourseName { get; set; }
public string ID { get; set; }
public string StartDate { get; set; }
public string EndDate { get; set; }
public string Location { get; set; }
public string EditCourseURL { get; set; }
public string BatchSize { get; set; }
public string RegisterMember { get; set; }
public string Fees { get; set; }
public string HeaderText { get; set; }
//public List<RegisterMemb> students { get; set; }
}
public MainPage()
{
InitializeComponent();
comboBox1.Items.Clear();
LoadInfo();
}


IEnumerable<ListItem> lstenum;void LoadInfo()
{
Web wb = ClientContext.Current.Web;
List lstname = wb.Lists.GetByTitle("Course Details");
CamlQuery camlQuery = new CamlQuery();
camlQuery.ViewXml = "<View><Query><OrderBy> <FieldRef Name='Title' /></OrderBy></Query></View>";
var lstQry = from l in lstname.GetItems(camlQuery)
select l;
lstenum = ClientContext.Current.LoadQuery(lstQry);ClientContext.Current.ExecuteQueryAsync(succeed, fail);
}


void succeed(object sender, ClientRequestSucceededEventArgs args)
{
this.Dispatcher.BeginInvoke(displayList);
}


void fail(object sender, ClientRequestFailedEventArgs args)
{
}


void displayList()
{
var list = new List<Courses>();
//dataGrid1.ItemsSource = lstenum;
// comboBox1.ItemsSource = lstenum;
foreach (var lstvar in lstenum)
{
comboBox1.Items.Add(lstvar["Title"]);
list.Add(new Courses
{
Title = lstvar["Title"].ToString(),
ID=lstvar["ID"].ToString(),
StartDate = lstvar["StartDate"].ToString(),
EndDate = lstvar["EndDate"].ToString(),
Location = lstvar["Location"].ToString(),
});
}
dataGrid1.ItemsSource = list;
}}}

Monday, August 30, 2010

How to implement Silverlight application and deploy it on Sharepoint 2010 server

Step I

-Open Visual Studio 2010

-File-->New-->Project

-It displays the Project menus,Then On Left hand side shows Recent Template give below that shows installed Templates Now you have to select Silverlight Project --> Select Silverlight Application On Right Side-->Give Proper Application Name to this.


-Now after that shows the one pop up window.In the pop up window New Project Name option it shows YourApplicationName.Web keep this as it is,Next New Web Project type:Select ASP.NET Web Application Project, After that in Silverlight Version :Select Silverlight 3.Click OK






On the Design Portion drag and drop the controls fron tollbox.






-Double Click on Button it displays the .cs file (code File)


Type The Following code on it

private void button1_Click(object sender, RoutedEventArgs e)
{
if(textBox1.Text!="")
MessageBox.Show(textBox1.Text );
}




-Build the solution-->Go to Project Directory Where your Silverlight Application located-->Double click SilverlightApplication1.Web Folder-->Double Click ClientBin Folder

in side this Folder We Shows the SilverlightApplication.xap File(.Xap).Copy it on your Desktop.


-Now open your Sharepoint 2010 site.Open the Library-->open Shared Document-->Upload .Xap File on this library.


-Right Click on the uplaoded File-->Properties-->copy the Address(URL) of your File.

-Go to the Add New WebPart-->select Media And content-->Click Silverlight WebPart-->Click Add

-It will display pop up window You should paste the URL that are located the .Xap file in you Shared documents.



-Click ok



-And Finally it will display the silverlight WebPart.

How to implement Silverlight application and deploy it on Sharepoint 2010 server

Step I
-Open Visual Studio 2010
-File-->New-->Project
-It displays the Project menus,Then On Left hand side shows Recent Template give below that shows installed Templates Now you have to select Silverlight Project --> Select Silverlight Application On Right Side-->Give Proper Application Name to this.



-Now after that shows the one pop up window.In the pop up window New Project Name option it shows YourApplicationName.Web keep this as it is,Next New Web Project type:Select ASP.NET Web Application Project, After that in Silverlight Version :Select Silverlight 3.Click OK




On the Design Portion drag and drop the controls fron tollbox.




-Double Click on Button it displays the .cs file (code File)

Type The Following code on it
private void button1_Click(object sender, RoutedEventArgs e)
{
if(textBox1.Text!="")
MessageBox.Show(textBox1.Text );
}

-Build the solution-->Go to Project Directory Where your Silverlight Application located-->Double click SilverlightApplication1.Web Folder-->Double Click ClientBin Folder

in side this Folder We Shows the SilverlightApplication.xap File(.Xap).Copy it on your Desktop.

-Now open your Sharepoint 2010 site.Open the Library-->open Shared Document-->Upload .Xap File on this library.



-Right Click on the uplaoded File-->Properties-->copy the Address(URL) of your File.
-Go to the Add New WebPart-->select Media And content-->Click Silverlight WebPart-->Click Add
-It will display pop up window You should paste the URL that are located the .Xap file in you Shared documents.




-Click ok
-And Finally it will display the silverlight WebPart.

Wednesday, August 25, 2010

Creating and Using External Lists in SharePoint 2010

This example illustrates how to create a Business Connectivity Services (BCS) with an external content type using Visual Studio and utilize this content type in a SharePoint external list.

Feature Overview

An external list is a list based on data from an external system outside of SharePoint such as a CRM system or relational database.

Task 1: Create a new Business Data Catalog Model project.

1. Open Visual Studio 2010 from the Start | Programs | Visual Studio 2010 menu.

2. Create a new project by using File | New Project.

3. Pick the SharePoint | 2010 templates.

4. From the SharePoint | 2010 templates select the Business Data Connectivity Model template.

5. Use BCSExample as the name.

6. Set the location to be C:\SPHOLs.

7. Press OK to create the project.

image

8. On the SharePoint Customization Wizard dialog, type the address of the site you want to deploy to, and select to deploy this as a farm solution.

9. Click Finish to proceed.

image

Task 2: Extend the custom entity to allow updating.

1. Click on the Entity1 | Methods area in the designer.

2. This brings up the BDC Method Details window for Entity1.

3. At the bottom of this window (you may need to scroll) find the Add a Method area.

4. Open the combo box on the Add a Method area and select Create Updater Method.

image

5. Select the newly created method called Update to retrieve the properties pane. Change Is Static = True.

image

Task 3: Add the code to store list data in an in memory collection.

1. Right click on Update and select View Code.

image

2. Add the following variable to the Entity1Service class;

static Dictionary<string, string> EntityCollection = new Dictionary<string, string>();

This variable will be used to hold the lists state information. A real world application would use a durable system such as a relational database instead.

3. Replace the existing method implementations with the following code:

public Entity1Service()

{

if (EntityCollection.Count == 0)

{

// Create some test list items.

Entity1 e1 = new Entity1();

e1.Identifier1 = "e1";

e1.Message = "e1 Item Data";

EntityCollection.Add(e1.Identifier1, e1.Message);

Entity1 e2 = new Entity1();

e2.Identifier1 = "e2";

e2.Message = "e2 Item Data";

EntityCollection.Add(e2.Identifier1, e2.Message);

}

}

public static Entity1 GetEntityById(string id)

{

// Looks up the Entity information based on the id passed

Entity1 entity1 = new Entity1();

entity1.Identifier1 = id;

entity1.Message = EntityCollection[id];

return entity1;

}

public static IEnumerable FindAllEntities()

{

// Iterates through our backing

List entities = new List();

foreach (String key in EntityCollection.Keys)

{

Entity1 entity1 = new Entity1();

entity1.Identifier1 = key;

entity1.Message = EntityCollection[key];

entities.Add(entity1);

}

return entities;

}

public static void Update(Entity1 inParameter1)

{

// Updates the corresponding item in the collection

EntityCollection[inParameter1.Identifier1] = inParameter1.Message;

}

Task 4: Deploy and create an entity backed list based on this example.

1. Right click on the BusinessDataCatalog1 project and select deploy.

2. In the web browser click Site Actions -> View All Site Content -> Create.

3. Beneath Custom Lists click External List.

image

4. Specify CustomList as the name of the new list. Beneath Entity Type click the browse icon. Select the newly created Business Data Type in the list and click OK.

image

The list will render the sample list items we added in the entity’s constructor.

image

Selecting an item and pressing edit allows changing of the field which in turn calls the Update method we defined in the custom entity.

image


Sharepoint 2010 interview Questions and answers

1. What is SharePoint?
• SharePoint is Microsoft’s enterprise information portal. It can be configured to run Intranet, Extranet and Internet sites.
• Microsoft Office SharePoint Server 2007 allows people to connect and collaborate.
• A SharePoint enterprise portal is composed of SharePoint Portal and Windows SharePoint Services.
• SharePoint Server is designed medium to large company wide enterprise portal.
2. What is Microsoft SharePoint Portal Server?
Microsoft Office SharePoint Server 2007 is a collaborative enterprise portal that is built upon WSS 3.0. MOSS 2007 allows people, teams and expertise to connect and collaborate. Unlike WSS, SharePoint Server is not free and requires an additional license. MOSS 2007 comes in two versions – Standard and Enterprise. The main components of SharePoint 2007 are collaboration, portals, enterprise search, enterprise content management, business process and forms, and business intelligence.
3. How is SharePoint Portal Server different from the Site Server?
It becomes difficult to keep a track of the large amount of documents with the growth of companies. SharePoint lets these be stored centrally. So instead of having them shared via emails, SharePoint allows an easy access to the members by storing the files at one place. SharePoint allows anyone to create sites for use within their company’s Intranet
4. How is security managed in SharePoint?
Authentication
SharePoint can run under various IIS modes to authenticate its users. The modes include: Anonymous, Basic, Integrated Windows or Certificates Authentication (over SSL).
Authorization
SharePoint security facilitates the regulation of access privileges of users and groups as well.
Impersonation
.NET Impersonation which is utilized by SharePoint allows an application to run under the context of the client accessing an application.
Deployment and Code Access Security
.NET Code Access Security (CAS) provides a security model. It can restrict the operations that can be performed as well as the resources that can be accessed by managed code.
5. What is Windows SharePoint Services?
Windows SharePoint Services 3.0 is the platform on which all SharePoint Products and Technologies are built. It is suitable for small teams, projects and organizations.
WSS’s project collaboration, document workspace, meeting sub-site, and discussion board features allow individuals and small teams to collaborate and share information online.
New features in WSS 3.0 include
- integrated workflows,
- RSS feeds,
- blogs,
- wikis and
- ASP-style Web parts.
6. What is a SharePoint site definition?
SharePoint sites consist of numerous Web pages, just like an ASP.NET 2.0 application.
When a site is created, these pages are created as instances in the content database.
The instances refer to the actual file on the file system.
7. What is CAML?
CAML stands for Collaborative Application Mark-up Language.
CAML is used to define tables in the Windows SharePoint Services database during site provisioning.
It is an XML-based language that is used in Microsoft Windows SharePoint Services to define sites and lists.

8. What is Service-Oriented Architecture?

SOA is an IT architecture strategy for business solution (and infrastructure solution) delivery based on the concept of service-orientation.
It is a set of components which can be invoked, and whose interface descriptions can be published and discovered.
It aims at building systems that are extendible, flexible and fit with legacy systems.
It promotes the re-use of basic components called services.

9. Why SOA?
Service is the important concept. Services can be published, discovered and used in a technology neutral, standard form by the set of protocols of the web services.
Other than being just architecture, SOA is the policies, practices, and frameworks by which it is ensure the right services are provided and consumed.
It becomes critical to implement processes that ensure that there are at least two different and separate processes— one for provider and the other for consumer, using SOA.
The Business Service Bus is starting point for developers that guide them to a coherent set that has been assembled for their domain.
This is better than leaving developers to discover individual services and put them into context.

Challenges faced in SOA adoption
One of the challenges faced by SOA is managing services metadata.
Second biggest challenge is the lack of testing in SOA space.
Another challenge is providing appropriate levels of security.
Interoperability is another important aspect in the SOA implementations.
Vendor hype concerns SOA because it can create expectations that may not be fulfilled.

10. What is SOA governance? What are its functions?
Service-Oriented Architecture (SOA) governance is a concept used for activities related to exercising control over services in an SOA
Some key activities that are often mentioned as being part of SOA governance are:
• Managing the portfolio of services: This includes planning development of new services and updating current services.
• Managing the service lifecycle: This is meant to ensure that updates of services do not disturb current services to the consumers.
• Using policies to restrict behavior: Consistency of services can be ensured by having the rules applied to all the created services.
• Monitoring performance of services: The consequences of service downtime or underperformance can be severe because of service composition. Therefore action can be taken instantly when a problem occurs by monitoring service performance and availability.

Business Benefits of Service-Oriented Architecture
SOA can help businesses respond more quickly and economically to changing market conditions.
SOA can be considered an architectural evolution. It captures many of the best practices of previous software architectures.
The goal of separating users from the service implementations is promoted by SOA.
The goals like increased interoperability, increased federation and increased business & technology domain alignment can be achieved by SOA due to its architectural and design discipline.
SOA is an architectural approach for constructing complex software-intensive systems from services.
SOA realizes its business and IT benefits through utilizing an analysis and design methodology when creating services.

IT Benefits of Service-Oriented Architecture
IT benefits of SOA are:
• The ability to build composite applications is provided.
• Business services are offered across the platforms.
• A self-healing infrastructure that reduces management costs is created.
• Location independence is provided
• Provides truly real-time decision-making applications.
• Reliability is enhanced
• It is not necessary that Services be at a particular system or network
• The approach is completely loosely coupled
• Hardware acquisition costs are reduced
• At every level there’s Authentication and authorization support
• Existing development skills are leveraged
• Provides a data bridge between incompatible technologies
• The search and connectivity to other services is dynamic

11. What are the characteristics of Object Oriented programming language?
Answer
Some key features of the Object Oriented programming are:
• Emphasis on data rather than procedure
• Programs are divided into entities known as objects
• Data Structures are designed such that they characterize objects
• Functions that operate on data of an object are tied together in data structures
• Data is hidden and cannot be accessed by external functions
• Objects communicate with each other through functions
• New data and functions can be easily added whenever necessary
• Follows bottom up design in program design
12. What are the basic Concepts used in the Object-Oriented Programming language?
Answer
Object
Class
Data Abstraction and Encapsulation
Polymorphism
Inheritance
Message passing
Dynamic binding
13. What are content types?
Introduction to Content Types
A content type is a reusable collection of metadata (columns), workflow, behavior, and other settings for a category of items or documents in a Microsoft SharePoint Foundation 2010 list or document library. Content types enable you to manage the settings for a category of information in a centralized, reusable way.
For example, imagine a business situation in which you have three different types of documents: expense reports, purchase orders, and invoices. All three types of documents have some characteristics in common; for one thing, they are all financial documents and contain data with values in currency. Yet each type of document has its own data requirements, its own document template, and its own workflow. One solution to this business problem is to create four content types. The first content type, Financial Document, could encapsulate data requirements common to all financial documents in the organization. The remaining three, Expense Report, Purchase Order, and Invoice, could inherit common elements from Financial Document and also define characteristics unique to each type, such as a particular set of metadata, a document template to be used in creating a new item, and a specific workflow for processing an item.
Each of the content types in this example could be used on any document library in the site hierarchy, and all of them could be used together on the same document library. When business requirements change, the content types can be modified to meet the new requirements and updates can be pushed down to any document library where the content type is used.
Content Types Encapsulate Data Requirements Content types are a means of encapsulating the data requirements for a category of information. A content type can include the following information:
• The metadata, or properties, you want to assign to this type. These are represented by site columns added to the list or document library when you add the content type. For more information, see Columns.
• Custom New, Edit, and Display forms to use with this content type. For more information, see Custom Information in Content Types.
• Workflows available for items of this content type. These can be defined to start automatically based on a selected event or condition, or through user selection. For more information, see the Workflow Associations property.
• For document content types, the document template on which to base documents of this type. For more information, see Document Template Element (Content Type).
• Any information necessary for custom solutions associated with this content type. You can store this information in the content type as one or more XML documents. For more information, see Custom Information in Content Types.
Content Types Enable Content Standardization

Because content types can be defined independently of any specific list or document library, you can make a given content type available for the lists on multiple SharePoint Foundation sites. This enables you to centrally define and manage the types of content you store in your site collection. For example, you could define a Legal Document content type to ensure that all legal documents track the same metadata, even if those documents are created and stored in multiple sites.
Content Types are File Format Independent

Content types are independent of file formats. For example, suppose you create a content type to represent a business plan. This content type could be applied to any file format. You might have the following:
• Microsoft Office Word documents containing background information
• Microsoft Office Excel documents containing a financial plan
• Microsoft Office PowerPoint presentations for the venture capital pitch
• Windows Media files of demos
• SharePoint Foundation list items containing the specified metadata
All of these files could be assigned the Business Plan content type. You can also assign content types to items that do not have a file at all, such as list items or folders.
Content Type Creation

You can create column and content types in three ways:
• Using the SharePoint Foundation user interface
• Using the SharePoint Foundation object model
• Deploying a Feature that installs the content type based on an XML definition file. For more information, see Using Features.
More Questions….
1. What is Microsoft SharePoint Portal Server?
SharePoint Portal Server is a portal server that connects people, teams, and knowledge across business processes. SharePoint Portal Server integrates information from various systems into one secure solution through single sign-on and enterprise application integration capabilities. It provides flexible deployment and management tools, and facilitates end-to-end collaboration through data aggregation, organization, and searching. SharePoint Portal Server also enables users to quickly find relevant information through customization and personalization of portal content and layout as well as through audience targeting.

2. What is Microsoft Windows Services?
Microsoft Windows Services is the engine that allows administrators to create Web sites for information sharing and document collaboration. Windows SharePoint Services provides additional functionality to the Microsoft Office System and other desktop applications, as well as serving as a plat form for application development. SharePoint sites provide communities for team collaboration, enabling users to work together on documents, tasks, and projects. The environment for easy and flexible deployment administration, and application development.

3. What is the relationship between Microsoft SharePoint Portal Server and Microsoft Windows Services?
Microsoft SharePoint Products and Technologies (including SharePoint Portal Server and Windows SharePoint Services) deliver highly scalable collaboration solutions with flexible deployment and management tools. Windows SharePoint Services provides sites for team collaboration, while Share Point Portal Server connects these sites, people, and business processes—facilitating knowledge sharing and smart organizations. SharePoint Portal Server also extends the capabilities of Windows SharePoint Services by providing organizational and management tools for SharePoint sites, and by enabling teams to publish information to the entire organization.

4. Who is Office SharePoint Server 2007 designed for?

Office SharePoint Server 2007 can be used by information workers, IT administrators, and application developers. is designed

5. What are the main benefits of Office SharePoint Server 2007?
Office SharePoint Server 2007 provides a single integrated platform to manage intranet, extranet, and Internet applications across the enterprise.
• Business users gain greater control over the storage, security, distribution, and management of their electronic content, with tools that are easy to use and tightly integrated into familiar, everyday applications.
• Organizations can accelerate shared business processes with customers and partners across organizational boundaries using InfoPath Forms Services–driven solutions.
• Information workers can find information and people efficiently and easily through the facilitated information-sharing functionality and simplified content publishing. In addition, access to back-end data is achieved easily through a browser, and views into this data can be personalized.
• Administrators have powerful tools at their fingertips that ease deployment, management, and system administration, so they can spend more time on strategic tasks.
• Developers have a rich platform to build a new class of applications, called Office Business Applications, that combine powerful developer functionality with the flexibility and ease of deployment of Office SharePoint Server 2007. Through the use of out-of-the-box application services, developers can build richer applications with less code.

6. What is the difference between Microsoft Office SharePoint Server 2007 for Internet sites and Microsoft Office SharePoint Server 2007?
Microsoft Office SharePoint Server 2007 for Internet sites and Microsoft Office SharePoint Server 2007 have identical feature functionality. While the feature functionality is similar, the usage rights are different.
If you are creating an Internet, or Extranet, facing website, it is recommended that you use Microsoft Office SharePoint Server 2007 for Internet sites which does not require the purchase client access licenses. Websites hosted using an “Internet sites” edition can only be used for Internet facing websites and all content, information, and applications must be accessible to non-employees. Websites hosted using an “Internet sites” edition cannot be accessed by employees creating, sharing, or collaborating on content which is solely for internal use only, such as an Intranet Portal scenario. See the previous section on licensing for more information on the usage scenarios.

7. What suites of the 2007 Microsoft Office system work with Office SharePoint Server 2007?
Office Outlook 2007 provides bidirectional offline synchronization with SharePoint document libraries, discussion groups, contacts, calendars, and tasks.
Microsoft Office Groove 2007, included as part of Microsoft Office Enterprise 2007, will enable bidirectional offline synchronization with SharePoint document libraries.
Features such as the document panel and the ability to publish to Excel Services will only be enabled when using Microsoft Office Professional Plus 2007or Office Enterprise 2007.
Excel Services will only work with documents saved in the new Office Excel 2007 file format (XLSX).

8. How do I invite users to join a Windows SharePoint Services Site? Is the site secure?

SharePoint-based Web sites can be password-protected to restrict access to registered users, who are invited to join via e-mail. In addition, the site administrator can restrict certain members' roles by assigning different permission levels to view post and edit.

9. Can I post any kind of document?
You can post documents in many formats, including .pdf, .htm and .doc. In addition, if you are using Microsoft Office XP, you can save documents directly to your Windows SharePoint Services site.

10. Can I download information directly from a SharePoint site to a personal digital assistant (PDA)?
No you cannot. However, you can exchange contact information lists with Microsoft Outlook.

11. How long does it take to set up the initial team Web site?
It only takes a few minutes to create a complete Web site. Preformatted forms let you and your team members contribute to the site by filling out lists. Standard forms include announcements, events, contacts, tasks, surveys, discussions and links.

12.Can I create custom templates?

Yes you can. You can have templates for business plans, doctor's office, lawyer's office etc.

13. How can I make my site public? By default, all sites are created private.
If you want your site to be a public Web site, enable anonymous access for the entire site. Then you can give out your URL to anybody in your business card, e-mail or any other marketing material. The URL for your Web site will be: http:// yoursitename.wss.bcentral.com
Hence, please take special care to name your site. These Web sites are ideal for information and knowledge intensive sites and/or sites where you need to have shared Web workspace. Remember: Under each parent Web site, you can create up to 10 sub-sites each with unique permissions, settings and security rights.

14. How do the sub sites work?
You can create a sub site for various categories. For example:
• Departments - finance, marketing, IT
• Products - electrical, mechanical, hydraulics
• Projects - Trey Research, Department of Transportation, FDA
• Team - Retention team, BPR team
• Clients - new clients, old clients
• Suppliers - Supplier 1, Supplier 2, Supplier 3
• Customers - Customer A, Customer B, Customer C
• Real estate - property A, property B
The URLs for each will be, for example:
• http://yoursitename.wss.bcentral.com/finance
• http://yoursitename.wss.bcentral.com/marketing
You can keep track of permissions for each team separately so that access is restricted while maintaining global access to the parent site.

15. How do I make my site non-restricted?
If you want your site to have anonymous access enabled (i.e., you want to treat it like any site on the Internet that does not ask you to provide a user name and password to see the content of the site), follow these simple steps:
1. Login as an administrator
2. Click on site settings
3. Click on Go to Site Administration
4. Click on Manage anonymous access
5. Choose one of the three conditions on what Anonymous users can access:
o Entire Web site
o Lists and libraries
o Nothing
Default condition is nothing; your site has restricted access. The default conditions allow you to create a secure site for your Web site.

16. Can I get domain name for my Web site?
Unfortunately, no. At this point, we don't offer domain names for SharePoint sites. But very soon we will be making this available for all our SharePoint site customers. Please keep checking this page for further update on this. Meanwhile, we suggest you go ahead and set up your site and create content for it.

17. What are picture libraries?
Picture libraries allow you to access a photo album and view it as a slide show or thumbnails or a film strip. You can have separate folder for each event, category, etc

18. What are the advantages of a hosted SharePoint vs. one that is on an in-house server?
• No hardware investment, i.e. lower costs
• No software to download - ready to start from the word go
• No IT resources - Anyone who has used a Web program like Hotmail can use it
• Faster deployment

19. Can I ask users outside of my organization to participate in my Windows SharePoint Services site?

Yes. You can manage this process using the Administration Site Settings. Simply add users via their e-mail alias and assign permissions such as Reader or Contributor.

20. Are there any IT requirements or downloads required to set up my SharePoint site?
No. You do not need to download any code or plan for any IT support. Simply complete the on-line signup process and provide us your current and correct email address. Once you have successfully signed up and your site has been provisioned, we will send a confirmation to the email address you provided.

21. I am located outside of the United States. Are there any restrictions or requirements for accessing the Windows SharePoint Services?

No. There are no system or bandwidth limitations for international trial users. Additionally language packs have been installed which allow users to set up sub-webs in languages other than English. These include: Arabic, Danish, Dutch, Finnish, French, German, Hebrew, Italian, Japanese, Polish, Portuguese (Brazilian), Spanish and Swedish.

22. Are there any browser recommendations?
Yes. Microsoft recommends using the following browsers for viewing and editing Windows SharePoint Services sites: Microsoft Internet Explorer 5.01 with Service Pack 2, Microsoft Internet Explorer 5.5 with Service Pack 2, Internet Explorer 6, Netscape Navigator 6.2 or later.

23. What security levels are assigned to users?

Security levels are assigned by the administrator who is adding the user. There are four levels by default and additional levels can be composed as necessary.
• Reader - Has read-only access to the Web site.
• Contributor - Can add content to existing document libraries and lists.
• Web Designer - Can create lists and document libraries and customize pages in the Web site.
• Administrator - Has full control of the Web site.


24. How secure are Windows SharePoint Services sites hosted by Microsoft?

Microsoft Windows SharePoint Services Technical security measures provide firewall protection, intrusion detection, and web-publishing rules. The Microsoft operation center team tests and deploys software updates in order to maintain the highest level of security and software reliability. Software hot-fixes and service packs are tested and deployed based on their priority and level of risk. Security related hot-fixes are rapidly deployed into the environment to address current threats. A comprehensive software validation activity ensures software stability through regression testing prior to deployment.

25. What is the difference between an Internet and an intranet site?
An internet site is a normal site that anyone on the internet can access (e.g., www.msn.com, www.microsoft.com, etc.). You can set up a site for your company that can be accessed by anyone without any user name and password. The internet is used for public presence and a primary marketing tool managed typically by web programmers and a system administrator.
An intranet (or internal network), though hosted on a Web site, can only be accessed by people who are members of a specific network. They need to have a login and password that was assigned to them when they were added to the site by the site administrator. The intranet is commonly used as an internal tool for giving employees access to company information. Content is driven by business relevance, business rules and has increasingly become a common tool in larger organizations. An intranet is becoming more and more the preferred method for employees to interact with each other and the central departments in an organization, whether or not the organization has a Web presence.

26. What is a workspace?
A site or workspace is when you want a new place for collaborating on Web pages, lists and document libraries. For example, you might create a site to manage a new team or project, collaborate on a document or prepare for a meeting.

27. What are the various kinds of roles the users can have?
A user can be assigned one of the following roles
• Reader - Has read-only access to the Web site.
• Contributor - Can add content to existing document libraries and lists.
• Web Designer - Can create lists and document libraries and customize pages in the Web site.
• Administrator - Has full control of the Web site.

28. Can more than one person use the same login?
If the users sharing that login will have the same permissions and there is no fear of them sharing a password, then yes. Otherwise, this is discouraged.

29. How customizable is the user-to-user access?
User permissions apply to an entire Web, not to documents themselves. However, you can have additional sub webs that can optionally have their own permissions. Each user can be given any of four default roles. Additional roles can be defined by the administrator.

30. Can each user have access to their own calendar?
Yes there are two ways to do this,
• by creating a calendar for each user, or
• by creating a calendar with a view for each user

31. How many files can I upload?
There is no restriction in place except that any storage consumed beyond that provided by the base offering may have an additional monthly charge associated with them.

32. What types of files can I upload / post to the site?
The only files restricted are those ending with the following extensions: .asa, .asp, .ida, .idc, .idq. Microsoft reserves the right to add additional file types to this listing at any time. Also, no content that violates the terms of service may be uploaded or posted to the site.

33. Can SharePoint be linked to an external data source?

SharePoint data can be opened with Access and Excel as an external data source. Thus, SharePoint can be referenced as an external data source. SharePoint itself cannot reference an external data source.
But 3rd pary software can do this for you: http://www.layer2.de/en/products/pages/sharepoint-business-data-list-connector.aspx


34. Can SharePoint be linked to a SQL database?
SharePoint 2007 Portal Server (MOSS2K7) allows connections to SQL based datasources via the Business Data Catalog (BDC). The BDC also allows connecting to data via Web Services. Or you can link lists directly qith sql queries in the list settings using the BDLC found here: http://bit.ly/p30tJ .

35. Can I customize my Windows SharePoint Services site?
YES! Windows SharePoint Services makes updating sites and their content from the browser easier then ever.
SharePoint includes tools that let you create custom lists, calendars, page views, etc. You can apply a theme; add List, Survey and Document Library Web Parts to a page; create personal views; change logos; connect Web Parts and more.
To fully customize your site, you can use Microsoft FrontPage 2003. Specifically, you can use FrontPage themes and shared borders, and also use FrontPage to create photo galleries and top ten lists, utilize standard usage reports, and integrate automatic Web content.

36. Will Microsoft Office SharePoint Server 2007 run on a 64-bit version of Microsoft Windows?

Windows SharePoint Services 3.0, Office SharePoint Server 2007, Office Forms Server 2007, and Office SharePoint Server 2007 for Search will support 64-bit versions of Windows Server 2003.

37. How Office SharePoint Server 2007 can help you?
Office SharePoint Server 2007 can help us:
Manage content and streamline processes. Comprehensively manage and control unstructured content like Microsoft Office documents, Web pages, Portable Document Format file (PDF) files, and e-mail messages. Streamline business processes that are a drain on organizational productivity.
Improve business insight. Monitor your business, enable better-informed decisions, and respond proactively to business events.
Find and share information more simply. Find information and expertise wherever they are located. Share knowledge and simplify working with others within and across organizational boundaries.
Empower IT to make a strategic impact. Increase responsiveness of IT to business needs and reduce the number of platforms that have to be maintained by supporting all the intranet, extranet, and Web applications across the enterprise with one integrated platform.
Office SharePoint Server 2007 capabilities can help improve organizational effectiveness by connecting people, processes, and information.
Office SharePoint Server 2007 provides these capabilities in an integrated server offering, so your organization doesn't have to integrate fragmented technology solutions itself.

38. What are the features that the portal components of Office SharePoint Server 2007 include?
The portal components of Office SharePoint Server 2007 include features that are especially useful for designing, deploying, and managing enterprise intranet portals, corporate Internet Web sites, and divisional portal sites. The portal components make it easier to connect to people within the organization who have the right skills, knowledge, and project experience.

39. What are the advanced features of MOSS 2007?
• User Interface (UI) and navigation enhancements
• Document management enhancements
• The new Workflow engine
• Office 2007 Integration
• New Web Parts
• New Site-type templates
• Enhancements to List technology
• Web Content Management
• Business Data Catalog
• Search enhancements
• Report Center
• Records Management
• Business Intelligence and Excel Server
• Forms Server and InfoPath
• The “Features” feature
• Alternate authentication providers and Forms-based authentication


40. What are the features of the new Content management in Office SharePoint 2007?
The new and enhanced content management features in Office SharePoint Server 2007 fall within three areas:
• Document management
• Records management
• Web content management
Office SharePoint Server 2007 builds on the core document management functionality provided by Windows SharePoint Services 3.0, including check in and check out, versioning, metadata, and role-based granular access controls. Organizations can use this functionality to deliver enhanced authoring, business document processing, Web content management and publishing, records management, policy management, and support for multilingual publishing.