Learn .NET, SharePoint, EPiServer CMS and BizTalk

Exporting DataSet to Excel

2009-09-05T03:06:00.000-07:00

Exporting Dataset to Excel is not a big deal. Wide range of help related to it is available on the net. This article for Exporting Dataset to Excel with the idea that the beneficiary will only need to COPY, PASTE and USE it.

Here is the code.

Add a class and copy the below code into it:

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public class ExportDataset
{
public void ExportToExcel(DataSet dSet, int TableIndex, HttpResponse Response, string FileName)
{
Response.Clear();
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
Response.AppendHeader("content-disposition", "attachment; filename=" + FileName + ".xls");
System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
GridView gv = new GridView();
gv.DataSource = dSet.Tables[TableIndex];
gv.DataBind();
gv.RenderControl(hw);
Response.Write(sw.ToString());
Response.End();
}
}

And copy the following code on the Button Click Event (or at appropriate place):

SqlConnection con = new SqlConnection("Server=TestServer;uid=test;pwd=test;database=test;");
con.Open();
SqlDataAdapter adp = new SqlDataAdapter("select * from BTA_tblTimeEntry", con);
DataSet ds = new DataSet();
adp.Fill(ds);
ExportDataset objExport = new ExportDataset();
objExport.ExportToExcel(ds, 0, Response, "Report");
con.Close();

SharePoint Videos

2009-08-20T21:42:00.000-07:00

Hi Friends,

Please check my latest blog for updates on only SharePoint.

It contains SharePoint interview questions and Learning material.

My New SharePoint blog link: Check SharePoint Videos

Happy Learning :)

What is Tivoli Storage Manager?

2009-08-11T02:43:00.000-07:00

IBM Tivoli Storage Manager is a client and server program that provides storage management solutions to customers in a multi-vendor computer environment. IBM Tivoli Storage Manager provides an automated, centrally scheduled, policy-managed backup, archive, and space-management facility for file servers and workstations.

For more details IBM Tivoli Storage Manager

What is EPiServer CMS?

2009-08-10T23:56:00.000-07:00

Before going the definition of EPiServer CMS, lets learn about CMS.

Go through the following link to know What exactly CMS.

EpiServer CMS comes under Web Content Management System (WCMS), which allows us to Publish and Design process of pages on website with out any specific knowledge on HTML.

More about WCMS

What is CMS?

2009-08-10T23:46:00.001-07:00

A content management system (CMS) is a system used to manage the content of a Web site. Typically, a CMS consists of two elements: the content management application (CMA) and the content delivery application (CDA). The CMA element allows the content manager or author, who may not know Hypertext Markup Language (HTML), to manage the creation, modification, and removal of content from a Web site without needing the expertise of a Webmaster. The CDA element uses and compiles that information to update the Web site. The features of a CMS system vary, but most include Web-based publishing, format management, revision control, and indexing, search, and retrieval.

Microsoft Office SharePoint Designer 2007

2009-08-10T23:36:00.000-07:00

Office SharePoint Designer 2007 uses FrontPage technology, but the new name reflects the emphasis on creating and customizing SharePoint sites and customizing applications on the SharePoint platform. With Office SharePoint Designer 2007, you can build sophisticated no-code solutions such as Data Views, reports, and workflow tracking quickly and easily by using menus, task panes, and templates.

Help for SharePoint Designer 2007

Video demos and training for office SharePoint server 2007

2009-08-10T23:32:00.000-07:00

Please go through the below link for SharePoint video demos and training.

SharePoint Video demos and Training

Thank you

Access modifiers in C#.

2009-07-23T21:30:00.001-07:00

The Default access modifier for class is 'internal'.
The Default access modifier for all the members of class is 'private'

Visual Basic counterparts for each of the C# keywords.

2009-07-23T09:45:00.000-07:00

	C#	VB
Class cannot be inherited (cannot be a base class).	Sealed	NotInheritable
Class cannot be instantiated but only used as based class and/or with abstract methods.	Abstract	MustInherit
For class members: member is accessible only from the class in which it is declared. For classes: only allowed on nested classes to restrict access to the nested class to the containing class..	Private	Private
For class members: member is accessible only from types defined in the same assembly. For classes: class is accessible only from types in the same assembly.	Internal	Friend
For members: member is accessible from the class in which it is declared and from any class derived from that class.	Protected	Protected
Combines the access of Protected and Internal for a class member	Protected Internal	Protected Friend
Access is not restricted.	Public	Public
Hides a member inherited from a base class.	New	Shadows

