Dot Net Twitter

Exporting to Excel from GridView when grid changed by code behind

noreply@blogger.com (Thirumalai M) — Tue, 02 Apr 2013 06:23:35 PDT

This is a small post, which explains how to export to excel from GridView where the GridView has been changed from the code behind by adding/deleting some rows and updated some data. When GridView changed from code behind, the export might not include the updated version done from the code behind. Understanding a sample scenario: Before going for implementation, let us understand the scenario

Group Total and Grand Total in GridView – Part 11

noreply@blogger.com (Thirumalai M) — Mon, 04 Feb 2013 08:08:22 PST

We had seen how to show Group Total in GridView, where the group total will show while starting of the group instead of end of group. This gives functionality such as pivot table in Excel Sheet. In last post, I am posted how to extend the same examples additionally one functionality - expanding and collapsing the groups with corresponding images. In this post, I am planning to post Expand All /

Group Total and Grand Total in GridView – Part 10

noreply@blogger.com (Thirumalai M) — Tue, 29 Jan 2013 02:55:48 PST

I last post we had seen how to show Group Total in GridView, where the group total will show while starting of the group instead of end of group. This gives functionality such as pivot table in Excel Sheet. In this post, I am planning to extend the same examples and add one more functionality such as expanding and collapsing the groups with corresponding images. This provides a way to hide/show

Group Total and Grand Total in GridView – Part 9

noreply@blogger.com (Thirumalai M) — Sat, 26 Jan 2013 19:16:58 PST

We had seen many ways to show Group Total and Grand Total in GridView. In those posts, we had considered the Group Total will show at the end of the group and the Grand Total will show at the last row. But in many other requirements, we may need to show the Group Total when the group is starting (something like what it shown in Excel Pivot Table). So in this post, I am planning to post how to

Group Total and Grand Total in GridView – Part 8

noreply@blogger.com (Thirumalai M) — Sat, 05 Jan 2013 23:17:34 PST

In last post, I had posted a post on Group Total and Grand Total on GridView, which displays records in groups and provides the total of each group at the end of the group. In this post, I am planning to include +, - buttons on each group totals which helps to analyze the records easily. For more understanding, here is the use case of the requirement – The records defined in the XML should bound

Group Total and Grand Total in GridView – Part 7

noreply@blogger.com (Thirumalai M) — Sat, 05 Jan 2013 22:57:11 PST

Group Total and Grand Total in GridView – Part 6

noreply@blogger.com (Thirumalai M) — Sat, 05 Jan 2013 22:14:26 PST

Previously I had posted some posts about Group Total and Grand Total on GridView, which displays records in groups and provides the total of each group at the end of the group. I also posted showing and hiding the groups using +, - buttons which helps to analyze the records easily. But in those posts, I had shown groups in one level which can be extended to multiple groups with little bit

Achieving High Availability with Windows Azure Environment - Part 3

noreply@blogger.com (Thirumalai M) — Sun, 23 Dec 2012 23:04:42 PST

This is third part of Achieving High Availability with Windows Azure Environment series. Look at the end of this post for other parts. Windows Azure SQL Database SQL Azure Database provides 99.9 percent availability by default to the subscribers.When creating a database in SQL Azure server, the database will have three replicas on three different and fully independent physical machines with in

Achieving High Availability with Windows Azure Environment - Part 2

noreply@blogger.com (Thirumalai M) — Mon, 24 Dec 2012 01:50:35 PST

This is second part of Achieving High Availability with Windows Azure Environment series. Look at the end of this post for other parts. Windows Azure Storage Services Windows Azure Storage Services provides 99.9 percent availability by default to the subscribers. There are three types of storage services available with Windows Azure Storage service such as Blob, Tables and Queue. There are

Achieving High Availability with Windows Azure Environment - Part 1

noreply@blogger.com (Thirumalai M) — Mon, 24 Dec 2012 10:05:14 PST

Technology is growing tremendously, the world is becoming more closer day by day. When a started my studies, peoples were using telegram for sending messages in a quick time. But now the mobile technologies becomming powerfull and the new spectrum releases such as 2G, 3G and 4G change the world to make everything possible with internet. Cloud computing is one of them, which make the business to

Creating VPN and Hosting Web application on Azure - Part 4

noreply@blogger.com (Thirumalai M) — Sat, 08 Dec 2012 03:18:09 PST

In last posts, we had created VPN and one Azure VM. We also installed Domain Controller on the Azure VM. In this post, I am planning to create three Azure VMs with SQL Server 2012 Image and configure mirroring. We will use this SQL Server for connecting from the Web Server in future posts. The following Steps for creating first SQL Server 2012 VM under the VPN on Azure. Creating first SQL

Creating VPN and Hosting Web application on Azure - Part 3

noreply@blogger.com (Thirumalai M) — Thu, 06 Dec 2012 02:57:55 PST

In previous post, we had created an Azure VM with Windows Server 2012 operating system under DNSSubnet in the VPN we created at the first post. In this post, I am planning to install active directory, which will be used for configuring SQL Server Mirroring. One thing to note here, there is no prerequisite to have active directory for the web application which we are going to publish on the Web

Creating VPN and Hosting Web application on Azure - Part 2

noreply@blogger.com (Thirumalai M) — Sun, 25 Nov 2012 07:27:20 PST

In last post, we have created VPN on Azure. As we are planning to use Database Mirroring concept in this POC, I need an Active Directory to configure mirroring. So in this post I am planning to create an Azure VM and install DNS and Active Directory. There are three ways we can achieve creating a VM on Azure, using Management Portal, PowerShell script or by using REST API call. In this post, I

Creating VPN and Hosting Web application on Azure - Part 1

