aMiT kUmAr

What is Delegate in .net(Delegate,Named method,Anonymous method)

2009-09-30T20:21:00.008+05:30

A delegate is a type that references a method. Once a delegate is assigned a method, it behaves exactly like that method. The delegate method can be used like any other method, with parameters and a return value.

In simple words,delegates are similar to pointer to a function in C++ but delegate are type safe. Delegates can be defined as methods that are used to call other method. The things which we need to consider is that the signature of the calling methods and delegates should match.

Example:

In C#:

Declaration of Delegate:

public delegate string AmitKumar(string Amit, string Kumar);

Declaration of function:

public string mcapassion(string AmitKumar, string AmitKumar_MCA04);

Any method that matches the delegate's signature, which consists of the return type and parameters, can be assigned to the delegate. This makes is possible to programmatically change method calls, and also plug new code into existing classes. As long as you know the delegate's signature, you can assign your own delegated method.

A delegate can be associated with a named method and anonymous methods. When you instantiate a delegate using a named method, the method is passed as a parameter, and in the case of anonymous methods code block passed as a delegate parameter.

Named method example in C#:

// Declare a delegate:
delegate void AmitKumar(string mcapassion);

// Define a named method:
void McaPassion(string amitkumar_mca04) { /* ... */ }

// Instantiate the delegate using the method as a parameter:
AmitKumar amit = obj.McaPassion;
-----------------------------------------------------------------

Anonymous method example in C#:

// Create a handler for a button click event
McaPassion.Click += delegate(System.Object o, System.EventArgs e)
{ System.Windows.Forms.MessageBox.Show("Amit Kumar!"); };

OR

// Create a delegate instance
delegate void AmitKumar(string mcapassion);

// Instantiate the delegate using an anonymous method
AmitKumar amit= delegate(string amitkumar_mca04) { /* ... */ };

What is WPF and XAML

2009-09-30T20:10:00.004+05:30

WPF:

Windows Presentation Foundation (WPF) is the code-name of the presentation (user-interfaces) sub system in Windows Vista programming model and is used to create user interfaces.

In broad way WPF is the engine that is responsible for creating, displaying, and manipulating user-interfaces, documents, images, movies, and media in Windows Vista.
Physically, WPF is a set of libraries that have all functionalty you need to build, run, execute, and manage Windows Vista applications.

XAML:

XAML is a new descriptive programming language developed by Microsoft to write user interfaces for next generation managed applications.

Relation between XAML and WPF:

XAML is a new descriptive programming language developed by Microsoft to write user interfaces for next generation managed applications. XAML is used in WPF to represent the controls and code with the help of C#, Visual Basic, and other .NET Framework languages.
XAML can be think as ASP.NET and/or Windows Forms in Windows Vista. For example, to write a Web application in .NET 1.0, 1.1, or 2.0, you use ASP.NET and to write Windows Applications, you use Windows Forms. Now in Windows Vista and .NET 3.0, you will use XAML instead of Windows Forms and ASP.NET.

Which Operating Systems support WPF:

Windows Vista, Windows XP, and Windows 2003 Server.

What is feature in SharePoint

2009-08-24T11:46:00.046+05:30

A SharePoint Feature is a functional component that can be activated and deactivate at various scopes throughout a SharePoint instances, such as at the farm, site collection, web, etc. Features have their own receiver architecture, which allow you to trap events such as when a feature is installing, uninstalling, activated, or deactivated. The element types that can be defined by a feature include menu commands, link commands, page templates, page instances, list definitions, list instances, event handlers, and workflows.
The two files that are used to define a feature are the feature.xml and manifest file(elements.xml).
The feature XML file defines the actual feature and will make SharePoint aware of the installed feature.
The manifest file contains details about the feature such as functionality.
The "Feature" is one of the major concepts in WSS3.0. The Feature is a container of various defined extensions for SharePoint.

A Feature can include any number of files, but it must include a Feature.xml file. The Feature.xml file, or Feature manifest, is the driver of the Feature, and this is the first file SharePoint looks at when invoking a Feature.
Features are organized in folders under the Features directory located under 12 hives; Where SharePoint Server 2007 puts all of its system files, at the following path: %SystemDrive%\Program Files\Common Files\Microsoft Shared\web server extensions\12.
In addition to the Feature.xml file, Features can include sub-folders and supporting files, such as element files that include for example, event handler references, ASPX pages deployed as part of the Feature, ASCX files, and DLL and RESX files.

For example, i required a custom feature, which add menu commands in the Custom List and after clicking on the custom link, control goes to custom page called DisplayListItems.aspx. In the DisplayListItems.aspx page, we will display the URL of site, list name and current loggedin user details. The screenshot of Menu Command given below:

Menu Command:

See the screenshot below of Feature.xml,DisplayList.xml(manifest file),DisplayListItems.aspx and DisplayListItems.aspx.cs.

Feature.xml:

SCOPE AND ALLOWED FEATURES

Web (Web site)

* Control
* Custom Action
* Custom Action Group
* Hide Custom Action
* List Instance
* List Template
* Module (File Set)
* Receiver

Site (site collection)

* Content Type
* Content Type Binding
* Control
* Custom Action
* Custom Action Group
* Feature/Site Template Association
* Field
* Hide Custom Action
* List Template
* Module (File Set)
* Workflow

WebApplication (Web application)

* Control
* Custom Action
* Custom Action Group
* Document Converter
* Feature/Site Template Association
* Hide Custom Action

Farm (farm)

* Control
* Custom Action
* Custom Action Group
* Feature/Site Template Association
* Hide Custom Action

In a Feature.xml file, the Feature element defines a Feature and specifies the location of assemblies, files, dependencies, or properties that support the Feature. In the above screenshot
ElementManifests Element (Feature):Contains references to element manifests (in our case name of Element manifest is DisplayList.xml) and element files that contain definitions for the Feature elements.

The attributes of above mentioned Feature.xml are:

Attribute	Description
Id	Required Text.Contains the globally unique identifier (GUID) for the Feature.
Title	Optional Text. Returns the title of the Feature. Limited to 255 characters.
Description	Optional String. Returns a longer representation of what the Feature does.
Version	Optional Text. Specifies a System.Version-compliant representation of the version of a Feature. This can be up to four numbers delimited by decimals that represent a version.
Scope	Required Text. Specifies the scope in which the Feature can be activated and contains one of the following values: Farm (farm), WebApplication (Web application), Site (site collection), Web (Web site).

DisplayList.xml(manifest file):

The above element manifest file specifies a support file required for the Feature.

The attributes of above mentioned DisplayList.xml are:

Attribute	Description
Custom Action	A custom action represents a link, toolbar button, menu item, or any control that can be added to a toolbar or menu that a user sees. Custom actions can be bound to list type, content type, file type, or programmatic identifier (ProgID).
Id	The unique identifier for the custom action.
Description	Description of the feature.
RegistrationType	Optional Text. Specifies the registration attachment for a per-item action. Possible values include: * ContentType * FileType * List * ProgId
RegistrationId	Optional Text. Specifies the identifier of the list or item content type that this action is associated with, or the file type or programmatic identifier (ProgID).
Location	Optional Text. Specifies the location of this custom action, for example, "Microsoft.SharePoint.SiteSettings". If the custom action is a menu item or toolbar button, then the possible options include EditControlBlock, NewFormToolbar, DisplayFormToolbar, and EditFormToolbar. If contained within a custom action group, the value of the Location attribute must equal the location of the CustomActionGroup element. See Default Custom Action Locations and IDs for a list of the default custom action locations that are used in Windows SharePoint Services.
GroupId	Optional Text. Identifies an action group that contains the action, for example, "SiteManagement". If contained within a custom action group, the value of the GroupId attribute must equal the group ID of the CustomActionGroup element. See Default Custom Action Locations and IDs for a list of the default custom action group IDs that are used in Windows SharePoint Services.
Sequence	Optional Integer. Specifies the ordering priority for actions.
Rights	Optional Text. Specifies a set of rights that the user must have in order for the link to be visible, for example, "ViewListItems,ManageAlerts". If not specified, then the action always appears in the list of actions. To specify multiple rights, separate the values by using commas. The set of rights are grouped logically according to AND logic, which means that a user must have all the specified rights to see an action. For a list of possible values, see Microsoft.SharePoint.SPBasePermissions.
ImageUrl	Optional Text. Specifies a virtual server relative link to an image that presents an icon for the item.
Title	Required Text. Specifies the end user description for this action.
UrlAction	is used to redirect users if they click on the link.

The following table shows the default list template integer IDs that you can use in defining the RegistrationId :

