Programming Heaven

Hide css call property during the inspect

2020-09-23T05:39:00.002-07:00

Step 1

Put below script in web page and see

Two Submit Button One Need validate and another no need to validate in HTML 5 Required Attributes

2020-08-22T21:41:00.000-07:00

Step 1

Put "formnovalidate=false" in no validate button and check

Disable .asmx file direct browse

2020-01-14T20:56:00.001-08:00

1) Add below configuration in web.config file

<system.web>
<webServices>
<wsdlHelpGenerator href="Deny.aspx"></wsdlHelpGenerator> // You need to create this page (simple aspx/htm to show to users)
</webServices>
</system.web>

OR

2)
<system.web>
<webServices>
<protocols>
<remove name="HttpPost" />
<remove name="HttpGet" />
<remove name="Documentation"/>
</protocols>
</webServices>
</system.web>

Delete All Object in SQL Server Database Query

2016-05-26T22:33:00.004-07:00

DECLARE @name VARCHAR(128)
DECLARE @SQL VARCHAR(254)

SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'P' AND category = 0 ORDER BY [name])

WHILE @name is not null
BEGIN
SELECT @SQL = 'DROP PROCEDURE [dbo].[' + RTRIM(@name) +']'
EXEC (@SQL)
PRINT 'Dropped Procedure: ' + @name
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'P' AND category = 0 AND [name] > @name ORDER BY [name])
END
GO

/* Drop all views */
DECLARE @name VARCHAR(128)
DECLARE @SQL VARCHAR(254)

SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'V' AND category = 0 ORDER BY [name])

WHILE @name IS NOT NULL
BEGIN
SELECT @SQL = 'DROP VIEW [dbo].[' + RTRIM(@name) +']'
EXEC (@SQL)
PRINT 'Dropped View: ' + @name
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'V' AND category = 0 AND [name] > @name ORDER BY [name])
END
GO

/* Drop all functions */
DECLARE @name VARCHAR(128)
DECLARE @SQL VARCHAR(254)

SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] IN (N'FN', N'IF', N'TF', N'FS', N'FT') AND category = 0 ORDER BY [name])

WHILE @name IS NOT NULL
BEGIN
SELECT @SQL = 'DROP FUNCTION [dbo].[' + RTRIM(@name) +']'
EXEC (@SQL)
PRINT 'Dropped Function: ' + @name
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] IN (N'FN', N'IF', N'TF', N'FS', N'FT') AND category = 0 AND [name] > @name ORDER BY [name])
END
GO

/* Drop all Foreign Key constraints */
DECLARE @name VARCHAR(128)
DECLARE @constraint VARCHAR(254)
DECLARE @SQL VARCHAR(254)

SELECT @name = (SELECT TOP 1 TABLE_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'FOREIGN KEY' ORDER BY TABLE_NAME)

WHILE @name is not null
BEGIN
SELECT @constraint = (SELECT TOP 1 CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'FOREIGN KEY' AND TABLE_NAME = @name ORDER BY CONSTRAINT_NAME)
WHILE @constraint IS NOT NULL
BEGIN
SELECT @SQL = 'ALTER TABLE [dbo].[' + RTRIM(@name) +'] DROP CONSTRAINT [' + RTRIM(@constraint) +']'
EXEC (@SQL)
PRINT 'Dropped FK Constraint: ' + @constraint + ' on ' + @name
SELECT @constraint = (SELECT TOP 1 CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'FOREIGN KEY' AND CONSTRAINT_NAME <> @constraint AND TABLE_NAME = @name ORDER BY CONSTRAINT_NAME)
END
SELECT @name = (SELECT TOP 1 TABLE_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'FOREIGN KEY' ORDER BY TABLE_NAME)
END
GO

/* Drop all Primary Key constraints */
DECLARE @name VARCHAR(128)
DECLARE @constraint VARCHAR(254)
DECLARE @SQL VARCHAR(254)

SELECT @name = (SELECT TOP 1 TABLE_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'PRIMARY KEY' ORDER BY TABLE_NAME)

WHILE @name IS NOT NULL
BEGIN
SELECT @constraint = (SELECT TOP 1 CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'PRIMARY KEY' AND TABLE_NAME = @name ORDER BY CONSTRAINT_NAME)
WHILE @constraint is not null
BEGIN
SELECT @SQL = 'ALTER TABLE [dbo].[' + RTRIM(@name) +'] DROP CONSTRAINT [' + RTRIM(@constraint)+']'
EXEC (@SQL)
PRINT 'Dropped PK Constraint: ' + @constraint + ' on ' + @name
SELECT @constraint = (SELECT TOP 1 CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'PRIMARY KEY' AND CONSTRAINT_NAME <> @constraint AND TABLE_NAME = @name ORDER BY CONSTRAINT_NAME)
END
SELECT @name = (SELECT TOP 1 TABLE_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'PRIMARY KEY' ORDER BY TABLE_NAME)
END
GO

/* Drop all tables */
DECLARE @name VARCHAR(128)
DECLARE @SQL VARCHAR(254)

SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'U' AND category = 0 ORDER BY [name])

WHILE @name IS NOT NULL
BEGIN
SELECT @SQL = 'DROP TABLE [dbo].[' + RTRIM(@name) +']'
EXEC (@SQL)
PRINT 'Dropped Table: ' + @name
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'U' AND category = 0 AND [name] > @name ORDER BY [name])
END

How to enable developer ULS log dashboard in sharepoint

2016-04-28T06:21:00.000-07:00

Step 1 : Execute below command in powershell
stsadm -o setproperty -pn developer-dashboard -pv on

Step 2: Follow the process as per below snapshot

Start Stop SharePoint timer Service using command line

2016-02-06T00:48:00.000-08:00

net stop SPTimerv4

To start timer service

net start SPTimerv4

To stop SharePoint Administration service:

net stop SPAdminV4

To start SharePoint Administration service

net start SPAdminV4

Use of SPMetal.exe in SharePoint

2014-12-19T02:38:00.000-08:00

SPMetal.exe

Using the tool called SPMetal, we generate our entity-classes that are needed to perform these object oriented queries toward our SharePoint server

Command for Generate entity class
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN>spmetal.exe /web:http://sharepointsite /code:c:\classname.css

SharePoint 2010 Book Direct Download link

2014-09-15T21:20:00.001-07:00