noreply@blogger.com (Thirumalai M) — Sat, 24 Nov 2012 07:11:13 PST

In previous post, I had walkthrough about publishing a Web Application on multiple VMs and load balance all of them together. I also created a database server under the same cloud service where the web servers created. In this way, all the servers under a cloud service are connected together and the web application accessing the database server without any VPN connectivity. I also shown to scale

Hosting Web Application using Azure IaaS capabilities - Part 2

noreply@blogger.com (Thirumalai M) — Wed, 21 Nov 2012 04:30:42 PST

This is a series of post explains about Hosting Web Application using Azure IaaS Capabilities. Look at the end of this post for other parts. Creating VM with Windows Server 2012 Image (NorthwindFE) In this section, I am planning to create Azure VM using Windows Server 2012 platform image for installing Web application which will connect the database located another VM (NorthwindBE). Creating

Hosting Web Application using Azure IaaS capabilities - Part 4

noreply@blogger.com (Thirumalai M) — Wed, 21 Nov 2012 04:31:04 PST

This is a series of post explains about Hosting Web Application using Azure IaaS Capabilities. Look at the end of this post for other parts. In previous posts we had completed creating Web Server, Database Server and installed a sample application. We also created image from the Web Server. In this post, I plan to show creating four VMs using custom images created from Web Server and load

Hosting Web Application using Azure IaaS capabilities - Part 3

noreply@blogger.com (Thirumalai M) — Fri, 23 Nov 2012 20:44:36 PST

This is a series of post explains about Hosting Web Application using Azure IaaS Capabilities. Look at the end of this post for other parts. In last two posts, we had created two VMs and hosted Northwind database in Database Server and Web Application on Web Server. The application is now accessible using the SITE URL from anywhere. In this post, I plan to create image of Web Server and create

Hosting Web Application using Azure IaaS capabilities - Part 1

noreply@blogger.com (Thirumalai M) — Wed, 21 Nov 2012 04:27:39 PST

Microsoft released IaaS capabilities with Windows Azure recently which allows us to explore lots of capabilities. For example, Creating VM on Azure as a standalone public machine, Creating VPN/VPC and connect one or more VMs in a network, Connecting on-premise network in a secured tunnel etc., In this post, I am planning to walkthrough the implementation of the following requirement – First

Rendering GridView Rows when scrolling down using AJAX concept - Part 4

noreply@blogger.com (Thirumalai M) — Sun, 21 Oct 2012 05:02:00 PDT

Previously I had blogged about rendering the GridView rows on demand, which will render the rows while scrolling the GridView down to the end of the rows. The example in that post does not have any functionality such as updating the records, deleting the records. This post talks about doing such functionalities. As discussed in previously post, the implementation done using AJAX concept which

Implementing Role Based Access Control on ACS - Part 1

noreply@blogger.com (Thirumalai M) — Sun, 14 Oct 2012 01:19:48 PDT

Role Basic Access Control (RBAC): Role-based access control is an approach for restricting the system access or activities in system based on group of users who has same role assigned. Wikipedia says – “Role-based access control (RBAC) is an approach to restricting system access to authorized users. It is used by the majority of enterprises with more than 500 employees, and can implement

Implementing Role Based Access Control on ACS - Part 2

noreply@blogger.com (Thirumalai M) — Tue, 04 Dec 2012 02:45:46 PST

This is a continuation of previous post. Please refer the below link to know more about previous post - Implementing Role Based Access Control on ACS. Adding Role claim using ACS portal As we know already (from previous post), when generating rules for public identities using Generate button on ACS portal under a Rule Groups, it does not contain a claim - Role. This is because, the public

Configuring ACS for consuming ADFS and using in Web Application - Part 3

noreply@blogger.com (Thirumalai M) — Sat, 29 Sep 2012 08:39:06 PDT

Adding Relying Party Trust on ADFS for the ACS namespace We required to create Relying Party Trust for the ACS namespace, otherwise AD FS will not know where the request comes from and which URL it respond to. Step 1: Open the AD FS 2.0 Management window by navigating Start -> Administrative Tasks -> AD FS 2.0 Management menu. Step 2: Click the Add Relying Party Trust from the Actions panel in

Configuring ACS for consuming ADFS and using in Web Application - Part 2

noreply@blogger.com (Thirumalai M) — Mon, 08 Oct 2012 23:26:20 PDT

Configuring End point to expose the AD FS to public As we are planning to consume this AD FS into ACS, we must configure endpoint for that Virtual Machine to expose. So open the Management Portal and navigate to the Virtual Machine created. Select the Endpoints tab and add two endpoints as below. Opening Port 80 (for accessing normal websites) Opening Port 443 (for accessing SSL

Configuring ACS for consuming ADFS and using in Web Application - Part 1

noreply@blogger.com (Thirumalai M) — Sat, 29 Sep 2012 08:38:57 PDT

Previously we had seen implementing ACS with the Web Application for achieving SSO with public identities such as Live Id, Google Id, Yahoo Id and Facebook. In this post I am planning to walkthro’ exposing Active Directory to public using ADFS and configuring with ACS. Then our application can consume with applications using ACS. This allows us to extend our authentication requirement in more

Getting Started with Windows Azure Active Directory

noreply@blogger.com (Thirumalai M) — Thu, 20 Dec 2012 04:24:39 PST

Windows Azure Active Directory is a cloud identity solution from Microsoft which allows us to achieve Single Sign-on for all online Microsoft services such as Windows Azure, Office 365 and Windows Intune. This custom application can also consume Windows Azure AD for single sign-on solutions. Microsoft announced Windows Azure Active Directory as a standalone service last week in preview. In this