aMiT kUmAr

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.

Live like a leader : Integrity

2008-05-02T10:51:00.006+05:30

I think, you can't control what people say or think about you. You can't control the decisions prospective clients make. You can't control the economy, the stock market or the weather.

In this unstable environment, there is one thing over which you have absolute control: your integrity. One thing which is true for all that no body can stole your destiny. If somebody tries to steal it from you but then you can save it with your integrity.

You can’t exhibit your integrity; it drives from the mathematical term: integer. An integer is a whole number. It is not divided. If a person has integrity, he/she is the leader. Their lifestyle doesn’t change with the time because their morals, ethics and treatment towards other person remains same all the time.

Integrity is the pillar of leadership. Integrity determines the way we work within the Group.
There is no alternate of personal integrity. At a time when an employee faces a difficult situation he/she should think on these points:

Is my action or decision legal?
Is the action taken by me, according to my values and suitable for the situation.

If the answer to above mentioned question is “yes”, the action or decision is most likely to be the correct one which is Golden rule to maintain integrity.

you look at all the religions in the world, they all have the identical Golden Rule, almost word to word. It doesn't make any difference what religion or geography it is.

When you follow the Golden Rule and live with integrity, you set an example that has a far greater impact than the words you could ever speak. That’s it from my side and now up to you how maintain your integrity to live like a leader.

Microsoft® Visual C#® Default Keybindings

2008-04-04T09:19:00.000+05:30

Download the very handy wall chart PDF listing all the useful keyboard shortcuts for Visual Studio C# 2008. It works for the Visual Studio C# 2008 Express Edition as well.

Life at work and home

2008-02-10T18:50:00.001+05:30

In every man life personal and professional life is very important. Every person have own perception about these lives. In the other words the way of thinking in these places(personal and professional) is different from person to person. Sometime we prefer personal life and in other time professional life.
In real life, for survive, we do work. Every people have energy to do work for survival of their family life. For this every people have idea in their mind.Every people spend their energy to make result which is beneficial for their company. In the response of this result, company give them a paycheck that would be beneficial for survival of their family life. In this world, we have lots of problems and opportunities where we can burn our energy to produce result which will return good output for us.
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.

Good relationship

2007-10-11T10:59:00.002+05:30

Everyone wants to maintain good relationship with their partner throughout the life. But some received success in this and other not able to maintain this (or they simply carry this relationship throughout the life as a social responsibility). These days many Bollywood movies based upon this issue, the movies which totally based upon this issue are Salam Namaste, KANK, Metro and Delhi Heights.

According to these movies, at the starting time of relationship the life was going cool because both were new to each other (opposite sex interact each other in the starting). After some time when this thing not matter then they are trying to notice each other behavior on every incident. This type of investigation will be the starting point to break your good relationship.

I learned some points to maintain good relationship from my married friends:

1. Good Listener: Lack of communication is very frustrating to partner but if you are also not a good listener then you will make your partner dander. Most of the people concentrate more on television than our wives or girlfriend. Most women want to talk about personal things that directly related to their life, family or friends.

2. Don’t forget the occasion: We all know that whenever husband forgets the birthday, anniversary, or important dates (something special like when we meet first time and etc.) that make women frustrating. For good relationship it is very serious point and should never happen again. These occasional celebrations make closer to both of you.

3. Know People: Every woman want to introduce their family and friends, but men always not interested in this. The woman wants to make these people, important part of their life, which will help in the bad time. And women also expect this from her husband.

4. Professional Life: Always keep distance between your personal and professional life. For example consider the case: When you got married with person of same profession (and also working in competing company). In this scenario, don’t try to investigate what is going on their professional life.

5. Sharing household chores: It is quite astonishing, when you are sharing household chores. It is the key of successful marriage life. Both man and woman have different perception about household chores. If you speak separately from both, you will receive different answer. Mr. will say, he is very helpful and madam answer would be, she’s doing the entire job.
All man have different thinking about what are the household chores: Making a food twice a week, cleaning of garbage, ironing his shirts and shopping for filling the fridge. So, it’s up to you, how you handle household chores.

My dear friends the above points applicable on both men's (jamana to hai naukar biwi ka..) and woman’s(kudio ka hai jamana..) for making good relationship.

Love Ke Liye Kuch Nahi Karega

2007-10-09T13:11:00.000+05:30

This post dedicated to the people who want something special in their life without doing any effort and people who want something special but sometime not (their target is not consistent). Some people around me have these type thinking.

One of the people around me like someone very much, but don’t have guts to say magic words from their heart. We always propel them for doing this, with many ways. But these people never go ahead, I don’t know why? When the queen/king of his heart talking to someone else, at that time personality of this type of people converted into Gullu(Bad Man)/ShashiKala(Wamp). We had given many chances to him/her for doing something, but nothing happen (they unable to take initiative). After that he/she told us, I am not that type of person and I have some ethics in my life (simple living) which I never cross like other people do (Like Hum Mata ke bhakt hai wado ke sakht hai akash se hum aye aur wado ke sakht hai).

Now I am moving towards the second type of people, who don’t know what they need in their life. Its mean sometime they like him/her, in other instance they told us, I am not interested. They already told everybody don’t mingle with him/her. They also convey their message towards him/her with the help of intercessor, but don’t able to convey their words (which comes from heart) directly to the target (Like Chupana bhi nahi ata.. batana bhi nahi ata, humein tumse mohabat hai jatana bhi nahi ata). We always ready to help him/her. But he/she is thinking that we are joking and doing something buggy in their way of love (Pyar ke rastein mein kantein hai).

Now my dear friends don’t take time to tell magic words to your loved one. I learned these lines from Bollywood movies, so before taking action please think twice.