praveensblog

noreply@blogger.com (Praveen from Hyderabd) — Wed, 22 Aug 2007 11:55:00 +0000

Ajax Implementation in Asp.net 2.0

noreply@blogger.com (Praveen from Hyderabd) — Tue, 21 Aug 2007 06:35:00 +0000

In this article i am giving you a very usefull example, that is when you choose the country in a dropdown list which is filled dynamically and want the state comes in another dropdown will depend on the first dropdown list. To remove this post back i use ajax here.

Asynchronous JavaScript and xml (AJAX) is now the need of the new generation websites. In the asp.net using AJAX is very easy. We just place few line codes in the web.config file and start using Ajax tags. But you should download Ajaxtoolkit first from the following Microsoft link.

Requirements:
(1) Microsoft .NET Framework Version 2.0,
(2) IE 5.01 or later
(3) Windows 2000; Windows Server 2003; Windows Vista; Windows XP

After download this exe you will get the additional option in your .net toolbox is Ajax Extensions.

Now two ways to use ajax
(1) Create a new ajax enabled web site. File->new ->ajax enabled web site
OR
(2) Changes made in your existing asp.net2.0 website.

then

You must add the following lines in your web.config files.
Add these lines in

-------------------------------------
Praveens Note:

If you think why I add these lines in you web.config file then the answer is these lines you can find in you system
C or other system directory \Program Files\Microsoft ASP.NET\ASP.NET 2.0 AJAX Extensions\v1.0.61025\web.configIf you don’t do that, then you will get the ‘sys is undefine’ javascript error. And your ajax will not work fine.
So, cheer up, now your application is ready to implement the ajax in .net 2.0. First place a “script manager��? and then a “update panel��?. Now Any control in the update panel if request to server, then only the part within the update panel will submitted to the server. This is very useful when your page is frequently postback.

Here I am giving you a very simple and useful example, which you deals many times while making the dynamic website. The example is when data is dynamically filled in the dropdownlist then when you choose the country and want to display the information about only that state which belongs to that particular country, means in another dropdown you want to fill the state related to that particular country, which is selected by the user, the page postback. To remove this postback you can use ajax as in the given example I did.For the ease of your understanding I doesn’t uses anything on that particular page except the necessary thing and the things which are more convenient for your understandings. I use XML database (for you convenience) for this example, you can use any of other database.
My naming convention is as follows:Drop down list for country: ddlCountryDrop down list for state :ddlStateAnd a label :lblMsg
Now ddlCountry is dynamically filled by the xml database on pageload event. For this purpose I call a function fillCountry(). It is called only once to fill the dropdownlist ddlcountry.
Page Load Event:

”’

”’ On page load the drop down for choose country is filled, by a function fillCountry()”’

”’ ”’ ”’ Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.LoadIf Not IsPostBack ThenfillCountry()End If
End Sub

Sub routine fillCountry:fillCountry() sub routine is used to fill the ddlCountry. It just read the xml file in the dataset. It uses listitem to fill the dropdownlist. Listitem text and listitem value is provided dynamically from the dataset.And at the end listitem is added to the dropdown.
view plain copy to clipboard print ?
·········10········20········30········40········50········60········70········80········90········100·······110·······120·······130·······140·······150
”’

”’ This subroutine is used to fill the drop down list for country , dynamically
”’

”’
Private Sub fillCountry()
Dim ds As New DataSet()
Dim lst As ListItem ‘list items that will be added to drop down list after assigning the text and value
Dim i As Integer = 0
If Not IsPostBack() Then
ddlCountry.Items.Clear()
End If
ds.ReadXml(Server.MapPath(”App_Data\country.xml”))
lst = New ListItem()
lst.Text = “–Choose Country–”
lst.Value = “0″
ddlCountry.Items.Add(lst)
For i = 0 To ds.Tables(0).Rows.Count - 1
lst = New ListItem()
lst.Text = ds.Tables(0).Rows(i)(0)
lst.Value = ds.Tables(0).Rows(i)(1)
ddlCountry.Items.Add(lst)
Next
End Sub

