Attended SQL Server Geeks conference - Aug2015

Introduction

In this post I will share my experience at SQL Server Geeks Annual Summit 2015. Am very eager and excited while attending the Asia's first SQL Server Geeks conference by 27Aug2015 to 29Aug2015 at Bangalore NIMHAUNS convention centre. The three day session was really amazing and excellent. My previous post Improve IIS Performance by effective ways.

SQL sessions

The first day the session started with the keynote by Rengarajan at Hydra hall, was simply superb continue to that I have attended the all the major sessions Power BI, SQL server 2016 new innovations, Working with Streaming Data with streamsight, Column store Index, Advanced SQL 2014. The speaker's are all explained the concepts very well. The person I admired in between the sessions in Amit Bansal. The person who organised and successfuly conducted the conference. He is a dynamic person and providing solution to the situations.

Improve IIS Performance by effective ways

Introduction

In this post I will try to explain the IIS configuration performance tuning and settings. My previous post Difference between throw and throw ex in Asp.Net C# exceptions.

IIS

Internet Information System simply called as IIS which is used host our application. While hosting an Application we need to concentrate on performance and concurrent users hits. Basic things we need to see, While user enter some invalid page IIS will automatically show 404 error page instead of we should provide some meaningful message with custom errors. We have developed our project in 32 bit and server may have 64 bit by default, so we have an option "Enable 32 bit Application" in Advanced settings kindly mark as true.

Difference between “throw” and “throw ex” in Asp.Net C# Exception

Introduction

In this post I will try to explain the difference between throw and throw ex in Asp.Net C# Exceptions. My previous post Difference between dataset and datareader in Asp.Net C# exceptions.

Exceptions

Exceptions are always useful for dotnet developers, because we are able to provide a bug free application with the use of exception handlings.We need to find the actual exception, here throw will give the exception details.We are confusing whileusing the throw and throw ex in exceptions.Difference between "throw" and "throw ex" is, "throw" will provide the orginal exception which was available at first in stack and "throw ex" will provide the last exception message available in stack.

Difference between DataSet and DataReader

Introduction

In this post I will try to explain the difference between DataSet and DataReader. My previous post Difference between stored procedure and user defined functions.

DataSet

DataSet is a type of disconnected architecture which means sql live database connections is not required while fetch the data from database. DataSet contains the collection of multiple DataTables. We are able to keep the tables, views values from database in DataSet. Also we can fetch the XML values and store in DataSet. We can use DataAdapter as a mediator between DataSet and SQL DataBase tables.

Difference between stored procedure and user defined functions

Introduction

In this post I will explain the difference between SQL Stored procedure and functions. My previous post Send email to multiple receipent in asp.net.

Stored Procedure