List Template Id	List Template
100	Generic list
101	Document library
102	Survey
103	Links list
104	Announcements list
105	Contacts list
106	Events list
107	Tasks list
108	Discussion board
109	Picture library
110	Data sources
111	Site template gallery
113	Web Part gallery
114	List template gallery
115	XML Form library
120	Custom grid for a list
200	Meeting Series list
201	Meeting Agenda list
202	Meeting Attendees list
204	Meeting Decisions list
207	Meeting Objectives list
210	Meeting text box
211	Meeting Things To Bring list
212	Meeting Workspace Pages list
300	Portal Sites list
1100	Issue tracking
2002	Personal document library
2003	Private document library

DisplayListItems.aspx file:

The .aspx contains only two server side ASP label for displaying user details and list name.

DisplayListItems.aspx.cs file:

In the .cs i have written the code for accessing site url/user details and list name on Page Load event.

Packaging the Feature:

In SharePoint Server 2007, Solutions are used to package and deploy Features, Site Definitions, Web Parts, Template Files, Assemblies and Code Access Security (CAS) policies to SharePoint front-end servers.

Steps for creating a Solution Package are described below:

* Create Manifest.XML file as part of the same project, which contains information Solution and path of feature files as part of the overall solution.

* Create the Diamond Discovery File/diamond directive file i.e. DDF file, which contains information to compress files into a CAB file.

* In the windows command prompt, run MakeCab.Exe on the DDF file to generate the WSP file. Note: MakeCab.Exe file can be downloaded from the Microsoft Site and should be copied into the same directory containing the Visual Studio Project Files.

* See screenshot below to make WSP file by using MakeCab.EXE command line utility.

Deploying the Features:

Steps for deploying a Solution Package are described below:

* Use the STSADM.EXE command line tool to add WSP file into the SharePoint Solution Store.

stsadm -o addsolution -filename D:\Amit_Code\SharePoint\Amit\ReadListFeature\ReadListFeature.wsp
stsadm -o deploysolution -name ReadListFeature.wsp -immediate
stsadm -o installfeature -name ReadList
stsadm -o activatefeature -name ReadList -url "http://amitkumarmca04.blogspot.com/sites/AMIT"

With the help of above steps Feature ReadList would be installed in your site.

Deactivating and Uninstalling the Solution:

You can also deactivate a particular feature on your site or web application, or you can uninstall a feature, which completely removes the feature from your SharePoint deployment. Features can be deactivated either through the administrative user interface or by using the STSADM.EXE command-line tool.

Deactivating the Feature by administrative user interface:

Browse the site where you want to deactivate the feature, Click Site Actions, and under Site Administration, click Site Features.
On the Site features page, locate the Feature you want to deactivate and click the Deactivate button to deactivate the Feature

Deactivating the feature by using the STSADM.EXE command-line utility:

Deactivating the feature by using the STSADM.EXE command-line utility:

stsadm -o deactivatefeature -name ReadList -force -url "http://amitkumarmca04.blogspot.com/sites/AMIT"

Uninstalling the Feature by using the STSADM.EXE command-line utility:

stsadm -o uninstallfeature -name ReadList -force

Delete solution using the STSADM.EXE command-line utility:

stsadm -o deletesolution -name ReadListFeature.wsp -override

With the help of this article, you will be able to write custom Features/ deploy custom feature with the help of SharePoint Solution Package (.wsp) and also able to de-activate or uninstall an existing feature.

What is the difference between SPListItem.SystemUpdate and SPListItem.Update Method (Microsoft.SharePoint)

2009-07-24T19:19:00.008+05:30

What is the difference between SPListItem.SystemUpdate and SPListItem.Update Method (Microsoft.SharePoint):

SPListItem.SystemUpdate:

Updates the database(Sharepoint list) with changes that are made to the list item, without effecting changes in the Modified Time or Modified By fields.

SPListItem.SystemUpdate Overloaded Method:

SPListItem.SystemUpdate():
Updates the database with changes made to the list item, without effecting changes in the Modified or Modified By fields.

SPListItem.SystemUpdate(Boolean):
Updates the database with changes that are made to the list item, without effecting changes in the Modified Time or Modified By fields, or optionally, the item version.

Example:

//Take the reference of that item

SPListItem listItem = listItemCOll[icount];

listItem["FIRST_NAME"] = “Amit”;

listItem["LAST_NAME"] = “Kumar”;

listItem["EMAIL_ADDR"] = “mcapassion@gmail.com”;

//Update the Item

listItem.SystemUpdate(false);

The argument false informs the SP object Model not increment versions.

SPListItem.Update:

SPListItem.Update():
Updates the database(Sharepoint list) with changes that are made to the list item/new version of item, and changes in the Modified Time or Modified By fields.

Example:

//Take the reference of that item

SPListItem listItem = listItemCOll[icount];

listItem["FIRST_NAME"] = “Amit”;

listItem["LAST_NAME"] = “Kumar”;

listItem["EMAIL_ADDR"] = “mcapassion@gmail.com”;

//Update the Item

listItem.Update();