Getting Contacts from ACT CRM

2009-07-15T13:35:00.000-07:00

public ContactList GetContacts(SortCriteria sortCriteria);

//Example 1
ContactList cList = ActFwk.Contacts.GetContacts(null);

//Example 2
//This example populates a ContactList sorted by the contacts Last Name, First Name.
//It then displays the name of the first contact in the list.
ContactFieldDescriptor cfd1 = ActFwk.Contacts.GetContactFieldDescriptor("TBL_CONTACT.LASTNAME", true);
ContactFieldDescriptor cfd2 = ActFwk.Contacts.GetContactFieldDescriptor("TBL_CONTACT.FIRSTNAME",true);
SortCriteria[] sCriteria={new SortCriteria(cfd1,ListSortDirection.Ascending),
new SortCriteria(cfd2,ListSortDirection.Ascending)
};
ContactList cList = ActFwk.Contacts.GetContacts(sCriteria);
Contact cContact = cList[0];
MessageBox.Show(cContact.FullName);

Explain about documentation comments.

2009-07-12T10:07:00.002-07:00

C-Sharp introduced documentation comments to generate the documentation for your classes and programs. These are line comments and start with triple slash mark (///).

/// These are documentation comments.

Can CSharp program have morethan one Main method?

2009-07-12T09:58:00.001-07:00

Yes. but you have to explicitly identify which Main method is the entry point at run-time.

What is a namespace?

2009-07-12T09:44:00.000-07:00

namespace is a collection of logically related classes. The purpose of namespace is to prevent name conflicts. namespace can contain child namespace.

Where the Project and Solution information stored?

2009-07-12T06:54:00.000-07:00

Project: Project is a combination of Executable and Library files. A project's information is usually stored in a file with the extension of '.csproj' for C-Sharp projects, '.vbproj' for VB.NET projects.

Solution: Solution is a place holder for logically related projects. Solution information is usually stored in a file with the extension of '.sln'.

.NET Framework

2009-07-12T04:22:00.000-07:00

The .NET Framework is the combination of layers of CLR, FCL, Data and XML classes and all our .NET (Windows, Web, Web Services) Applications.

Garbage Collection (GC)

2009-07-12T04:10:00.000-07:00

CLR also contains Garbage Collector (GC), Which runs in a low priority thread and checks for un-referenced, dynamically allocated memory space. If it finds some data that is no longer referenced by any variable/reference, it re-claims it and returns it to the OS. The presence of Garbage Collector frees the programmer keeping track of dangling data. Ask any C++ Programmer how big a relief it is !!! :)

The Common Type System (CTS)

2009-07-12T03:32:00.000-07:00

.NET Framework defines a Common Type System (CTS), like CLS, CTS is also a set of standards. CTS defines the basic data types that IL understands. So each .NET language should map its data types to these CTS data types. This makes it possible for the two languages to communicate each other by passing/receiving parameters to and from each other.

Example: CTS defines a type, Int32, an integral data type of 32 bits, which is mapped by C# through int, VB.NET through Integer data type.

The Common Language Specification (CLS)

2009-07-12T03:25:00.000-07:00

Microsoft has released a small set of specifications that each language should meet to qualify as a .NET compliant language. The code which is under CLS boundary can be usable in any other .NET Language. Those set of specifications are nothing but CLS in .NET Framework.

Example: There should not be any global function declarations, no pointers, no multiple inheritance and things like that.

The Framework Class Library (FCL)

2009-07-12T03:00:00.001-07:00

The .NET Framework provides a huge Framework (or Base) Class Library for common, usual tasks. FCL contains thousands of classes to provide access to Windows API and common functions like String Manipulation, Common Data Structures, IO, Streams, Threads, Security, Network Programming, Windows Programming, Web Programming, Data Access etc. We can use all those FCL classes in our .NET programs, even we can even apply inheritance and polymorphism to all these FCL classes.

Just In Time Compilers (JITers)

2009-07-12T00:17:00.000-07:00

When MSIL code needs to be executed, CLR invokes the JIT compiler, which compile the IL code into executable binary code (OS native code) i.e. exe or dll for a specific machine and OS. JITers in many ways are different from traditional compilers as JITers compile MSIL into native code only when desired.