http://5.9.78.50/cgi-bin/dl.cgi/pvb7677ynmxew3jkjlc6axrxyx5mkmwwlfyeaei4yq/Wrox.Beginning.SharePoint.2010.Development.May.2010.rar

Create Auto Increment ID in Table with data

2013-03-05T02:28:00.003-08:00

Step 1

Create new Column as ID in Table with data type INT.

Step 2
Update table with below query .

;WITH cte AS
(
SELECT *, RowNum = ROW_NUMBER() OVER (ORDER BY GETDATE())
FROM TableName
)
UPDATE cte
SET ID = RowNum + 1
WHERE (RowNum = RowNum)

Step 3

Modify the ID column Identity (1,1)

Find Days of Month In Teradata

2012-12-31T23:55:00.004-08:00

Find Days of Month In Teradata

select extract(month from current_date) as monthofyear,
CASE extract(year from current_date) MOD 5
WHEN 0 THEN
CASE monthofyear
WHEN 1 THEN 31
WHEN 2 THEN 29
WHEN 3 THEN 31
WHEN 4 THEN 30
WHEN 5 THEN 31
WHEN 6 THEN 30
WHEN 7 THEN 31
WHEN 8 THEN 31
WHEN 9 THEN 30
WHEN 10 THEN 31
WHEN 11 THEN 30
WHEN 12 THEN 31
END
ELSE
CASE monthofyear
WHEN 1 THEN 31
WHEN 2 THEN 28
WHEN 3 THEN 31
WHEN 4 THEN 30
WHEN 5 THEN 31
WHEN 6 THEN 30
WHEN 7 THEN 31
WHEN 8 THEN 31
WHEN 9 THEN 30
WHEN 10 THEN 31
WHEN 11 THEN 30
WHEN 12 THEN 31
END
END

Using Facebook login in ASP.NET application

2012-09-25T02:13:00.000-07:00

Using Facebook login in ASP.NET application

Step-1: Register site in Facebook:

Open http://developers.facebook.com and login with your Facebook credentials after logging in you will get a screen like this:

Click on "Build for Websites" link, you will reach to https://developers.facebook.com/docs/guides/web/ , just click on 'Apps' menu Items (the last menu Item from right side), you will reach to https://developers.facebook.com/apps. Click on button, you will get following screen.

Enter the name of your website in place of App Name, rest of the fields are optional so fill them if you require to use them and click on 'Continue' button. you will be asked to fill a captcha screen and then you will get the summary screen like below screenshot (Just masked the AppID).
Give the URL of you website/ application Site URL text box of the app summery screen, like below screenshot. I have given localhost address as I will be testing the app from my local build, you will have to give your website URL in this.

Step-2: Create ASP.NET application using Facebook login:

Open Visual Studio.
Select File --> New --> Project/Solution --> 'ASP.NET Empty Application'
Now Right Click on Project Name Select Add--> New Item from the pop-up menu and click on 'Web Form' to add Default.Aspx page. (See screenshot).
Most of the code we will be doing on the HTML code of ASP.NET Page.

For using Facebook login, we will have to use Facebook JavaScript SDK. There are three ways of using it:

Load the JavaScript SDK asynchronously.<script>

          // Load the SDK Asynchronously
          (function (d) {
              var js, id = 'facebook-jssdk', ref = d.getElementsByTagName('script')[0];
              if (d.getElementById(id)) { return; }
              js = d.createElement('script'); js.id = id; js.async = true;
              js.src = "//connect.facebook.net/en_US/all.js#xfbml=1";
              ref.parentNode.insertBefore(js, ref);
          } (document));
      </script>

Load the JavaScript SDK synchronously <script src=https://connect.facebook.net/en_US/all.js type="text/javascript"></script>
Download the SDK JavaScript file in your local project folder and use it from there. Implemented in 'Default.aspx' of solution.<script src="scripts/all.js" type="text/javascript"></script>

We will also require jquery for initializing the library. so copy following code in header section of the page.<script

src="scripts/jquery-1.8.0.min.js"
type="text/javascript"></script> <script
src="scripts/all.js"
type="text/javascript"></script> 7) Now to initialize the Facebook SDK copy following code in a new script section :
         $("document").ready(function () {
            // Initialize the SDK upon load
            FB.init({
                appId: 'YOUR_APP_ID', // App ID
                channelUrl: '//' + window.location.hostname + '/channel', // Path to your Channel File
                scope: 'id,name,gender,user_birthday,email', // This to get the user details back from Facebook
                status: true, // check login status
                cookie: true, // enable cookies to allow the server to access the session
                xfbml: true  // parse XFBML
            });
            // listen for and handle auth.statusChange events
            FB.Event.subscribe('auth.statusChange', OnLogin);
        });

Here YOUR_APP_ID will be the App Id you will get from the Facebook App.

Also copy the following code after Above code in to get the response back and fill the values. // This method will be called after the user login into faceboookfunction OnLogin(response) {

            if (response.authResponse) {
                FB.api('/me?fields=id,name,gender,email,birthday', LoadValues);                    
            }
        }

        //This method will load the values to the labels
        function LoadValues (me) {
            if (me.name) {
                document.getElementById('displayname').innerHTML = me.name;
                document.getElementById('FBId').innerHTML = me.id;
                document.getElementById('DisplayEmail').innerHTML = me.email;
                document.getElementById('Gender').innerHTML = me.gender;
                document.getElementById('DOB').innerHTML = me.birthday;
                document.getElementById('auth-loggedin').style.display = 'block';
                            }
        }

Copy following code in the Body tag of the Page. <div id="fb-root"></div>

    <div class="fb-login-button" autologoutlink="true" scope="user_birthday,email" >
      Login with Facebook
     </div> <!-- FB Login Button -->   
    <!-- Details --> 
    <div id="auth-status">    
    <div id="auth-loggedin" style="display: none">
        Hi, <span id="displayname"></span><br/>
        Your Facebook ID : <span id="FBId"></span><br/>
        Your Email : <span id="DisplayEmail"></span><br/>
        Your Sex:, <span id="Gender"></span><br/>
        Your Date of Birth :, <span id="DOB"></span><br/>        
    </div>
    </div>

Your application is ready now, execute the application.

Convert Unix Time Stamp To System Date Time

2012-09-24T00:00:00.001-07:00

Convert Unix Time Stamp To System Date Time

Step 1