In our projects we are frequently using the stored procedures and functions.Here I will explain the difference and example.Stored Procedures are set of executable statement which are already pre-compiled and stored in SQL server.Stored procedures no need to return output.We cannot use Stored Procedures in DML statements like (insert/update/delete.In Stored Procedures we can call functions and Stored Procedures inline.Stored Procedures cannot be used in SQL statements like where/having/select section.We can use try/catch block for error handling in stored procedures.

Send email to multiple receipent in asp.net

Introduction

In this post I will explain how to Send email to multiple recipient in Asp.net. My previous post Difference between union and union all in sql server,How to send email in Asp.net c#

Explanation

In my previous posts I have given about Email id validation using javascript in Asp.net, Sending email using Asp.net is simple thing but I cannot forget my first task.Because am a fresher without knowing about dotnet I started my carrer, the first task is email sending using asp.net I have searched in google for more than 15 days and finally found the solution.Ok let me come to the point, here am trying to explain how to send the same email details to multiple receipents, One way this code will helpful for monthly news letters sending and checking.Also we may easily check the email configuration setting through this.First we may design the screen as mentioned below.

Difference between union and union all in sql server

Introduction

In this post I will explain the difference between union and union all in SQL server table. My previous post Bulk update in sql server table columns using joins , SQL Query to find Nth Highest or Lowest salary of an employee table.

Explanation

Usually Union means it will return the common unique things from two different entities.In SQL server Union and Union All key words are used to retrieve the similar data between two tables in SQL select query, the major thing the tables must have the same column names and same data type.

Bulk update in sql server table columns using joins

Introduction

In this post I will explain how to update bulk columns in SQL server table. My previous post Javascript PAN Number validation in Asp.net Textbox onkeypress event, SQL Query to find Nth Highest or Lowest salary of an employee table.

Explanation

Sometimes we may need to update some columns in a table from another related tables.So here am using joins for update the columns in a table.In stored procedures it will be very useful and this will avoid cursor looping for bulk updates.It will reduce the execution timing.

Javascript PAN Number validation in Asp.net Textbox onkeypress event

Introduction

In this post I will explain how to validate PAN number using javascript on Asp.net textbox onkeypress event. My previous post Asp.net server controls validation using Javascript client side.

Explanation

Permanent Account Number is simply called as (PAN) in India who are all paying the TAX using this identification card.PAN is ten digit alphanumeric characters.All characters should be in upper case.The first five characters should be Alphabets and followed by four digit numbers and the last one should be Alphabet.The first character is the type of the PAN and the fifth character is the name of the person.

Asp.net server controls validation using Javascript client side

Introduction

In this post I will explain how to validate Asp.net server controls using client side Javascript. My previous post 3-Tier Architecture in ASP.Net C# with step by step example, Email id validation using javascript in Asp.net.

Explanation

Asp.net server controls will bind as a HTML controls in browser. Client ID is the variation between a HTML control and a server control.Here why am specifically telling about Client ID is because HTML control ID will be remain same in all pages but Asp.net controls ID will differ in normal page and a master page. So while using the Javascript we have get the control with Client ID. Here I have given how to validate textbox in javascript onkeypress event,Textbox required field validation in javascript, Drop down list required field javascript validation,Checkbox required field validation in javascript, Option button required field validationin javascript.

3-Tier Architecture in ASP.Net C# with step by step example

Introduction

In this post we will learn how to implement the three tier architecture in our application using Asp.Net c#. My previous post Highlight Asp.net gridview row color on mouseover using javascript and css

Explanation

Many interviews we faced the question whether you used 3-tier architecture in your application.Because it is mandatory to know the 3-tier architecture for developing a project. Three tier architecture is a separation of our application into multiple portion which is called as a layer.So we have to understand about the layer in 3-tier architecture.

Highlight Asp.net gridview row color on mouseover using javascript and css

Introduction

In this post I will explain how to highlight gridview row color using javascript and CSS. My previous post Email id validation using javascript in Asp.net.Gridview in asp.Net c#.

Explanation

Asp.Net Gridview control is an adjustable and adaptable control which is used to show bulk information on a column and row basis.As we all know Gridview control will rendered as a table. Even though gridview control is having many features but it has missed some client based attractive things like highlighting gridview control row color. But we can achieve highlighting row in gridview using the below given code. Highlighting a Asp.Net gridview control row is more than just to make it looks good. It serves to distinguish and concentrate on a specific row, since the Gridview shows numerous lines of information at once.

Email id validation using javascript in Asp.net

Introduction

In this post I will explain how to do email id validation in Asp.net javascript. My previous post SQL Query to find Nth Highest or Lowest salary of an employee table. How to send email in Asp.net c#

Explanation

Validation is a main purpose of a website for avoiding the invalid user entries. We can validate our controls in client side and server side. client side validation will be very simple and very fast.

SQL Query to find Nth Highest or Lowest salary of an employee table

Introduction

In this post I will explain how to find Nth Highest or Lowest salary of Employee.

Description

Here i will explain how to find Nth Highest or Lowest salary of Employee in Asp.Net.

In many interviews, frequently asking question is how to find Nth Highest or Lowest salary of Employee. Many ways are there to achieve this. Here i will explain some types.

Before that, First create a table EmployeeWage with the following columns. EmployeeID, EmployeeName, EmployeeSalary.

Cannot find one or more components:Please reinstall the application

Introduction
In this post I will try to explain the issue which I faced while opening visual studio. My previous post How to maintain the password textbox text after postback

Explanation Today morning when i opened my Visual Studio 2008 i got an error message like

"Cannot find one or more components:Please re install the application."
I was surprised, because nothing i have changed in VS 2008. I struggled for more than a half day and found that some installed DLL has corrupted in VS 2008.

May be last shutdown was not properly done or while updating windows some thing i have missed.