The country drop down is dynamically filled by the above code.
view plain copy to clipboard print ?
·········10········20········30········40········50········60········70········80········90········100·······110·······120·······130·······140·······150

On Select Index Change event of Country dropdownlist
Protected Sub ddlCountry_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs)
ddlState.Enabled = True
fillState(ddlCountry.SelectedItem.Value.ToString().Trim())
lblMsg.Text = “You are selected ” + ddlCountry.SelectedItem.Text
End Sub
On Select Index Change event of Country dropdownlist
Protected Sub ddlCountry_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs)
ddlState.Enabled = True
fillState(ddlCountry.SelectedItem.Value.ToString().Trim())
lblMsg.Text = “You are selected ” + ddlCountry.SelectedItem.Text
End Sub

On the change of the dropdown selection, it enable the state dropdown list (ddlState) and dynamically fill the ddlstate dropdown by the function fillState(country’s Selected item value).
Sub routine fillState(CountryID):If you have a close look on the below code you will find the line ddlState.Items.Clear()Actually it is just clear the ddlState every time before dynamically filling the data into them, if this line is not written the each time when this function called it will not remove the previous data, just add new item into them.Now again a new thing :lst = New ListItem()lst.Text = “–Choose State–”lst.Value = “0″
What these three line do. These simply add the first list item as choose state so user can easily understand that this dropdown is to choose the state. And its value is 0 you can put it -1 or some thing string as you want.One last thingIf ds.Tables(0).Rows(i)(2) = countryid ThenAbove line is fillter the data for state which belongs to the particular countryid (See State.xml). If you are using another database you just do it by using where condition in the sql select statement.

”’

”’ It fills the drop down for the state dynamically
”’

”’
”’
Private Sub fillState(ByVal countryid As String)
Dim ds As New DataSet()
Dim lst As ListItem
Dim i As Integer = 0
ddlState.Items.Clear()
lst = New ListItem()
lst.Text = “–Choose State–”
lst.Value = “0″
ddlState.Items.Add(lst)
ds.ReadXml(Server.MapPath(”App_Data\state.xml”))
For i = 0 To ds.Tables(0).Rows.Count - 1
If ds.Tables(0).Rows(i)(2) = countryid Then
lst = New ListItem()
lst.Text = ds.Tables(0).Rows(i)(0)
lst.Value = ds.Tables(0).Rows(i)(1)
ddlState.Items.Add(lst)
End If
Next

Summary
Now we can come to this conclusion, you can enhance the lots of user interaction using Ajax. You can use it on every where, where you think it required. Another member for the toolbox in Ajax extension is for the different purpose like update progress is for the displaying the progress in the Ajax panel when it takes too much time to update. Another example of Ajax is you can use it in data grid also, it just remove the post back when you enable paging and shorting. In calendar control it also removes the post back etc. I will come with my other articles with more features of Ajax.

Skills being measured for Exam 70-542

noreply@blogger.com (Praveen from Hyderabd) — Mon, 20 Aug 2007 07:13:00 +0000

Exam 70-542: Microsoft Office SharePoint Server 2007 – Application Development

This certification exam measures your ability to build web portals and integrate business applications using Microsoft Office SharePoint Server 2007.
Before taking the exam, you should be proficient in the job skills listed in the following matrix. The matrix shows which Microsoft Official Curriculum courses may help you reach competency in the skills being tested in the exam.
Skills measured by exam 70-542
Managing Enterprise Content
Enforce document storage business rules by using Document Policy.
• Create a custom document policy.
• Deploy a document policy by using a policy feature.
• Specify logic for a document policy by using a policy resource.
• Manage document retention rules by using the expiration feature policy.
• Launch a workflow when a document expires.

Audit Windows SharePoint Services content by using a custom policy.
Manage records by using Office SharePoint Server 2007 record management features.
• Create a custom file plan.
• Create a custom audit report.
• Create a custom file submission.
• Create a custom legal hold.

Create content by using the Office SharePoint Server 2007 Web content management features.
• Extend the Page Authoring toolbar.
• Create pages dynamically.
• Modify page layout by using content placeholders.
• Create a custom field control.
• Localize a site by using resource lists.