Copy the function code below and paste in your page.

public string ConvertToUnixTimeStapToDateTime(double timestamp)
{

// First make a System.DateTime equivalent to the UNIX Epoch.
System.DateTime dateTime = new System.DateTime(1970, 1, 1, 0, 0, 0, 0);

// Add the number of seconds in UNIX timestamp to be converted.
dateTime = dateTime.AddSeconds(timestamp);

// The dateTime now contains the right date/time so to format the string,
// use the standard formatting methods of the DateTime object.
string resDate = dateTime.ToShortDateString() + " " + dateTime.ToShortTimeString();

return resDate;

}

Step 2

Call the function and pass the time span value.

Label1.Text=ConvertToUnixTimeStapToDateTime(128988834);

Happy Programming....With Programming Heaven

Download Pre-Request patch file for SharePoint 2010 Installation

2012-09-17T03:28:00.003-07:00

Download Pre-Request patch file for SharePoint 2010 Installation

Pre-Request patch file download for SharePoint 2010 Software.

Click on below link for download pre request file...

1.SQL Native Client

2.Hotfix for Microsoft Windows (KB976462) – NET 3.5 SP1 HotFix or Windows 2008 R2

3.Windows Identity Foundation (KB974405) for Windows 2008 R2

4.Microsoft Sync Framework Runtime v1.0 (x64)

5.Microsoft Chart Controls for Microsoft .NET Framework 3.5

6.Microsoft Filter Pack 2.0

7.Microsoft SQL Server 2008 Analysis Services ADOMD.NET

9.Microsoft Server Speech Recognition Language - TELE(en-US)

10.SQL 2008 R2 Reporting Services SharePoint 2010 Add-in

Convert HtmlToPDF in ASP.net & iTextshrap

2012-09-12T04:57:00.001-07:00

Convert Web Page to PDF in ASP.net & iTextshrap

Step 1

Download iTextSharp dll from below link's

Download iTextSharp dll
iTextsharp_Dll Download

Step 2

Create a sample website in .net . Add reference the downloaded dll .

Step 3

Create a page and design you report in this web page and put one button for Export to pdf .

Step 4

C#

Add namespaces below .

using System.IO;
using iTextSharp.text;
using iTextSharp.text.html.simpleparser;
using iTextSharp.text.pdf;
using System.Text;

Copy and Paste below code in Export Button click event .

Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;filename=TestPage.pdf");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
this.Page.RenderControl(hw);
StringReader sr = new StringReader(sw.ToString());
Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 100f, 0f);
HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
pdfDoc.Open();
htmlparser.Parse(sr);
pdfDoc.Close();
Response.Write(pdfDoc);
Response.End();

VB

Add namespaces below .

Imports System.IO
Imports iTextSharp.text
Imports iTextSharp.text.html.simpleparser
Imports iTextSharp.text.pdf

Copy and Paste below code in Export Button click event .

Response.ContentType = "application/pdf"

Response.AddHeader("content-disposition", "attachment;filename=TestPage.pdf")

Response.Cache.SetCacheability(HttpCacheability.NoCache)

Dim sw As New StringWriter()

Dim hw As New HtmlTextWriter(sw)

Me.Page.RenderControl(hw)

Dim sr As New StringReader(sw.ToString())

Dim pdfDoc As New Document(PageSize.A4, 10.0F, 10.0F, 100.0F, 0.0F)

Dim htmlparser As New HTMLWorker(pdfDoc)

PdfWriter.GetInstance(pdfDoc, Response.OutputStream)

pdfDoc.Open()

htmlparser.Parse(sr)

pdfDoc.Close()

Response.Write(pdfDoc)

Response.[End]()

Step 5

Run your website and click on Export Button and enjoy....

Stock Quote and Chart with yahoo using c#

2012-09-05T02:12:00.002-07:00

Stock Quote and Chart with yahoo using c#

Step 1

Create a website with visual studio and copy the below code paste in your page code behind .

Code

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
// The page is being loaded and accessed for the first time.
// Retrieve user input from the form.
if (Request.QueryString["s"] == null)
// Set the default stock symbol to YHOO.
m_symbol = "STER.NS";
else
// Get the user's input.
m_symbol = Request.QueryString["s"].ToString().ToUpper();
// Update the textbox value.
txtSymbol.Value = m_symbol;
// This DIV that contains text and DIVs that displays stock quotes and chart from Yahoo.
// Set the innerHTML property to replaces the existing content of the DIV.
divService.InnerHtml = "<br />";
if (m_symbol.Trim() != "")
{
try
{
// Return the stock quote data in XML format.
String arg = GetQuote(m_symbol.Trim());
if (arg == null)
return;

// Read XML.
// Declare an XmlDocument object to represents an XML document.
XmlDocument xd = new XmlDocument();
// Loads the XML data from a stream.
xd.LoadXml(arg);

// Read XSLT
// Declare an XslCompiledTransform object to transform XML data using an XSLT style sheet.
XslCompiledTransform xslt = new XslCompiledTransform();
// Use the Load method to load the Xsl transform object.
xslt.Load(Server.MapPath("stock.xsl"));

// Transform the XML document into HTML.
StringWriter fs = new StringWriter();
xslt.Transform(xd.CreateNavigator(), null, fs);
string result = fs.ToString();

// Replace the characters ">" and "<" back to "<" and ">".
divService.InnerHtml = "<br />" + result.Replace("<", "<").Replace(">", ">") + "<br />";

// Display stock charts.
String[] symbols = m_symbol.Replace(",", " ").Split(' ');
// Loop through each stock
for (int i = 0; i < symbols.Length; ++i)
{
if (symbols[i].Trim() == "")
continue;
int index = divService.InnerHtml.ToLower().IndexOf(symbols[i].Trim().ToLower() + " is invalid.");
// If index = -1, the stock symbol is valid.
if (index == -1)
{
// Use a random number to defeat cache.
Random random = new Random();
divService.InnerHtml += "<img id='imgChart_" + i.ToString() + "' src='http://ichart.finance.yahoo.com/b?s=" + symbols[i].Trim().ToUpper() + "& " + random.Next() + "' border=0><br />";
// 1 days
divService.InnerHtml += "<a style='font-family: Arial, Helvetica, sans-serif; font-size: 14px; color: Blue;' href='javascript:changeChart(0," + i.ToString() + ", \"" + symbols[i].ToLower() + "\");'><span id='div1d_" + i.ToString() + "'><b>1d</b></span></a>  ";
// 5 days
divService.InnerHtml += "<a style='font-family: Arial, Helvetica, sans-serif; font-size: 14px; color: Blue;' href='javascript:changeChart(1," + i.ToString() + ", \"" + symbols[i].ToLower() + "\");'><span id='div5d_" + i.ToString() + "'>5d</span></a>  ";
// 3 months
divService.InnerHtml += "<a style='font-family: Arial, Helvetica, sans-serif; font-size: 14px; color: Blue;' href='javascript:changeChart(2," + i.ToString() + ", \"" + symbols[i].ToLower() + "\");'><span id='div3m_" + i.ToString() + "'>3m</span></a>  ";
// 6 months
divService.InnerHtml += "<a style='font-family: Arial, Helvetica, sans-serif; font-size: 14px; color: Blue;' href='javascript:changeChart(3," + i.ToString() + ", \"" + symbols[i].ToLower() + "\");'><span id='div6m_" + i.ToString() + "'>6m</span></a>  ";
// 1 yeas
divService.InnerHtml += "<a style='font-family: Arial, Helvetica, sans-serif; font-size: 14px; color: Blue;' href='javascript:changeChart(4," + i.ToString() + ", \"" + symbols[i].ToLower() + "\");'><span id='div1y_" + i.ToString() + "'>1y</span></a>  ";
// 2 years
divService.InnerHtml += "<a style='font-family: Arial, Helvetica, sans-serif; font-size: 14px; color: Blue;' href='javascript:changeChart(5," + i.ToString() + ", \"" + symbols[i].ToLower() + "\");'><span id='div2y_" + i.ToString() + "'>2y</span></a>  ";
// 5 years
divService.InnerHtml += "<a style='font-family: Arial, Helvetica, sans-serif; font-size: 14px; color: Blue;' href='javascript:changeChart(6," + i.ToString() + ", \"" + symbols[i].ToLower() + "\");'><span id='div5y_" + i.ToString() + "'>5y</span></a>  ";
// Max
divService.InnerHtml += "<a style='font-family: Arial, Helvetica, sans-serif; font-size: 14px; color: Blue;' href='javascript:changeChart(7," + i.ToString() + ", \"" + symbols[i].ToLower() + "\");'><span id='divMax_" + i.ToString() + "'>Max</span></a><br><br /><br />  ";
}
}
}
catch
{
// Handle exceptions
}
}
}
}