Different between .ToString() and Convert.ToString() in C-Sharp(C#): Convert.ToString() vs .ToString()

2009-07-24T18:45:00.007+05:30

I will explain you what is the different between .ToString() and Convert.ToString() with the help of below mentioned code:

int intAmit =0;
Response.write(intAmit.ToString());
Response.write(Convert.ToString(intAmit));

We can convert the integer “intAmit” using “intAmit.ToString()” or “Convert.ToString(intAmit)” ,so what is the basic difference between them:

Convert: function handles NULLS
.ToString(): does not handles NULLS and it will throw a NULL reference exception error.

So as good coding practice is to use “convert” and it is always safe.

Example:

For example you received the data from database in the DataTable. One of the column in datatable is "Amit" and "Amit" column value in some rows of datatable are NULL.

So, when you will try to convert "Amit" column value to string if column value is NULL, with the help of dt.Row[0]["Amit"].ToString() it will throw a NULL reference exception error.

According to me when you need to convert an object to a string and it may be null, you can do it without throwing an exception using Convert.ToString().

Authentication in ASP.Net

2009-06-24T12:14:00.005+05:30

Authentication in ASP.Net

There are three types of Authentication Levels exist in the ASP.Net: Windows Authentication, Forms Authentication, Passport Authentication.

You can change/add authendication in web config file, in that you have to mention the authendication mode is Windows Authenticatin/Passport Authentication/Form Authentication as follows:

// web.config file

Windows authentication: enables you to identify users without creating a custom page. Credentials are stored in the Web server’s local user database or an Active Directory domain. Once identified you can use the user’s credentials to gain access to resources that are protected by Windows authorization. It’s a default authentication mode.

Forms authentication: enables you to identify users with a custom database such as an ASP.NET membership database. Alternatively you can implement your own custom database. Once authenticated you can reference the roles the user is in to restrict access to portions of your Web site.

Passport authentication: relies on a centralized service provided by Microsoft. Passport authentication identifies a user with using his or her e-mail address and a password and a single Passport account can be used with many different Web sites. Passport authentication is primarily used for public Web sites with thousands of users.

ASP .Net Page Life Cycle

2009-06-18T14:09:00.000+05:30

ASP .Net Page Life Cycle

1. OnInit (Init) Initializes each child control of the current

2. LoadControlState: Loads the ControlState of the control. To use this
method the control must call the Page.RegisterRequiresControlState method in
the OnInit method of the control.

3. LoadViewState: Loads the ViewState of the control.

4. LoadPostData: Is defined on interface IPostBackDataHandler. Controls that
implement this interface use this method to retrieve the incoming form data and
update the control s properties accordingly.

5. Load (OnLoad): Allows actions that are common to every request to be
placed here. Note that the control is stable at this time; it has been
initialized and its state has been reconstructed.

6. RaisePostDataChangedEvent: Is defined on the interface IPostBackData-Handler.
Controls that implement this interface use this event to raise change events in
response to the Postback data changing between the current Postback and the
previous Postback. For example if a TextBox has a TextChanged event and
AutoPostback is turned off clicking a button causes the Text-Changed event to
execute in this stage before handling the click event of the button which is
raised in the next stage.

7. RaisePostbackEvent: Handles the client-side event that caused the Postback
to occur

8. PreRender (OnPreRender): Allows last-minute changes to the control. This
event takes place after all regular Post-back events have taken place. This
event takes place before saving ViewState so any changes made here are saved.

9. SaveControlState: Saves the current control state to ViewState. After this
stage any changes to the control state are lost. To use this method the
control must call the Page.RegisterRequiresControlState method in the OnInit
method of the control.

10. SaveViewState: Saves the current data state of the control to ViewState.
After this stage any changes to the control data are lost.

11. Render: Generates the client-side HTML Dynamic Hypertext Markup Language
(DHTML) and script that are necessary to properly display this control at the
browser. In this stage any changes to the control are not persisted into
ViewState.

12. Dispose: Accepts cleanup code. Releases any unman-aged resources in this
stage. Unmanaged resources are resources that are not handled by the .NET common
language runtime such as file handles and database connections.

13. UnLoad

Caching Overview (ASP.Net)

2009-05-28T11:16:00.014+05:30

Caching Overview:

Abstract: Caching is a feature of ASP.NET that can dramatically improve the performance of your application by storing the page output or application data across HTTP requests.

This article cover:

What is Caching ?
Benefits of Caching
Introducing the Problems that Caching Solves
Types of Caching

What is caching?

Caching is a feature that stores data in memory, allowing incoming requests to be served from memory directly.
In the context of a web application, caching is used to retain pages or data across HTTP request and reuse them without the expense of recreating them.

Benefits of Caching

The following are the benefits of using Caching:

Faster page rendering
Minimization of database hits
Minimization of the consumption of server resources

Types of Caching

Page Output Caching
Page Fragment Caching
Data Caching

Page Output Caching:

Page level, or output caching, caches the HTML output of dynamic requests to ASP.NET Web pages. The way ASP.NET implements this is through an Output Cache engine. Each time an incoming ASP.NET page request comes in, this engine checks to see if the page being requested has a cached output entry. If it does, this cached HTML
is sent as a response; otherwise, the page is dynamically rendered, it's output is stored in the Output Cache engine.

Output caching is easy to implement. By simply using the @OuputCache page directive, ASP.NET Web pages can take advantage of this powerful technique. The following is the complete syntax of page output caching directive

<%@ OutputCache
Duration="no of seconds“ * required field
Location="Any | Client | Downstream | Server | None"
VaryByControl="control"
VaryByCustom="browser |customstring"
VaryByHeader="headers"
VaryByParam="parameter“ * required field
%>

Example:

<%@OutputCache Duration="60" VaryByParam="none" %>
The Duration parameter specifies how long, in seconds, the HTML output of the Web page should be held in the cache.

The VaryByParam parameter is used to indicate whether any GET (QueryString) or POST (via a form submit with method="POST") parameters should be used in varying what gets cached.

Page Fragment Caching

In addition to output caching an entire page, ASP. Net provides Partial-Page Output
Caching, or Page Fragment Caching. Page Fragment Caching allows specific regions of pages to be cached.

Page Fragment Caching is easy to implement. By simply using the @OuputCache
page directive, ASP.NET Web pages can take advantage of this powerful technique.
The syntax looks like this:

<%@ OutputCache Duration="60" VaryByParam="none" VaryByControl="MyRadioButtonList"%>
The Duration parameter specifies how long, in seconds, the HTML output of the Web page should be held in the cache.

The VaryByParam parameter is used to indicate whether any GET (QueryString) or POST (via a form submit with method="POST") parameters should be used in varying what gets cached.

The VaryByControl parameter allows different cache entries to be made based on the values for a specified control.

Data Caching

ASP. Net provides a full-featured cache engine, Programmatic or data caching takes advantage of the .NET Runtime cache engine to store any data or object between responses. That is, you can store objects into a cache, similar to the storing of objects in Application scope in classic ASP.

The ASP. Net cache is private to each application and stores objects in memory. The lifetime of the cache is equivalent to the lifetime of the application.

To store a value in the cache, use syntax like this:

Cache[“myKey"] = myValue; // C#
Cache(“myKey") = myValue ' VB.NET

To retrieve a value, simply reverse the syntax like this:

myValue = Cache[“myKey"]; // C#
myValue = Cache(“myKey") ' VB.NET

Custom paging in grid view control using c#

2009-03-30T16:58:00.015+05:30

In one of my application I required to implement custom paging in the ASP.Net 2.0 Gridview control in the following pattern:

"Previous 10 Pages Previous Page 1 2 3 4 5 6 7 8 9 10 Next Page Next 10 Pages"

In ASP.Net 2.0 GridView is most often used to display the data retrieved from the database in Tabular form with features of Gridview like data paging, sorting and auto formats.
For above mentioned paging, I find a way to implement custom paging in ASP.Net 2.0 GridView control. So this article basically describes how we can implement custom paging style in ASP.Net GridView control.

CSharp (C#) code:

#-----region Class for creating grid view navigation links--------
class NumericWithNext : ITemplate
{

GridView localGrid;
int intSlotNo = 0;

#region CONTRUCTOR
public NumericWithNext(GridView gv)
{
localGrid = gv;
//intSlotNo = slotNo;
intSlotNo = localGrid.PageIndex / 10;

//constructor
}
#endregion

#region HELPER

#region Function for creating Navigation Links
public void InstantiateIn(Control container)
{

LinkButton prevTenRecords = new LinkButton();
prevTenRecords.Text = "Previous 10 Pages";
prevTenRecords.CssClass = "PagingLnks";
prevTenRecords.CommandArgument = ((intSlotNo - 1) * 10 + 1).ToString(); ;
prevTenRecords.CommandName = "Page";
//prevTenRecords.Click += new EventHandler(prevTenRecords_Click);
prevTenRecords.Width = Unit.Pixel(125);
if (intSlotNo > 0)
{
container.Controls.Add(prevTenRecords);
}

LinkButton nextTenRecords = new LinkButton();
nextTenRecords.Text = "Next 10 Pages";
nextTenRecords.CommandName = "Page";
nextTenRecords.CommandArgument = ((intSlotNo + 1) * 10 + 1).ToString();
// nextTenRecords.Click += new EventHandler(nextTenRecords_Click);
nextTenRecords.CssClass = "PagingLnks";
nextTenRecords.Width = Unit.Pixel(118);
// nextTenRecords.Visible = false;

LinkButton prev = new LinkButton();
prev.Text = "Previous Page";
prev.CssClass = "PagingLnks";
prev.CommandArgument = "Prev";
prev.CommandName = "Page";
prev.Width = Unit.Pixel(90);
if (localGrid.PageIndex > 0)
{
container.Controls.Add(prev);
}

//for (int pagenum = 1; pagenum <= localGrid.PageCount; pagenum++)
for (int pagenum = (intSlotNo*10)+1; pagenum <= (intSlotNo+1)*10; pagenum++)
{
if (pagenum > localGrid.PageCount)
{
nextTenRecords.Visible = false;
break;
}
LinkButton pageInd = new LinkButton();
if (pagenum == localGrid.PageIndex + 1)
{
//pageInd.ForeColor = System.Drawing.Color.Green;PagingSelected
pageInd.CssClass = "PagingSelected";
}
else
{
pageInd.CssClass = "PagingLnks";
}
pageInd.ID = "PageInd_" + pagenum;
pageInd.Text = pagenum.ToString();
pageInd.CommandName = "Page";
pageInd.CommandArgument = pagenum.ToString();
container.Controls.Add(pageInd);
pageInd.Width = Unit.Pixel(10);
}

LinkButton next = new LinkButton();
next.Text = " Next Page";
next.CommandName="Page";
next.CommandArgument = "Next";
next.CssClass = "PagingLnks";
next.Width = Unit.Pixel(80);
if (localGrid.PageIndex < localGrid.PageCount - 1)
{
container.Controls.Add(next);
}

container.Controls.Add(nextTenRecords);
}

void nextTenRecords_Click(object sender, EventArgs e)
{
//throw new Exception("The method or operation is not implemented.");
intSlotNo++;

}

void prevTenRecords_Click(object sender, EventArgs e)
{
//throw new Exception("The method or operation is not implemented.");
intSlotNo--;
}
#endregion

#endregion
}
#-------endregion-----------

//--------------Use above mentioned class to create custom paging------------------
private void loadDynamicGrid(DataTable dt)
{

grdSearchResults.HeaderStyle.CssClass = "blkheader gridViewBorder_IP";
grdSearchResults.GridLines = GridLines.None;
grdSearchResults.CssClass = "gridViewBorder_IP";
grdSearchResults.RowStyle.CssClass = "gridViewBorder_IP";
grdSearchResults.HeaderStyle.CssClass = "blkheader gridViewBorder_IP";
grdSearchResults.AlternatingRowStyle.CssClass = "grayRow";
grdSearchResults.PageSize = this.RecordsPerPage;
grdSearchResults.PagerSettings.Mode = PagerButtons.Numeric;
//-------------Create custom paging-----------------------
grdSearchResults.PagerTemplate = new NumericWithNext(grdSearchResults);
//--------------------------------------------------------------------
//Initialize the DataSource
grdSearchResults.DataSource = dt;
//Bind the datatable with the GridView.

grdSearchResults.DataBind();

}

With the help of above code, you will get the results as shown in the below image:

How to move vertical scroll bar using javascript in ASP.Net Web Form

2009-03-30T16:32:00.007+05:30

Whenever ASP.NET Web Form page loaded, by defualt its focus set to first control (vertical scroll bar moved downward in this case) in the ASP.Net web form page. If you required to move your vertical scroll bar to the top of the page, then following client-side script help you in achieving this task:

<script>
function moveVerticalScroll()
{
document.body.scrollTop=0;
}
window.onload=moveVerticalScroll;

</script>

How to set focus on control using javascript

2009-03-30T16:19:00.006+05:30

This article demonstrates how to set focus to an ASP.NET Web Form control by using client-side script.

ASP.NET Web Form controls provide a similar look and feel of the traditional HTML controls while they provide a consistent and structured interface and more robust features. In addition, you can use client-side scripting to enhance the functionality that these controls provide.

In my project, i required to set focus on particular control on the drop down change event. For this i used/added following javascript on the SelectedIndexChanged event of drop down list:

Page.RegisterStartupScript("MoveVerticalScrollBar", "<script>document.all('" + chkEmployee.ClientID + "').focus();</script>");

With the help of above script, focus set to chkEmployee control after the SelectedIndexChanged event of drop down list.

A Rainy Day :: A sweet-2 morning

2008-09-20T14:10:00.018+05:30

A Rainy Day :: A sweet-2 morning

Today is rainy day. I got the chance to see this beautiful weather today morning when my maid came to home and ring the door bell. At that time every one was busy in dreaming except me, so I wake up quickly for opening the door and asked her to make a cup of tea so that I can completely get rid of from my sleep. After taking the tea I was thinking that daily I was missing this beautiful weather created by the GOD.

Also, its good time for me to surprise my fiancé by saying sweet GOOD MORNING, so i make a call to her. During call I was thinking for the song “Mere hath mem thera Hath ho..Saare Jannathe mere saath ho….Tujo paas Ho..phir kya ye jaha ..tere pyaar mem hojavuu FANAA….”, but dear friend It can’t possible at that moment (because we are living too far from each other) and this situation arises due to impact of this sweet rainy morning.

After making a call, i started thinking that why not try to utilize my photographic skill to shot some best pictures. I clicked some picture and added in this post. In the rainy day, I like to eat Bhajias (fried Indian snack). Also known as Pakoras, these are the perfect snack for a cold, rainy day! Make up a batch and serve them with sweet-sour tamarind chutney, YUMMY!

The rainy day is more romantic day in comparision to other day. I love to watch the rain falling. Sometimes the drop of water is hard (thick) and sometimes ever so soft (thin). I love the sound it makes when it hits the ground.

Dear friends this was the starting of my sweet Saturday rainy morning.

A Sweet Rainy morning pictures are :

Serial bomb Blast in Delhi: A Saturday

2008-09-14T16:14:00.010+05:30

Serial bomb Blast in Delhi:

In Delhi, Yesterday (13^th September’08) evening Five blasts rocked New Delhi. The blasts at Ghaffar market in Karol Bagh, at Connaught Place and Greater Kailash took place in quick succession, the police said. All these places are crowded areas of Delhi. In the history of delhi, this Saturday become A Saturday. Last blasts (29^th October’05) in delhi also occurred before festive season (Dushera/ Durga Puja/ Diwali) was arrived.

The first blast took place at Ghaffar market in which at least 20 people were injured. They were rushed to the nearby Ram Manohar Lohia Hospital.

Two explosions took place in Connaught Place, in which at least 10 people were injured.Another explosion rocked M-Block market in Greater Kailash-I.The first blast took place at 6:10 pm. The bomb was placed in a dustbin in a parking lot outside Grover’s Enterprises, a local shop. The blast caused panic among the shoppers and the shopkeepers downed their shutters.

Three unexploded bombs were found later taking the total number of bombs to 8. The first was found near India Gate inside a dustbin at the Children's Park and one was defused at Regal Cinema Hall which was lying on the road, while another one was found at Central Park, again inside a dustbin. A National Security Guard (NSG) team defused the bombs after they were informed by the witnesses about unclaimed objects. NSG experts were assessing the situation and nature of explosives used.

Indian mujahddin has claimed the responsibility .Delhi police arrested mastermind of these bomb blast.

Now, these blasts cleared that this system does not able to handle these terrorism. So that its time for every common man to think about how can remove terrorism from this system. The best example is to follow the story line of A Wednesday movie, in which one common man trying to remove terrorism from this system.

Movie Review - A Wednesday

2008-09-14T15:44:00.002+05:30

A Wednesday is one of the best movies in recent times. It is good time for the Indian Cinema (Bollywood) because directors are coming out with their own new stories and fresh ideas that make an impact on the viewer. The examples of these things are Phoonk and Rock ON. A Wednesday movie is not about the train blasts, nor the sequel to ‘Mumbai Meri Jaan’ which too was about the blasts that rocked the Mumbai city two years ago. This movie (A Wednesday) also based on the terrorism but its showing the pledge and power of the Common Man (Aam Aadmi).


Powered by: Chakpak.com	A Wednesday !

A Wednesday has a star cast that includes veteran actors like Naseeruddin Shah and Anupam Kher. The duo last acted in a movie called China Gate way back in the year 1998. Neeraj Pandey gets them together once again in a hard hitting thriller.

A Wednesday’s plotline is very strong and straight forwad. The story of this movie (A Wednesday)does not contain any sweet songs shot at scenic locales in some distant continent, its totally shot in the Mumbai for giving strong impact to the story line of the movie. This movie talks about terrorism from a new angle. In this movie a common man trying to show to the system that if common man reached to the extreme point of frustration due to the terrorism then it can do anything to clear terrorism from system. In this film director have not been used any religious label to point out terrorism in this system. This is the best thing with this film, because terrorism is related to the entire world not related to particular community.

A Wednesday tells the story of certain events that unfold between 2 and 6 P.M. on A Wednesday in Mumbai. Events that do not exist in any record.

It’s a Wednesday when Prakash Rathod (Anupam Kher), the Commissioner of Police, Mumbai receives a phone call asking him to release four militants.

The caller (Naseeruddin Shah) threatens him saying if he took his call lightly, he would be responsible for a series of 5 bomb blasts in the city. But if he listens to him, many innocent lives would be saved and the caller would also reveal where he had planted the bombs.

Rathod suspects it to be a crank call, but is forced to change his opinion when his men find a bomb at the police station right in front of the headquarters.The information about this bomb given by the caller to Prakash Rathod to prove him self that don’t take me lightly.

It is then that the Chief Minister orders Rathod to tackle this critical situation. While trying to trace the caller, he meets a reporter from a news channel - Naina Roy, played by Deepal Shaw, who has also been tipped off by the same anonymous caller.

Two of Rathod’s best men, Arif (Jimmy Shergill) and Jai (Aamir Bashir) also chip in to trail the caller.

This short, one and a half hour film, has a tight script which would not divert your attention from the silver screen for a split second. The director even manages to squeeze in a couple of comic scenes too e.g. when one man come to police station to logged F.I.R. against his wife / After giving the interview to the News Channel Jai (Aamir Bashir) asked some dialog to Rathod. Director Neeraj Pandey has filmed some mind-blowing sequences and surely has a creative vision which would help him make a name amongst the top directors of Bollywood pretty soon.

Naseeruddin Shah proves yet again that there is just noone like him. Immensely powerful performance, he conveys so much just through his expressions. Anupam Kher too is fantastic, a treat to see the two legends together on screen. Also do watch Jimmy Shergill in one of his best performances to date.

Overall, A Wednesday is not to be missed. Its got the right combination of everything with reveting performance and a movie that will be with you long after you leave the cinema hall.

Movie: A Wednesday

Cast: Anupam Kher, Aamir Bashir, Deepal Shaw, Gaurav Kapur, Naseeruddin Shah,

Rajpal Yadav, Jimmy Shergill

Cinematographer: Fuwad KhanSound

Designer: Rakesh Ranjan

Producer: Anjum Rizvi, Shital Bhatia

Banner: Anjum Rizvi Film Company

Director: Neeraj Pandey

Saddi DILLI to PAGAL hai

2008-09-13T16:41:00.003+05:30

A is for Adjust, Punjabis will always ask you to adjust whenever they want to push you around.

B is for Backside, and it has nothing to do with your bum, it is an instruction to go to the rear of a building, or block, or shop or whatever.

C is for cloney and its first name is not George nor is it a process for replicating sheep – it is an area where people live eg. Dfence cloney.

D is for Saddi Dilli

E is for expanditure – and believe me Punjabis are not scared of spending money – the latest cars, marble floors, their ambitions are always expanding.

F is for fackade, and even though it sounds like a bad word it is actually just the front of a building (with backside being the back, of course).

G is for Gaddi and the way a Punjabi can pilot a car puts any F1 driver to shame, if the Grand Prix does come to Delhi there’s no way Hamilton, Alonso or Kimi can overtake Balvinder, Jasvinder and Sukhvinder.

H is for Ho Jayega, the moment you hear that, you have to be very careful because you can be reasonably sure it’s not going to happen.

I is for Intezaar… to know more about it see P.

J is for Jindagi and if there’s one person who knows how to live life to the full it’s a Punjabi.

K is for Khanna, Khurana, etc – the Punjabi equivalent of the Johnses ie, keeping up with the Khuranas.

L is for Lovely but she never is.

M is for Mrooti – the car that moved an entire Punjabi generation.

N is for No problem ji - to find out how that works see H.

O is for Oye which can be surprise (oyye!), a hailing (oyy), anger (OYY) or pain (oy oy oy).

P is for Panch minit and no matter how near (1 km) or far a Punjabi is from you (100 km) they usually say they’ll reach you in panch minit.

Q is for Queue for which there’s really no word in Punjabi.

R is for Riks and a Punjabi is always prepared to take one, even if the odds are against them. S is for Sweetie, Bunty, Pappu and Sonu who seem to own half the cars in Delhi.

T is for the official bird of P u n j ab –
Tandoori chicken.

U is for when U lose your sex appeal and become ‘Uncle’.

V is for VIP phone numbers @ Rs 15 lakh and counting.

W is War – on the roads.

X is x-rated words they flow freely in casual conversations on the street.

Y is ‘You nonsense’, anger replacing vocabulary in a shouting match.

And Z is for Zig zag for which you should see G, M and P.

Reference: Author: Shivjeet Kullar; Delhi Times; The Times of India;

Use of ASP.Net (C#) Grid View Control in SharePoint (MOSS 2007) User Control:

2008-08-06T14:38:00.007+05:30

In this article, you will learn how to work with the ASP.Net (C#) Grid View Control using the data from a Microsoft SharePoint (MOSS 2007) custom list. In this article we will use ASP.Net (C#) Grid View Control for displaying data from the SharePoint (MOSS 2007) custom list in the SharePoint (MOSS 2007) user control. The ASP.Net (C#) Grid View Control is the best ASP.net control for displaying user friendly data (it means good layout and custom fields/columns) SharePoint (MOSS 2007) user control. I will explain this article to you in a step-by-step manner.

First of all, launch Visual Studio .NET (Start | All Programs | Microsoft Visual Studio 2005 Beta | Microsoft Visual Studio 2005 Beta 2). Create a new Web project (File | New | Web Site) and select the location where your project will be saved. Be sure that you have checked ASP.NET Web Site from the templates section and Visual Basic .NET as your language from the Language drop down box.

Click the OK button and switch to the design view by selecting the appropriate option from the IDE. Now add the item with file extension .ascx for the user control. Now in .ascx file place an instance of GridView controls from the Toolbox (See Figure 2).

Now open the .ascx file in Source mode by clicking the Source mode tab. In the source mode you will be able to see the HTML code of this grid view. In the HTML code of grid view change the name of grid view control to grdResult (ID= grdResult). For displaying custom data from the SharePoint (MOSS 2007) list you need to make some changes in the HTML of the ASP.Net Grid View Control. Suppose we are having the SharePoint (MOSS 2007) Custom List named User. The User list having the following columns:

ID, Title, First_Name, POSITION_DESCR, PHONE_BUSINESS_OFFICE, LOCATION_DESCR.

In the ASP.Net Grid View Control, we will display the above mentioned columns from the SharePoint (MOSS 2007) Custom List named User. For this I have made some changes in the HTML view of the ASP.Net Grid View Control grdResult.

<asp:GridView ID="grdResult" runat="server" AutoGenerateColumns="False" OnRowCommand="gridAction" Width="100%" GridLines="None" HeaderStyle-CssClass="Content_Amit NoRightBorder_Amit" CssClass="dataTableNu_Amit" CellPadding="4" RowStyle-CssClass='NoRightBorder_Amit'>
<Columns>

<asp:BoundField DataField="ID">
<ControlStyle CssClass="off_Amit" />
<ItemStyle CssClass="off_Amit" />
<HeaderStyle CssClass="off_Amit" />
</asp:BoundField>
<asp:ButtonField DataTextField="Title" HeaderText="Last Name" CommandName="EditUser" ControlStyle-CssClass="leftPadding">
<ItemStyle HorizontalAlign="Left" CssClass="leftPadding" />
<HeaderStyle HorizontalAlign="Left" />
</asp:ButtonField>
<asp:ButtonField DataTextField="First_Name" HeaderText="First Name" CommandName="EditUser" >
<ItemStyle HorizontalAlign="Left" CssClass="leftPadding"/>
<HeaderStyle HorizontalAlign="Left" />
</asp:ButtonField>
<asp:BoundField DataField="POSITION_DESCR" HeaderText="Title" >
<ItemStyle HorizontalAlign="Left" CssClass="leftPadding"/>
<HeaderStyle HorizontalAlign="Left" />
</asp:BoundField>
<asp:BoundField DataField="PHONE_BUSINESS_OFFICE" HeaderText="Phone" >
<ItemStyle HorizontalAlign="Left" CssClass="leftPadding"/>
<HeaderStyle HorizontalAlign="Left" />
</asp:BoundField>
<asp:BoundField DataField="LOCATION_DESCR" HeaderText="Location" >
<ItemStyle HorizontalAlign="Left" CssClass="NoRightBorder_Amit"/>
<HeaderStyle HorizontalAlign="Left" CssClass="NoRightBorder_Amit" />
</asp:BoundField>
</Columns>
<HeaderStyle CssClass="content_Amit" />
</asp:GridView>

The css classes used in the grid view are given below:

<style>
.content_Amit {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
font-style: normal;
color: #666666;
padding:5px;
}
.dataTableNu_Amit {
PADDING-RIGHT: 5px; BORDER-TOP: #999 1px solid; PADDING-LEFT: 5px; BACKGROUND-color: #f0f0f0; PADDING-BOTTOM: 5px; COLOR: #666666; PADDING-TOP: 5px; BORDER-BOTTOM: #999 1px solid;BORDER-right: #999 0px
}
.dataTableNu_Amit TH {
BORDER-left: 0px; BORDER-right: #999 1px solid; BORDER-BOTTOM: #999 1px solid;}
.dataTableNu_Amit TD {
BORDER-left: 0px; BORDER-right: #999 1px solid; BORDER-BOTTOM: #999 1px solid;
}
.dataTableNu_Amit .NoRightBorder_Amit,TH.NoRightBorder_Amit{ border-right:0px;
}
.NoRightBorder_Amit
{border-right:0px;
}
.off_Amit{display:none;}
</style>

Now, for displaying data in ASP.Net (C#) Grid View Control from Microsoft SharePoint (MOSS 2007) custom list, we need to write code in C# at code behind i.e. in the .ascx.cs file of the .ascx page.
I have written the two function’s for binding ASP.Net (C#) Grid View Control to the data:

private void bindData()
{
SPWeb web;
//Fetch site name from the web.cofing file
string siteName = ConfigurationManager.AppSettings["siteName"].ToString();
//Open Site connection from the siteName mention in the web.config file
SPSite site = new SPSite(siteName);
///////////////////////////////////
web = site.OpenWeb();
dtUser = GetData(web);
if (dt.Rows.Count > 0)
{
#region If record found
//Bind Grid
grdResult.DataSource = dt;
grdResult.DataBind();
/////////////////
#endregion
}
}

#region Find User details
private DataTable GetData(SPWeb web)
{
SPListItemCollection lstColl = null;
SPQuery query = null;
StringBuilder queryString = new StringBuilder();
try
{
queryString.Append("&ltOrderBy>&ltFieldRef Name='Title' />
query = new SPQuery();
query.Query = queryString.ToString();
if (web.Lists["User"] != null)
{
lstColl = web.Lists["User"].GetItems(query);
}
DataTable dt = new DataTable();
dt = (DataTable)lstColl.GetDataTable();
return dt;
}
catch (Exception ex)
{
throw ex;
}
}
#endregion

I will call the bindData() function on the Page Load event:

protected void Page_Load(object sender, EventArgs e)
{
bindData();
}

The above is the complete code for displaying data from the Microsoft SharePoint (MOSS 2007) custom list in the ASP.Net (C#) Grid View Control.
Happy Coding :).

How access SharePoint (MOSS) User Profile Web Service using JavaScript in SharePoint (MOSS) Content Editor Web Part:

2008-07-23T11:13:00.004+05:30

How access SharePoint (MOSS) User Profile Web Service using JavaScript in SharePoint (MOSS) Content Editor Web Part:
I tried this when I had the requirements in which we need to pass the user profile information let’s say Account Name (User NTID), First Name and Last Name to the some other function in JAVA SCRIPT. For accessing current logged in user information you need to call GetUserProfileByName function of userprofileservice web service.
I have written a JavaScript code for accessing the GetUserProfileByName function of userprofileservice web service:

<script type="text/javascript" language="javascript">

//Complete URL of the page in which you write this code
// http://amitkumarmca04.blogspot.com/sites/MYSITE/AMIT.aspx
var siteCompleteURL=document.URL;

//Split the complete URL from ‘//’
// componentList[0]=’http:’
// componentList[1]= ‘amitkumarmca04.blogspot.com/sites/MYSITE/AMIT.aspx’
componentList=siteCompleteURL.split('//');

//Split the URL (without //) with ‘/’
// siteURL[0]= ‘amitkumarmca04.blogspot.com’
// siteURL[1]=’ sites’
// siteURL[2]=’ MYSITE’
// siteURL[3]=’ AMIT.aspx’
siteURL=componentList[1].split('/');
var baseURL = componentList[0] + "//" + siteURL[0] + "/";
// baseURL=’http:’ + "//" + ‘amitkumarmca04.blogspot.com’ + "/";

var siteURL = componentList[0] + "//" + siteURL[0] + "/" + "sites/ MYSITE /";
// siteURL =’http:’ + "//" + ‘amitkumarmca04.blogspot.com’ + "/" + ‘sites/MYSITE/’

var strAccountName="";
var strFirstName=""
var strLastName=""
var str = '';

function GetRootUrl()
{
return siteURL;
}

function fetchUserData()
{
var a = new ActiveXObject("Microsoft.XMLHTTP");

if(a == null) return null;

a.Open("POST", GetRootUrl() + _vti_bin/userprofileservice.asmx", false);
a.setRequestHeader("Content-Type", "text/xml; charset=utf-8");
a.setRequestHeader("SOAPAction", " http://microsoft.com/webservices/SharePointPortalServer/UserProfileService/GetUserProfileByName");

var d =
"<?xml version=\"1.0\" encoding=\"utf-8\"?><soap:Envelope xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:tns=\"http://schemas.microsoft.com/sharepoint/soap/\"><soap:Body>< GetUserProfileByName xmlns=\"http://microsoft.com/webservices/SharePointPortalServer/UserProfileService\"> <AccountName></AccountName></ GetUserProfileByName></soap:Body></soap:Envelope>";

a.Send(d);

var xmlDoc=a.responseXML;

for(i=0;i<4;i++)
{
if(xmlDoc.getElementsByTagName("Name")[i].childNodes[0].nodeValue=='AccountName')
{
strAccountName=xmlDoc.getElementsByTagName("Value")[i].childNodes[0].nodeValue;
}
else if(xmlDoc.getElementsByTagName("Name")[i].childNodes[0].nodeValue=='FirstName')
{
strFirstName=xmlDoc.getElementsByTagName("Value")[i].childNodes[0].nodeValue;
}
else if(xmlDoc.getElementsByTagName("Name")[i].childNodes[0].nodeValue=='LastName')
{
strLastName=xmlDoc.getElementsByTagName("Value")[i].childNodes[0].nodeValue;
}

}

}

fetchUserData ();
document.write(“Account Name=” + strAccountName);
document.write(“First Name=” + strFirstName);
document.write(“Last Name=” + strLastName);
</script>
In the soap of this web service, when you are not passing any value for the tag <AccountName></AccountName>, then it will return you to the details of current logged in user, if you pass any value between this tag then it will return you to the details of the user for which you have passed the value. This value for this tag would be the NTID of the user e.g. MYCOMPUTER\AMITKUMAR.

Happy Coding :).

How access SharePoint (MOSS) List data using JavaScript in SharePoint (MOSS):

2008-07-03T19:43:00.005+05:30

How access SharePoint (MOSS) List data using JavaScript in SharePoint (MOSS):

In the SharePoint (MOSS) some time you faced the requirements in which by using native SharePoint (MOSS) functionality you need to provide the best solution to the client. Suppose one of the example of this type of requirement is: Without using any server side code you need to display the data from the SharePoint (MOSS) list in the master page. In the SharePoint (MOSS) master page you will be not able to add any web part ( for example SharePoint List View Web Part). In this scenario you will be not able to write any code in the Microsoft Language (e.g. C#.net). At that type of scenario only one option left for the programmer i.e. client side code/client side script i.e. JAVA SCRIPT. Now, our motive is to write the script using JavaScript to fetch/access data from the SharePoint (MOSS) List. In this solution we used the SharePoint (MOSS) List web service to access data from SharePoint (MOSS) List (Custom list/Link List/Document Library/….).

For example I have one SharePoint (MOSS) List called RequestToDate with column name ‘Title’ and my requirement is to display data from the Title column. The JavaScript Code for this are given below:

<script type="text/javascript" language="javascript">

//Complete URL of the page in which you write this code
// http://amitkumarmca04.blogspot.com/sites/MYSITE/AMIT.aspx
var siteCompleteURL=document.URL;

//Split the complete URL from ‘//’
// componentList[0]=’http:’
// componentList[1]= ‘amitkumarmca04.blogspot.com/sites/MYSITE/AMIT.aspx’
componentList=siteCompleteURL.split('//');

//Split the URL (without //) with ‘/’
// siteURL[0]= ‘amitkumarmca04.blogspot.com’
// siteURL[1]=’ sites’
// siteURL[2]=’ MYSITE’
// siteURL[3]=’ AMIT.aspx’
siteURL=componentList[1].split('/');

var slideImagesArr=new Array();

var slideImagesDisplayArr=new Array();

var slideImageLinksArr=new Array();

var baseURL = componentList[0] + "//" + siteURL[0] + "/";
// baseURL=’http:’ + "//" + ‘amitkumarmca04.blogspot.com’ + "/";

var baseLibURL = componentList[0] + "//" + siteURL[0] + "/" + "sites/ MYSITE /Lists/RequestsToDate/DispForm.aspx?ID=";
// baseLibURL =’http:’ + "//" + ‘amitkumarmca04.blogspot.com’ + "/" + ‘sites/MYSITE/Lists/RequestsToDate/DispForm.aspx?ID='

var siteURL = componentList[0] + "//" + siteURL[0] + "/" + "sites/ MYSITE /";
// siteURL =’http:’ + "//" + ‘amitkumarmca04.blogspot.com’ + "/" + ‘sites/MYSITE/’

//GUID of RequestToDate list
var listGUID = "6f9d3029-120e-4177-9f9b-bdeae0598df2";

var str = '';

function GetRootUrl()
{
return siteURL;
}

function getNodeValue(obj,tag)
{
return obj.getElementsByTagName(tag)[0].firstChild.nodeValue;
}

function QueryListEx()
{
var a = new ActiveXObject("Microsoft.XMLHTTP");

if(a == null) return null;

a.Open("POST", GetRootUrl() + "_vti_bin/Lists.asmx", false);
a.setRequestHeader("Content-Type", "text/xml; charset=utf-8");
a.setRequestHeader("SOAPAction", "http://schemas.microsoft.com/sharepoint/soap/GetListItems");

var d =
"<?xml version=\"1.0\" encoding=\"utf-8\"?><soap:Envelope xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:tns=\"http://schemas.microsoft.com/sharepoint/soap/\"><soap:Body><tns:GetListItems><tns:listName>{"+listGUID+"}</tns:listName><viewFields><ViewFields><FieldRef Name=\"ID\"/></ViewFields></viewFields></tns:GetListItems></soap:Body></soap:Envelope>";

a.Send(d);

var xmlDoc=a.responseXML;
var responseElement=xmlDoc.getElementsByTagName("z:row");
var temp = '';

for (i=0;i<responseElement.length;i++)
{
//Store Title Column Value
slideImagesArr[i] = responseElement[i].getAttribute('ows_Title');

//Store ID Column Value
slideImageLinksArr[i] = responseElement[i].getAttribute('ows_ID');

//Store Created date Column Value
slideImagesDisplayArr[i] = responseElement[i].getAttribute('ows_Created');
}

if (a.status != 200)
return null;
else
{
if (extractRows)
return a.responseXML.selectNodes('//Row');
else
return a.responseXML;
}
}

QueryListEx(false);

</script>

<DIV id=divMaster></DIV>
<script>

</script>

In the above code divMaster is the ID of the DIV, in which we are displaying the data from the SharePoint (MOSS) List called RequestToDate.

I think the above solution helps you in writing the code when you are not able to write any server side code (for example C#/C-Sharp) for fetching/ retrieving data from the SharePoint (MOSS) List.

First gay parade in Delhi:

2008-06-30T12:05:00.026+05:30

In this world everyone have the freedom to live like king. This thing tried by the people on June 29 2008 in three Indian cities in the largest display of gay pride in the deeply conservative country where homosexual acts are illegal. It is the co-oridinated effort of gays, lesbians and transvestites.

These Gay rights supporters took to the streets of Calcutta, Bangalore and New Delhi to call for an end to discrimination and push for acceptance in a society where intolerance is widespread. They are wearing colourful costumes and holding ply cards demanding gay rights, people walked singing and dancing.
In delhi , this was happn first time and the members of these groups took out a march which culminated with a candle light vigil at Jantar Mantar (New Delhi).

According to the law of our country, consensual homosexual sex act is illegal and is punishable by imprisonment but everyone has the right to stage a march for their demands. So activists, who started their 'walk' from Connaught Place (New Delhi), demanded repeal of section 377 of the Indian Penal Code which terms alternative sexuality a crime. The June 29 march is an annual event across the globe to mark the 1969 riots in New York when police arrested hundreds of gays from a pub. The riots had continued for five days.

Activists supporting alternative sex observe the week leading to June 29 as Rainbow Pride Week. Rainbow flag is a symbol of alternative sexual groups the world over.

How to make your relationship strong and partner happy:

2008-06-22T00:01:00.016+05:30

For making your life good without misunderstanding you need to take care of your partner. It will give you the great feeling. Make her or him happy by understanding her or his needs.

But every person is unique and so it’s not easy to make every person’s happy. Some people are very short tempered; in that case one of the partners should be calm because if both would be short tempered then some consequences might be occurred. So being patient is a must to make the relationship works. And do not make any negative comments to each other regardless how mad you are. Because words hurts more than a kick in your face. This level of support and understanding creates a foundation for developing an individual’s full potential and his feelings of satisfaction and fulfillment which allows him/her to give their all.

It’s good you are spending quality time with each other but also give time to your partner for doing work. It’s mean every person have some work to do, at that time don’t feel bad. This situation builds negative thoughts in the good relationship.

After some years of marriage both become very used to each other, despite that both are having some bad habits. They know that these habits not like by other one, instead of removing these habits we give the excuse that it’s too late for me to quit/remove these habits. If you want to make your partner happy, it would be good that you try to change/remove your bad habits. We can choose to change our habits and brighten our future. It is never too late.

We all know that whenever partner forgets the birthday, anniversary, or important dates (something special like when we meet first time and etc.) that make other partner frustrating. For good relationship it is very serious point and should never happen again. These occasional celebrations make closer to both of you.In that occasion gifts played the important role. Gifts make the relationship strong. In the good relationship and love, the cost of gifts doesn’t matter but the feeling of person who is giving that gifts only matter. You don't have to do anything huge in a new or fairly new relationship, but flowers are nice. A card is always cool too. When you are giving a gift, you are conveying a message with it. The right type of gift can convey your message clearly and perfectly.

In the relationship many partners don’t like to talk about love. They don’t know how express feeling to make other partner happy (its mean he/she is very special in my life) and wait for the other partner to take initiative. In the relationship male partner hesitate in telling female partner that I love u but they act differently to express this feeling. The female partner not feels happy unless they hear those golden words, I LOVE U. The male partner also wants to hear these words from the female partner. The meaning of love vary from men to men, some men think that in the serious relationship these words never come , some said that these golden words comes automatically in serious relationship, or some understand these words after spending a lot of time in the relationship. Its mean whenever men understand the feeling and respect from female partner then they automatically know what is the importance of these golden words (I LOVE U) in their life, it can be happen in any stage of life. In the LOVE, care/respect/understanding are the important pillars. The LOVE without these pillars is like LUST. These perceptions also true in the case of women. But women not take initiative in that case. They first want to know that the hands (men) in which she is giving her life is of what type and what is the meaning of LOVE for him. The meaning of what type is not that she is doing testing of yours, its means she is analyzing your behavior/attitude towards the different scenario/condition of the real life. They (female) closely analyze the each and every step taken by the men in relationship, after that she makes her perceptive about love (the golden words). It would be wonderful if partners in relationship understand these golden words, I LOVE U and don’t wait for the other partner, for telling these golden words.

In the relationship, every small thing is very important. These small things can make your partner happy. For example make a special dish (the dish like by your partner) for your partner for giving surprise/pleasure/importance, a surprise which contain the feeling of yourself about your partner and anything unexpected and small. You know that for achieving great pleasure in your life you need to take care of each and every small thing.

Many of us spend more time at work place that becomes the backdrop for us many time.Spending more time at work place render differences in personal life. Because at work place, many of us forget about the family and engaged in their work but at that time some one in the family need our presence. Some time for help/work and in other role. But they don't know we are working for endurance. So for removing differences between these two life we need to take care of requirement which belong to these two life. For this there is no arduous rule it will depend upon the thinking level of person.

For making your partner happy, YOU must be happy first. Happiness is contagious, and if you’re happy with life, your energy will affect people around you in a positive way. Take care with what kind of relationships you form and the people that you spend time with.

Customizing Search Results with Custom XSLTs in SharePoint Server 2007

2008-06-18T09:38:00.012+05:30

Introduction

When users perform search queries by using Microsoft Office SharePoint Server 2007, the search results are rendered by the Search Core Results Web Part. The rendered HTML that users see is actually an XSLT transformation applied to the XML that contains the search results. If you want to change the color and layout of this page then below are the some tricks to apply these changes.

Background

First of all, we should understant that what is Search Core Results web parth. This web part is inbuild web part provided by the MS Office Sharepoint Sever 2007 for searching records in the sharepoint site. This web part contain the settings related to search scope,layout and etc.

Custom change in the XSLT file:

1. Open the sharepoint page in edit mode and add search core result web part.

2. In the Bottom Zone, in the Search Core Results Web Part, click edit, and then click Modify Shared Web Part.

3. In the Search Core Results tool pane, click XSL Editor. Create an empty XML file by using Microsoft Visual Studio 2005, and then copy all the XSLT into the XML file.

4. If you want to change the background color of searched text:

Search Code :

            //
          // <xsl:template match="ddd">

Below are the tags that exist after above mentioned tag :

  <xsl:template match="c0">
  <b><xsl:value-of select="."/></b>
</xsl:template>
<xsl:template match="c1">
  <b><xsl:value-of select="."/></b>
</xsl:template>

The above mentioned tag exist from c0-c9. For displaying background color in searched text, you need to add the span tag above the "b" tag.

<xsl:template match="c0">
<span style="background-color:yellow">
  <b><xsl:value-of select="."/></b>
</span>
</xsl:template>
<xsl:template match="c1">
<span style="background-color:yellow">
   <b><xsl:value-of select="."/></b>
</span>
</xsl:template>

5. If you want to change the background color of page, spaces from top/bottom/left write and want to add line in the top/bottom of the search result page:






Search Code :
           //
           //
<xsl:template name="dvt_1.body">
           // in the XSLT file
//Add div tag below the above mentioned tag:
      
<div class="srch-results" style="background-color:#f0f0f0;border-top: #999 1px solid;border-bottom: #999 1px solid;padding-top:1px;padding-bottom:1px;padding-left:1px;padding-right:1px">

After doing these changes,save the xslt file then you will be ablt to see the above mentioned changes in your search result page.

Search results returned by the search engine are returned in XML format. The Search Core Results Web Part takes this XML as input and then applies an XSL transformation on the XML to render the HTML that users see on the search results page. This XSLT is public; it can be modified and replaced with custom XSLT to display results according to your requirements.

How access relative url of site in Sharepoint-Used in master pages

2008-06-17T15:55:00.009+05:30

If you are creating the master pages in SharePoint. In this master page
you have created the image tab and you want to linked this image tab
with the particular page(for example publish page in Sharepoint) from
the SharePoint site(or site collection). Another use of relative url is
if you are referencing resources such as style sheets, images,
JavaScript etc in a SharePoint environment you need to be careful to
ensure that URLs are relative to the current site (or site collection)
so that if sites are moved the references don’t break.

For example you have created the image tag :

Now you want to linked this image tab with AboutUs page(for example publish page in Sharepoint) of your current SharePoint site(or site collection in SharePoint):

i. For Site URL(relative site url in sharepoint):

In the above anchor tag(i.e. tag a) we have written the runat="server", its mean we are
telling to the sharepoint engine that its is a server side control not client site.

ii. For Site Collection URL(relative site collection url in sharepoint):

In the above anchor tag(i.e. tag a) we have written the runat="server", its mean we are
telling to the sharepoint engine that its is a server side control not client site.

We can use relative url in master pages, page layouts or other pages on the site by
using the SPUrl expression. SPUrl define prefix provided by the
Microsoft.SharePoint.Publishing.WebControls.SPUrlExpressionBuilder class.

Code related to Excel Macros

2008-05-16T10:41:00.003+05:30

Code related to Excel Macros:

In this article I am trying to explore some important code related to VB macros which can help you to write robust VB macro based excel project.

For all code I am using the “Test.xls” excel file which have two work sheets:

1. Inventory

2. Payroll

Add the following reference to project:

1. Microsoft Excel 12.0 Object Library

2. MicrosoftOffice 12.0 Object Library

3. Microsoft Forms 2.0 Object Library

4. Microsoft Scripting Runtime

i. If you want to find total numbers of used rows and columns in the work sheet Payroll:

Dim wsheet_Payroll As Excel.Worksheet

Dim USEDROW_Payroll As Long

Dim USEDCOL_Payroll As Long

‘Create connection to Payroll worksheet

Set wsheet_Payroll = Worksheets("Payroll")

‘Activate the Payroll shett

wsheet_Payroll.Activate

‘Find total number of Used Row in the Payroll sheet

USEDROW_Payroll = wsheet_Payroll.UsedRange.Rows.Count

‘Find total number of Used Row in the Payroll sheet

USEDCOL_Payroll = wsheet_Payroll.UsedRange.Columns.Count

ii. If you want to find first occurrence some text(for example: Deducted) and want to delete that column in which text found in the work sheet Payroll:

Dim wsheet_Payroll As Excel.Worksheet

Dim USEDROW_Payroll As Long

Dim USEDCOL_Payroll As Long

Dim Driverrange_Payroll As Range

Dim oTemp As Range

Dim ROWSTART_Payroll As Long

Dim COLSTART_Payroll As Long

‘Create connection to Payroll worksheet

Set wsheet_Payroll = Worksheets("Payroll")

‘Activate the Payroll shett

wsheet_Payroll.Activate

‘Find total number of Used Row in the Payroll sheet

USEDROW_Payroll = wsheet_Payroll.UsedRange.Rows.Count

‘Find total number of Used Row in the Payroll sheet

USEDCOL_Payroll = wsheet_Payroll.UsedRange.Columns.Count

‘Define the range in which you need to search the text

Set Driverrange_Payroll = wsheet_Payroll.Range("a1:HV" & USEDROW_Payroll)

'---------Find Deducted in Payroll Sheet------------

Set oTemp = Driverrange_Payroll.Find("Deducted")

If Not oTemp Is Nothing Then

‘If Deducted exist in the Payroll sheet

‘----Store row number------

ROWSTART_Payroll = oTemp.Row

‘----Store column number------

COLSTART_Payroll = oTemp.Column

'----Delete column --------

wsheet_Payroll.Columns(COLSTART_Payroll).Delete

'------------------------------------

Set oTemp = Nothing

End If

iii. If you want to find first occurrence some text(for example: EmplidSearch) and want to insert new column with value after that column in which text found in the work sheet Payroll:

Dim wsheet_Payroll As Excel.Worksheet

Dim USEDROW_Payroll As Long

Dim USEDCOL_Payroll As Long

Dim Driverrange_Payroll As Range

Dim oTemp As Range

Dim ROWSTART_Payroll As Long

Dim COLSTART_Payroll As Long

‘Create connection to Payroll worksheet

Set wsheet_Payroll = Worksheets("Payroll")

‘Activate the Payroll shett

wsheet_Payroll.Activate

‘Find total number of Used Row in the Payroll sheet

USEDROW_Payroll = wsheet_Payroll.UsedRange.Rows.Count

‘Find total number of Used Row in the Payroll sheet

USEDCOL_Payroll = wsheet_Payroll.UsedRange.Columns.Count

‘Define the range in which you need to search the text

Set Driverrange_Payroll = wsheet_Payroll.Range("a1:HV" & USEDROW_Payroll)

'---------Find Deducted in Payroll Sheet------------

Set oTemp = Driverrange_Payroll.Find("EmplidSearch")

If Not oTemp Is Nothing Then

‘If Deducted exist in the Payroll sheet

‘----Store row number------

ROWSTART_Payroll = oTemp.Row

‘----Store column number------

COLSTART_Payroll = oTemp.Column

'----Insert column after empid--------

wsheet_Payroll.Columns(COLSTART_Payroll).Offset(, 1).Insert

'------------------------------------

'----------Enter value =Deducted in all columns---------

wsheet_Payroll.UsedRange.Columns(COLSTART_Payroll + 1).Value = "Deducted"

'------------------------------------

Set oTemp = Nothing

End If

Send Mail using System.Web.Mail object in C#(C-Sharp):

2008-05-16T09:45:00.005+05:30

Send Mail using System.Web.Mail object in C#(C-Sharp):

In Visual Studio 2005 microsoft provided the new mail component called System.Web.Mail for sending email. In this article I am defining you that how can you send the mail in HTML format with attachment.

Add the reference to System.Web.Mail. In this article I am using the function

sendMail for sending email with attachment. The definition of function is

sendMail(string strFrom, string MailID, string strLogFile). In this strFrom variable contains the email address of person who are sending the mail, MailID contains the email addresses of person to whom mail would be send and strLogFile contain the physical path of log file, which send as a attachment. The body part of the function is:

public void sendMail(string strFrom, string MailID, string strLogFile)

{
string strMessage;
string ToMail_ID;
string strYourEmail = strFrom; // from mail id
System.Web.Mail.MailMessage sMail = new MailMessage();
ToMail_ID = MailID; // " LIST OF TO MAIL ID"
sMail.To = ToMail_ID;
sMail.From = strYourEmail;
sMail.BodyFormat = MailFormat.Html;
sMail.Priority = MailPriority.High;
sMail.Attachments.Add(new System.Web.Mail.MailAttachment(strLogFile));
strMessage = "It is test mail.";
sMail.Body = strMessage;
sMail.Subject = “Test Mail”;
SmtpMail.SmtpServer="";

try

{

SmtpMail.Send(sMail);

}

catch (Exception ex)

{

//check the InnerException

while (ex.InnerException != null)

{

ex = ex.InnerException;

}

Now you can call the function as:
sendMail("mcapassion@gmail.com","mcapassion@gmail.com,a@a.com", "C:\TestMail.log");

Add/Update/Delete operations on the Sharepoint List Item using C#(C-Sharp)

2008-05-15T12:58:00.010+05:30

Add/Update/Delete operations on the Sharepoint List Item using C#(C-Sharp):

The list present in the SharePoint serves as a table which we used in the relational database. Its means in SharePoint we used list for storing user data instead of table used in RDB. These lists contain data which are required by the user for doing some computational operation or for other functionality. Here I am taking the scenario of the User List for storing user details. This list contain the details of user i.e. first name , last name and email id. With the help of this list I will explain you, how you can add/update/delete items in the list with the help of C#(C-Sharp).

First add the reference to Microsoft.SharePoint. After that create the object of SPSite:

SPSite oSiteCollection = new SPSite();

siteName should be the url of your sharepoint site.

Now create the object of SPWeb with the help of SPSite object:

SPWeb oWebsiteRoot = oSiteCollection.OpenWeb();

oWebsiteRoot.AllowUnsafeUpdates = true;

After that create the connection to the User List and create object of SPListItemCollection :

SPList oList = oWebsiteRoot.Lists["User"];

SPListItemCollection listItemCOll;

If you want to add the item in the User List then use following steps:

SPListItem oListItem = oList.Items.Add();

oListItem["FIRST_NAME"] = “Amit”;

oListItem["LAST_NAME"] = “Kumar”;

oListItem["EMAIL_ADDR"] = “mcapassion@gmail.com”;

oListItem.Update();

After that new item(row) would be added in the User List.

If you want to update the item in the User List whose EMPLID is “101” then use following steps:

Create the object of SPQuery:

SPQuery query = new SPQuery();

//Create query for fetching record which are having EMPLID=101

//Fetch item from the User List by passing query to the User List

listItemCOll = oList.GetItems(query);

if (listItemCOll.Count > 0)

{

//If record found in the list

{

//Take the reference of that item

SPListItem listItem = listItemCOll[icount];

listItem["FIRST_NAME"] = “A”;

listItem["LAST_NAME"] = “Kumar”;

listItem["EMAIL_ADDR"] = “mcapassion@gmail.com”;

//Update the Item

listItem.Update();

}

If you want to delete the item in the User List whose EMPLID is “101” then use following steps:

Create the object of SPQuery:

SPQuery query = new SPQuery();

//Create query for fetching record which are having EMPLID=101

//Check items exist in the User List or not

if (oList.Items.Count > 0)

{

//Fetch item from the User List by passing query to the User List

listItemCOll = oList.GetItems(query);

if (listItemCOll.Count > 0)

{

//If record found in the list

listItemCOll [0].Delete();

}

The above mentioned steps help you to create Custom Web parts/User controls in SharePoint for full filling the user requirement.