Deploy content between servers.
Provide variations of Web content.
• Redirect a user to a variation based on profile settings.
• Launch a workflow when an event occurs in a primary variation.

Provision multiple sites in a hierarchy.
Creating Business Intelligence Solutions by Using Office SharePoint Server 2007
Display data from a Microsoft Excel workbook by using Excel Services.
Create a trusted workbook location by using the Stsadm.exe command-line tool.
Implement business logic by using an Excel Services user-defined function.
• Process enterprise data from a Windows SharePoint Services list.
• Troubleshoot a user-defined function.

Filter data in a workbook by using Excel Services.
Provide parameters to a Report Viewer Web Part from a custom Web Part.
Expose a data source by adding a data connection to a Report Center Web Site.
Create a key performance indicator (KPI) Web Part by using data from a report data source.
Integrating Business Data with Office SharePoint Server 2007 by Using the Business Data Catalog (BDC)
Create a BDC Application Definition.
• Create a line of business (LOB) system.

Describe an external application in the BDC Application Definition.
• Create an LOB system instance.
• Create an entity.

Display data from an external data source.
• Create a Finder method.

Enable indexing of data stored in an external data source.
• Create an IDEnumerator.

Enable searching on a BDC Application Definition.
• Enable a single item query by creating identifiers for entities.
• Enable a single item query by creating a SpecificFinder method.
• Add input and output parameters to a SpecificFinder method.
• Create a filter descriptor.

Create a custom action on an entity.
Create an association between two entities.
Create a Web Part to browse data.
• Return an LOB system instance.
• Return an entity.
• Execute a finder on an entity.
• Execute a method on an entity.
• Execute a SpecificFinder on an entity.
• Execute a wildcard filter on an entity.

Accessing Office SharePoint Server 2007 Application Platform Services
Process InfoPath data from within a workflow.
Display an InfoPath Form from within an ASP.NET page by using the Form Services control.
Automate Office Forms Server administration tasks.
• Activate a previously uploaded form template.

Manage credentials by using the single sign-on (SSO) credential store.
• Create a custom SSO provider for use by the BDC.
• Apply credentials to a Web service call by using SSO.

Convert documents by using the document converter.
• Convert a document from a document library by using an existing document converter.
• Increase the priority of a document in the conversion process.
• Transform a custom document format into another format.
• Publish a page by using the document converter.

Display a user profile retrieved from an Office SharePoint Server 2007 Web service.
Searching Data by Using the Search Service
Programmatically enhance the search service.
• Access the search context for the Shared Services Provider (SSP).
• Associate a search term by creating a Best Bet.

Add a custom search page for searching the BDC.
• Extend the user interface by adding a tab to the search page.

Provide custom search capabilities by creating an enterprise search Web Part.
Customize the display of search results by modifying the Search Core Results XSLT.
Display results from a Windows SharePoint Services search Web service.
Display the results of a keyword query.
Targeting Content Based on Audience Membership
Create an audience.
Specify conditions for audience membership by using rules.
Target a list item to an audience.
Target a Web Part to an audience by using filters.
Display all audiences to which a user belongs.
Display all users in a given audience.
Customizing Functionality by Using Profiles
Import users into the user profile store from an LDAP store.
Create a profile in the user profile store.
Manipulate profile properties.
• Add a profile property to the user profile store.
• Store a user's attributes in the user profile store by creating a multivalue property.
• Retrieve a specific property from a user profile.
• Map a BDC data item to a user profile property.
• Set the privacy policy for a user profile property.

Display all colleagues for a given user.
Add a distribution list to a new membership.
Display results from the user profile change log.

Certifications On Microsoft Office Sharepoint Products 2007

noreply@blogger.com (Praveen from Hyderabd) — Mon, 20 Aug 2007 07:11:00 +0000

Exam 70-542: Microsoft Office SharePoint Server 2007 – Application Development
Exam 70-541: TS: Windows SharePoint Services 3.0 – Application Development
Exam 70-631: TS: Windows SharePoint Services 3.0, Configuring
Exam 70-630: TS: Microsoft Office SharePoint Server 2007, Configuring