/// <summary>
/// This function handles and parses multiple stock symbols as input parameters
/// and builds a valid XML return document.
/// </summary>
/// <param name="symbol">A bunch of stock symbols seperated by space or comma</param>
/// <returns>Return stock quote data in XML format</returns>
public string GetQuote(string symbol)
{
// Set the return string to null.
string result = null;
try
{
// Use Yahoo finance service to download stock data from Yahoo
string yahooURL = @"http://download.finance.yahoo.com/d/quotes.csv?s=" + symbol + "&f=sl1d1t1c1hgvbap2";
string[] symbols = symbol.Replace(",", " ").Split(' ');

// Initialize a new WebRequest.
HttpWebRequest webreq = (HttpWebRequest)WebRequest.Create(yahooURL);
// Get the response from the Internet resource.
HttpWebResponse webresp = (HttpWebResponse)webreq.GetResponse();
// Read the body of the response from the server.
StreamReader strm = new StreamReader(webresp.GetResponseStream(), Encoding.ASCII);

// Construct a XML in string format.
string tmp = "<StockQuotes>";
string content = "";
for (int i = 0; i < symbols.Length; i++)
{
// Loop through each line from the stream, building the return XML Document string
if (symbols[i].Trim() == "")
continue;

content = strm.ReadLine().Replace("\"", "");
string[] contents = content.ToString().Split(',');
// If contents[2] = "N/A". the stock symbol is invalid.
if (contents[2] == "N/A")
{
// Construct XML via strings.
tmp += "<Stock>";
// "<" and ">" are illegal in XML elements. Replace the characters "<" and ">" to ">" and "<".
tmp += "<Symbol><span style='color:red'>" + symbols[i].ToUpper() + " is invalid.</span></Symbol>";
tmp += "<Last></Last>";
tmp += "<Date></Date>";
tmp += "<Time></Time>";
tmp += "<Change></Change>";
tmp += "<High></High>";
tmp += "<Low></Low>";
tmp += "<Volume></Volume>";
tmp += "<Bid></Bid>";
tmp += "<Ask></Ask>";
tmp += "<Ask></Ask>";
tmp += "</Stock>";
}
else
{
//construct XML via strings.
tmp += "<Stock>";
tmp += "<Symbol>" + contents[0] + "</Symbol>";
try
{
tmp += "<Last>" + String.Format("{0:c}", Convert.ToDouble(contents[1])) + "</Last>";
}
catch
{
tmp += "<Last>" + contents[1] + "</Last>";
}
tmp += "<Date>" + contents[2] + "</Date>";
tmp += "<Time>" + contents[3] + "</Time>";
// "<" and ">" are illegal in XML elements. Replace the characters "<" and ">" to ">" and "<".
if (contents[4].Trim().Substring(0, 1) == "-")
tmp += "<Change><span style='color:red'>" + contents[4] + "(" + contents[10] + ")" + "<span></Change>";
else if (contents[4].Trim().Substring(0, 1) == "+")
tmp += "<Change><span style='color:green'>" + contents[4] + "(" + contents[10] + ")" + "<span></Change>";
else
tmp += "<Change>" + contents[4] + "(" + contents[10] + ")" + "</Change>";
tmp += "<High>" + contents[5] + "</High>";
tmp += "<Low>" + contents[6] + "</Low>";
try
{
tmp += "<Volume>" + String.Format("{0:0,0}", Convert.ToInt64(contents[7])) + "</Volume>";
}
catch
{
tmp += "<Volume>" + contents[7] + "</Volume>";
}
tmp += "<Bid>" + contents[8] + "</Bid>";
tmp += "<Ask>" + contents[9] + "</Ask>";
tmp += "</Stock>";
}
// Set the return string
result += tmp;
tmp = "";
}
// Set the return string
result += "</StockQuotes>";
// Close the StreamReader object.
strm.Close();
}
catch
{
// Handle exceptions.
}
// Return the stock quote data in XML format.
return result;
}