Example: When a function is called, the MSIL of the function's body is converted to native code just in time. So the part of the code that is not used by that particular run is never converted to native code. If some MSIL code is converted to native code, from the next run onwards the CLR uses the same copy of native code without re-compiling. So if program runs for some time (assuming that all or most of the functions get called), then it won't have just-in-time performance penalty.

Since JITers are aware of the specific processor and OS at runtime, they can optimize code extremely efficiently resulting in very robust applications.

MSIL (Microsoft Intermediate Language) Code

2009-07-11T23:47:00.001-07:00

When we compile our .NET program using the corresponding Language compiler, source code does not get converted into the executable binary (OS native) code, but to an intermediate code known as MSIL, which is interpreted by the Common Language Runtime. MSIL is operating system and hardware independent code. CLR uses the JIT (Just In Time) compiler to convert MSIL into OS understandable code. MSIL code is similar for any .NET language.

Common Language Runtime

2009-07-11T23:27:00.000-07:00

The Most Important concept of .NET Framework is the existance and fucntionality of the Common Language Runtime (CLR), also called as .NET Runtime. It is a framework layer that resides between Operating System and our .NET applications, It handles the execution of all the .NET applications. All our programs do not directly communnicate with OS but go through the CLR.

What is CAML

2009-06-25T01:36:00.000-07:00

CAML (Collaborative Application Markup Language) is an XML based markup language used with the family of Microsoft SharePoint technologies (Windows Sharepoint Services and Office SharePoint Server). Unlike plain XML, CAML contains specific groups of tags to both define and display (render) data.

How to download YouTube Videos

2009-02-25T00:33:00.000-08:00

Hi Friends,

Downloading YouTube videos is very very easy, just involves changing the YouTube url, that's it.

Check the video on "Work With SharePoint site columns"

http://www.youtube.com/watch?v=WjUF3TuBVfo&feature=PlayList&p=55FB32C1841F455A&index=0&playnext=1

Now if you want to download this video just replace youtube -> voobys

so now the link will be displayed as

http://www.voobys.com/watch?v=WjUF3TuBVfo&feature=PlayList&p=55FB32C1841F455A&index=0&playnext=1

Now click on this latest link and download the video.

What’s New in SharePoint 2007?

2009-02-09T21:07:00.001-08:00

What’s New in SharePoint 2007?

Microsoft divides the capacities of SharePoint Server 2007 into six general areas:

1. Business intelligence
2. Business process and forms
3. Collaboration
4. Enterprise content management
5. Enterprise search
6. Portals

Each area contains updated or completely new features available in MOSS 2007.

Sharepoint Certification and Courses

2009-02-09T20:54:00.000-08:00

Dear Friends,

Certifications on MOSS and WSS.

MOSS: Microsoft Office SharePoint Server

In MOSS we have MOSS Administration and MOSS Application development

MCTS: Microsoft Office SharePoint Server 2007 – Configuration

MCTS: Microsoft Office SharePoint Server 2007 ― Application Development

WSS: Windows SharePoint Services

In WSS also we have WSS Administration and WSS Application development

MCTS: Microsoft Windows SharePoint Services 3.0 – Application Development

MCTS: Windows SharePoint Services 3.0 – Configuration

Importance of English

2009-02-06T01:44:00.001-08:00

Dear friends

The purpose is to convey the importance of English in our daily lives.

We are all keen about learning or speaking ENGLISH.

We all know that it’s very simple and easy for us to speak and communicate in our native languages, so we need not worry about how to speak English.

But our daily bread revolves around the very usage of ENGLISH as a mode of communication. Our work life demands that we be good at speaking and communicating via English.

Some of the Good Institutes for Learning English are -

1. SRI RAMAKRISHNA MATH

Address: Opp. Indira Park, Domalguda, Hyderabad – 500 029, INDIA.

Phone Number: 040-2763 5545

2. MEDHA

3. DIRECT ENGLISH

4. RUSSELL’S SPOKEN ENGLISH

5. BBC Website

There are many online websites where we can listen and practice English. But the best way is to make sure that we speak English round the clock and nothing else. “Initially, may be we will be speaking incorrect/improper English, but eventually we will end up improving our language skills and this will help us.”