Step 2

Run your site and search your quote .

If you have any problem so you can download the sample application from below link ..

http://www.4shared.com/rar/G3mhqeb7/StockQuote.html

If it help full for you please share to your friend..

Thanks
Smruti

Search Linked In People In your web application using linked in Javascript API

2012-09-01T00:44:00.000-07:00

Search Linked In People In your web application using linked in Javascript API

Step 1

Go to this below URL

https://www.linkedin.com/secure/developer?newapp=

Step 2

Add your apps for generate API key .See Figure 1

Figure 1

Step 3

Fill up all required information as per your requirement .See Figure 2

Figure 2

Then click on Add Application Button for generate API Key .See Figure 3

Figure 3

Step 4

Copy the Below Code and paste in your application page .

api_key: YOUR_API_KEY

</script>

function searchClick() {

if (!IN.ENV.auth.oauth_token) {

alert("You must login w/ LinkedIn to use the Search functionality!");

return;

}

IN.API.PeopleSearch()

.fields("id", "firstName", "lastName")

.params({

"first-name": document.searchform.firstName.value,

"last-name": document.searchform.lastName.value,

"company": document.searchform.company.value

})

.result(function(result, metadata) {

setSearchResults(result, metadata);

});

}

function setSearchResults(result, metadata) {

searchHTML = "Search Results (" + result.numResults + "):<ul>";

console.log(result.people.values);

for (i in result.people.values) {

searchHTML = searchHTML + "<li>";

searchHTML = searchHTML + result.people.values[i].firstName + " ";

searchHTML = searchHTML + result.people.values[i].lastName + " ";

searchHTML = searchHTML + " (memberToken: " + result.people.values[i].id + ")</li>";

}

searchHTML = searchHTML + "</ul>";

document.getElementById("searchresults").innerHTML = searchHTML;

}

</script>

<p>Basic test of the People Search API via Connect. <br />

You must click the button (pressing Enter doesn't work).</p>

First Name: <input type="text" name="firstName"><br/>

Last Name: <input type="text" name="lastName"><br/>

Company: <input type="text" name="company"><br/>

</form>

Step 5

Copy the API Key and Paste in code where it required .

Step 6

Run your application and enjoy it.....

Note :Project should run in your website url which url you have given in Application add time.

If you have any problem please ask me through the comment .

JavaScript Detect Device in ASP.net

2012-08-31T03:42:00.001-07:00

JavaScript Detect Device in ASP.net

Simple put the JavaScript in your default page and see the result in your different browser .

Redirect Mobile Devices

<script type="text/javascript">

</script>
"mobile.html" would be replaced with the location of wherever your mobile version resides. This technique could be adapted to load an alternate stylesheet as well.

For iPhones/iPods Specifically

<script language=javascript>

</script>

Enjoy script....

How to Display Page Wise Total Amount & Grand Total Amount in Last page SSRS & RDLC Report

2012-08-29T22:26:00.000-07:00

How to Display Page Wise Total Amount And Grand Total Amount in Last page SSRS & RDLC Report

Step 1

Go to Project Menu >> Add Page Footer

After click on the Add Footer Menu footer automatically add in the report. See Figure 1

Figure 1

Step 2
Add new TextBox for display page wise total and edit expression of TextBox . See Figure 2

Figure 2

Add this expression for page total TextBox =Sum(ReportItems!TotalAmount.Value)

Step 3

Add new TextBox for display Grand Total in Last Page of RDLC report and edit expression of TextBox . See Figure 3

Figure 3

=IIF( Globals.PageNumber =Globals.TotalPages,Sum(Fields!TotalAmount.Value, "DataSet1"), "")

Step 4

Run the application and test the reports

Thanks
Smruti

Create Job Schedule On Web using ASP.net

2012-08-27T00:50:00.001-07:00

Create Job Schedule On Web using ASP.net

Step 1

Create Global.asax file in your application.

Step 2

Copy below code and paste in Global.asax file .

Code

void Application_Start(object sender, EventArgs e)

{

System.Timers.Timer timScheduledTask = new System.Timers.Timer();

// Timer interval is set in miliseconds,

// In this case, we'll run a task every minute

timScheduledTask.Interval = 60 * 1000;

timScheduledTask.Enabled = true;

// Add handler for Elapsed event

timScheduledTask.Elapsed +=

new System.Timers.ElapsedEventHandler(timScheduledTask_Elapsed);

timScheduledTask.Stop();

timScheduledTask.Start();

}

void timScheduledTask_Elapsed(object sender, System.Timers.ElapsedEventArgs e)

{

// Execute some task

//GoalReminder gr = new GoalReminder();

int howOften = 1;

while (howOften < 5)

{

//do some stuff here that i can't paste

howOften++;

SendMail(howOften.ToString() + " Global Mail");

}

void Application_End(object sender, EventArgs e)

{

// Code that runs on application shutdown

}

void Application_Error(object sender, EventArgs e)

{

// Code that runs when an unhandled error occurs

}

void Session_Start(object sender, EventArgs e)

{

// Code that runs when a new session is started

}

void Session_End(object sender, EventArgs e)

{

// Code that runs when a session ends.

// Note: The Session_End event is raised only when the sessionstate mode

// is set to InProc in the Web.config file. If session mode is set to StateServer

// or SQLServer, the event is not raised.

}

void SendMail(string subject)

{

string username, pwd;

username = "xyz@example.com;

pwd = "abc@1234";

System.Net.Mail.MailMessage greetings = new System.Net.Mail.MailMessage();

System.Net.Mail.SmtpClient smtp = new System.Net.Mail.SmtpClient();

try

{

greetings.From = new System.Net.Mail.MailAddress(username, "Sender Display Name");

greetings.To.Add("abc@gmail.com");

greetings.IsBodyHtml = true;

greetings.Priority = System.Net.Mail.MailPriority.High;

greetings.Body = "Body Text";

greetings.Subject = subject;

smtp.Host = "localhost";

smtp.Port = 25;

smtp.EnableSsl = false;

smtp.DeliveryMethod = System.Net.Mail.SmtpDeliveryMethod.Network;

smtp.UseDefaultCredentials = false;

smtp.Credentials = new System.Net.NetworkCredential(username, pwd);

smtp.Send(greetings);

}

catch (Exception ex)

{

}

</script>

If you want to change your action you can change the code and call inside the timScheduledTask_Elapsed event .

If you have any problem please feel free to comment .

If it helpful for you please share it.

Cogons 10.1 Installation and Configuration

2012-08-26T23:54:00.002-07:00

Cogons 10.1 Installation and Configuration

What is API ?

2012-08-26T22:11:00.003-07:00

What is API ?

Abbreviation of application program interface, a set of routines, protocols, and tools for building software applications. A good API makes it easier to develop a program by providing all the building blocks. A programmer then puts the blocks together.

Most operating environments, such as MS-Windows, provide an API so that programmers can write applications consistent with the operating environment. Although APIs are designed for programmers, they are ultimately good for users because they guarantee that all programs using a common API will have similar interfaces. This makes it easier for users to learn new programs.

Now a day most of organization provide the API for retrieve information from their global database. So social network sites provide the API for retrive friend list,news feed,current activities etc.
Example Facebook API,Tweeter API,Linked in API etc. Other organization also provide their API for retrieve valuable data from the global database. Ex -Google API for MAP,Contact,Translation and many more .So API make easier to develop a Application as per their requirement.

Programming in Objective-C

2012-08-24T22:08:00.000-07:00

Programming in Objective-C

In this chapter, we dive right in and show you how to write your first Objective-C program. You won’t work with objects just yet; that’s the topic of the next
chapter. We want you to understand the steps involved in keying in a program and compiling and running it.
To begin, let’s pick a rather simple example: a program that displays the phrase “Programming is fun!” on your screen. Without further ado, Program 2.1
shows an Objective-C program to accomplish this task.
Program 2.1
// First program example
#import <Foundation/Foundation.h>
int main (int argc, const char * argv[])
{
@autoreleasepool {
NSLog (@"Programming is fun!");
}
return 0;
}
Compiling and Running Programs
Before we go into a detailed explanation of this program, we need to cover the steps involved in compiling and running it. You can both compile and run
your program using Xcode, or you can use the Clang Objective-C compiler in a Terminal window. Let’s go through the sequence of steps using both
methods. Then you can decide how you want to work with your programs throughout the rest of this book.
Note
You’ll want to go to developer.apple.com and make sure you have the latest version of the Xcode development tools. There you can download
Xcode and the iOS SDK at no charge. If you’re not a registered developer, you’ll have to register first. That can also be done at no charge. Note
that Xcode is also available for a minimal cost from the Mac App Store.
Using Xcode
Xcode is a sophisticated application that enables you to easily type in, compile, debug, and execute programs. If you plan on doing serious application
development on the Mac, learning how to use this powerful tool is worthwhile. We just get you started here. Later we return to Xcode and take you through
the steps involved in developing a graphical application with it.
Note
As mentioned, Xcode is a sophisticated tool, and the introduction of Xcode 4 added even more features. It’s easy to get lost using this tool. If
that happens to you, back up a little and try reading the Xcode User Guide, which can be accessed from Xcode help menu, to get your bearings.
Xcode is located in the Developer folder inside a subfolder called Applications. Figure 2.1 shows its icon.
Figure 2.1. Xcode icon

2.1 Xcode

Introduction to IBM Cognos Business Intelligence

2012-08-24T21:57:00.002-07:00

Introduction to IBM Cognos Business Intelligence

Organizations are pressured constantly to understand and react quickly toinformation. With a capable and efficient business intelligence solution, all levelsof an organization can receive information how, when, and where they need it tomake faster and better aligned decisions.Many organizations often satisfy this complexity and these diverse demands witha number of point solutions. With IBM Cognos Business Intelligence (BI)solutions, you can satisfy needs throughout the user community and ensure that everyone can work and collaborate from a consistent set of data. In addition, IT is simplified with fewer components to deploy, manage, and maintain. In this chapter, we introduce IBM Business Analytics and IBM Cognos BI and discuss the following topics:

IBM Business Analytics
Introduction to IBM Cognos BI

1.1 IBM Business Analytics

IBM Business Analytics includes the following products:
IBM Cognos BI
IBM Financial Performance and Strategy Management

IBM Cognos TM1
IBM Cognos Planning
IBM Cognos Controller
IBM Cognos Business ViewPoint

IBM Analytics Applications
IBM Advanced Analytics (SPSS)
IBM Cognos Express

1.2 Introduction to IBM Cognos BI

IBM Cognos BI provides a unified workspace for business intelligence and analytics that the entire organization can use to answer key business questions and outperform the competition. With IBM Cognos BI, users can:
Easily view, assemble and personalize information
Explore all types of information from all angles to assess the current business situation
Analyze facts and anticipate tactical and strategic implications by simply shifting from viewing to more advanced, predictive or what-if analysis
Collaborate to establish decision networks to share insights and drive toward a collective intelligence
Provide transparency and accountability to drive alignment and consensus
Communicate and coordinate tasks to engage the right people at the right time
Access information and take action anywhere, taking advantage of mobile devices and real-time analytics
Integrate and link analytics in everyday work to business workflow and process
Organizations need to make the most of a workforce that is increasingly driven to multi-task, network and collaborate.
IBM Cognos BI delivers analytics everyone can use to answer key business questions.

1.2.1 Easily view, assemble, and personalize information

Often, business users do not know how to get to the information that they need, and available tools might not provide the freedom to combine and explore information in the way they want. IBM Cognos BI features allow business users to easily view, assemble, and personalize information to follow a train of thought
and to generate a unique perspective.Using a single place to quickly see a view of their business, users can personalize content, build on the insights of others, and incorporate data from a variety of sources. These capabilities ensure that more people are engaged in providing unique insights and delivering faster business decisions. Giving business users greater self-service control reduces demands on IT and business intelligence systems.

1.2.2 Explore all types of information

If a separate tool is required, it is difficult to incorporate statistical results with core business reporting. IBM Cognos BI allows business users to consume fact-based statistical evidence to support key decisions directly in the IBM Cognos BI environment. The ability to explore all types of information from all angles to assess the current business situation provides a deeper understanding of the patterns that exist in data. These functions allow business users to deliver reports that include statistical insight and validation and to distribute these reports to the larger business community.

1.2.3 Analyze facts and anticipate tactical and strategic implications

Business users need tools that let them accurately evaluate and identify the impact that different scenarios will have on the business and on the bottom line. IBM Cognos BI allows the business user to analyze facts and anticipate strategic implications by simply shifting from viewing data to performing more advanced predictive or what-if analysis. Understanding the scenarios that affect business enables the business user to make informed recommendations to the business and provides an increased competitive advantage.

1.2.4 IBM Cognos BI user interfaces

IBM Cognos BI includes web-based and Windows®-based user interfaces that
provide a business intelligence experience that is focused upon the needs of
different users.

IBM Cognos Business Insight

With IBM Cognos Business Insight, you can create sophisticated interactive dashboards using IBM Cognos content, as well as external data sources such as TM1 Websheets and CubeViews, according to your specific information needs. You can view and open favorite dashboards and reports, manipulate the content in the dashboards, and email your dashboards. You can also use comments and activities for collaborative decision making and use social software such as IBM Lotus® Connections for collaborative decision making.

For more information about using IBM Cognos Business Insight, see the IBM
Cognos Business Insight User Guide.

IBM Cognos Report Studio

IBM Cognos Report Studio is a robust report design and authoring tool. Using IBM Cognos Report Studio, report authors can create, edit, and distribute a wide range of professional reports. They can also define corporate-standard report templates for use in IBM Cognos Query Studio and edit and modify reports created in IBM Cognos Query Studio or IBM Cognos Analysis Studio. This book does not cover use of IBM Cognos Report Studio, given the depth of features that IBM Cognos Report Studio provides. For information about using IBM Cognos Report Studio, refer to IBM Cognos Report Studio User Guide or the online Quick Tour.

IBM Cognos Query Studio

Using IBM Cognos Query Studio, users with little or no training can quickly design, create, and save reports to meet reporting needs that are not covered by the standard, professional reports created in IBM Cognos Report Studio. For information about using IBM Cognos Query Studio, see the IBM Cognos Query Studio User Guide or the online Quick Tour.

IBM Cognos Analysis Studio

With IBM Cognos Analysis Studio, users can explore and analyze data from different dimensions of their business. Users can also compare data to spot trends or anomalies in performance. IBM Cognos Analysis Studio provides access to dimensional, online analytical processing (OLAP), and dimensionally modeled relational data sources. Analyses created in IBM Cognos Analysis Studio can be opened in IBM Cognos Report Studio and used to build professional reports. For information about using IBM Cognos Analysis Studio, see the IBM Cognos Analysis Studio User Guide or the online Quick Tour.

IBM Cognos Event Studio

In IBM Cognos Event Studio, you set up agents to monitor your data and perform tasks when business events or exceptional conditions occur in your data. When an event occurs, people are alerted to take action. Agents can publish details to the portal, deliver alerts by email, run and distribute reports based on events, and monitor the status of events. For example, a support call from a key customer or the cancellation of a large order might trigger an event, sending an email to the appropriate people. For information about using IBM Cognos Event Studio, see the IBM Cognos Event Studio User Guide or the online Quick Tour.

IBM Cognos Metric Studio

In IBM Cognos Metric Studio, you can create and deliver a customized score carding environment for monitoring and analyzing metrics throughout your organization. Users can monitor, analyze, and report on time-critical information by using scorecards based on cross-functional metrics. For information about using IBM Cognos Metric Studio, see the IBM Cognos Metric Studio User Guide for Authors.

IBM Cognos Administration

IBM Cognos Administration is a central management interface that contains the administrative tasks for IBM Cognos BI. It provides easy access to the overall management of the IBM Cognos environment and is accessible through IBM Cognos Connection.For information about using IBM Cognos Administration, see the IBM CognosAdministration and Security Guide.

IBM Cognos Framework Manager

IBM Cognos Framework Manager is the IBM Cognos BI modeling tool forcreating and managing business related metadata for use in IBM Cognos BIanalysis and reporting. Metadata is published for use by reporting tools as apackage, providing a single, integrated business view of any number ofheterogeneous data sources.

OLAP cubes are designed to contain sufficient metadata for business intelligencereporting and analysis. Because cube metadata can change as a cube isdeveloped, IBM Cognos Framework Manager models the minimum amount of information needed to connect to a cube. Cube dimensions, hierarchies, andlevels are loaded at run time.For information about using IBM Cognos Framework Manager, see the IBMCognos Framework Manager User Guide.

Sql Server Database Management.

2012-08-24T01:18:00.001-07:00

Today I am going to give you the tips and tricks on Sql Server Database Management.

This is a common problem for Database developer when they are working on different database servers connected on a single machine.

It is very difficult to identify on which server u r connected or executing on which server.

SSMS (Sql Server Management Studio ) gives gives u the facility to easily identify on which server u r currently working on.

Follow the Simple Steps Below..

Create Pivot Table In C#

2012-08-17T23:38:00.002-07:00

Step 1

Create Class file as Pivot.cs and copy the below text and save in your file .

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;

/// <summary>
/// Pivots the data
/// </summary>
public class Pivot
{
private DataTable _SourceTable = new DataTable();
private IEnumerable<DataRow> _Source = new List<DataRow>();

public Pivot(DataTable SourceTable)
{
_SourceTable = SourceTable;
_Source = SourceTable.Rows.Cast<DataRow>();
}

/// <summary>
/// Pivots the DataTable based on provided RowField, DataField, Aggregate Function and ColumnFields.//
/// </summary>
/// <param name="rowField">The column name of the Source Table which you want to spread into rows</param>
/// <param name="dataField">The column name of the Source Table which you want to spread into Data Part</param>
/// <param name="aggregate">The Aggregate function which you want to apply in case matching data found more than once</param>
/// <param name="columnFields">The List of column names which you want to spread as columns</param>
/// <returns>A DataTable containing the Pivoted Data</returns>
public DataTable PivotData(string rowField, string dataField, AggregateFunction aggregate, params string[] columnFields)
{
DataTable dt = new DataTable();
string Separator = ".";
List<string> rowList = _Source.Select(x => x[rowField].ToString()).Distinct().ToList();
// Gets the list of columns .(dot) separated.
var colList = _Source.Select(x =>(columnFields.Select(n => x[n]).Aggregate((a, b) => a += Separator + b.ToString())).ToString()).Distinct().OrderBy(m => m);

dt.Columns.Add(rowField);
foreach (var colName in colList)
dt.Columns.Add(colName); // Cretes the result columns.//

foreach (string rowName in rowList)
{
DataRow row = dt.NewRow();
row[rowField] = rowName;
foreach (string colName in colList)
{
string strFilter = rowField + " = '" + rowName + "'";
string[] strColValues = colName.Split(Separator.ToCharArray(), StringSplitOptions.None);
for (int i = 0; i < columnFields.Length; i++)
strFilter += " and " + columnFields[i] + " = '" + strColValues[i] + "'";
row[colName] = GetData(strFilter, dataField, aggregate);
}
dt.Rows.Add(row);
}
return dt;
}

public DataTable PivotData(string rowField, string dataField, AggregateFunction aggregate, bool showSubTotal, params string[] columnFields)
{
DataTable dt = new DataTable();
string Separator = ".";
List<string> rowList = _Source.Select(x => x[rowField].ToString()).Distinct().ToList();
// Gets the list of columns .(dot) separated.
List<string> colList = _Source.Select(x => columnFields.Aggregate((a, b) => x[a].ToString() + Separator + x[b].ToString())).Distinct().OrderBy(m => m).ToList();

if (showSubTotal && columnFields.Length > 1)
{
string totalField = string.Empty;
for (int i = 0; i < columnFields.Length - 1; i++)
totalField += columnFields[i] + "(Total)" + Separator;
List<string> totalList = _Source.Select(x => totalField + x[columnFields.Last()].ToString()).Distinct().OrderBy(m => m).ToList();
colList.InsertRange(0, totalList);
}

dt.Columns.Add(rowField);
colList.ForEach(x => dt.Columns.Add(x));

foreach (string rowName in rowList)
{
DataRow row = dt.NewRow();
row[rowField] = rowName;
foreach (string colName in colList)
{
string filter = rowField + " = '" + rowName + "'";
string[] colValues = colName.Split(Separator.ToCharArray(), StringSplitOptions.None);
for (int i = 0; i < columnFields.Length; i++)
if (!colValues[i].Contains("(Total)"))
filter += " and " + columnFields[i] + " = '" + colValues[i] + "'";
row[colName] = GetData(filter, dataField, colName.Contains("(Total)") ? AggregateFunction.Sum : aggregate);
}
dt.Rows.Add(row);
}
return dt;
}

public DataTable PivotData(string DataField, AggregateFunction Aggregate, string[] RowFields, string[] ColumnFields)
{
DataTable dt = new DataTable();
string Separator = ".";
var RowList = _SourceTable.DefaultView.ToTable(true, RowFields).AsEnumerable().ToList();
for (int index = RowFields.Count() - 1; index >= 0; index--)
RowList = RowList.OrderBy(x => x.Field<object>(RowFields[index])).ToList();
// Gets the list of columns .(dot) separated.
var ColList = (from x in _SourceTable.AsEnumerable()
select new
{
Name = ColumnFields.Select(n => x.Field<object>(n))
.Aggregate((a, b) => a += Separator + b.ToString())
})
.Distinct()
.OrderBy(m => m.Name);

//dt.Columns.Add(RowFields);
foreach (string s in RowFields)
dt.Columns.Add(s);

foreach (var col in ColList)
dt.Columns.Add(col.Name.ToString()); // Cretes the result columns.//

foreach (var RowName in RowList)
{
DataRow row = dt.NewRow();
string strFilter = string.Empty;

foreach (string Field in RowFields)
{
row[Field] = RowName[Field];
strFilter += " and " + Field + " = '" + RowName[Field].ToString() + "'";
}
strFilter = strFilter.Substring(5);

foreach (var col in ColList)
{
string filter = strFilter;
string[] strColValues = col.Name.ToString().Split(Separator.ToCharArray(), StringSplitOptions.None);
for (int i = 0; i < ColumnFields.Length; i++)
filter += " and " + ColumnFields[i] + " = '" + strColValues[i] + "'";
row[col.Name.ToString()] = GetData(filter, DataField, Aggregate);
}
dt.Rows.Add(row);
}
return dt;
}

/// <summary>
/// Retrives the data for matching RowField value and ColumnFields values with Aggregate function applied on them.
/// </summary>
/// <param name="Filter">DataTable Filter condition as a string</param>
/// <param name="DataField">The column name which needs to spread out in Data Part of the Pivoted table</param>
/// <param name="Aggregate">Enumeration to determine which function to apply to aggregate the data</param>
/// <returns></returns>
private object GetData(string Filter, string DataField, AggregateFunction Aggregate)
{
try
{
DataRow[] FilteredRows = _SourceTable.Select(Filter);
object[] objList = FilteredRows.Select(x => x.Field<object>(DataField)).ToArray();

switch (Aggregate)
{
case AggregateFunction.Average:
return GetAverage(objList);
case AggregateFunction.Count:
return objList.Count();
case AggregateFunction.Exists:
return (objList.Count() == 0) ? "False" : "True";
case AggregateFunction.First:
return GetFirst(objList);
case AggregateFunction.Last:
return GetLast(objList);
case AggregateFunction.Max:
return GetMax(objList);
case AggregateFunction.Min:
return GetMin(objList);
case AggregateFunction.Sum:
return GetSum(objList);
default:
return null;
}
}
catch (Exception ex)
{
return "#Error" + ex.Message;
}
}

private object GetAverage(object[] objList)
{
return objList.Count() == 0 ? null : (object)(Convert.ToDecimal(GetSum(objList)) / objList.Count());
}
private object GetSum(object[] objList)
{
return objList.Count() == 0 ? null : (object)(objList.Aggregate(new decimal(), (x, y) => x += Convert.ToDecimal(y)));
}
private object GetFirst(object[] objList)
{
return (objList.Count() == 0) ? null : objList.First();
}
private object GetLast(object[] objList)
{
return (objList.Count() == 0) ? null : objList.Last();
}
private object GetMax(object[] objList)
{
return (objList.Count() == 0) ? null : objList.Max();
}
private object GetMin(object[] objList)
{
return (objList.Count() == 0) ? null : objList.Min();
}
}

public enum AggregateFunction
{
Count = 1,
Sum = 2,
First = 3,
Last = 4,
Average = 5,
Max = 6,
Min = 7,
Exists = 8
}

Step 2

Example Pivot View

Call PivotData function in your page like below example.

Pivot pvt = new Pivot(dt);

DataTable pivotTable = new DataTable();

pivotTable = pvt.PivotData("Designation", "Salary", AggregateFunction.Sum, "Year");