Sunday, July 29, 2012

Send multiple parameters in jquery ajax in asp.net


Here I am going explain how to send  multiple parameters using JQuery or JSON in asp.net.
If we want to send or pass multiple parameters using JSON or JQuery in asp.net we need to declare it like as shown below in our aspx page under <script> tag.
Let's write a simple code to understand it.

Thursday, July 26, 2012

Alter Encrypted Stored Procedure

How to Alter Encrypted Stored Procedure ?

Yesterday i wrote about how to write a Stored procedure in a encrypted manner. If Stored Procedure or User Defined Function are created WITH ENCRYPTION keyword then  is not possible to decrypt it using SQL Server commands. It is always advised to save a copy of the script used to create the SP or UDF on other media source than SQL Server.

Encrypted Stored Procedure

How  to write a encrypted Stored Procedure?

Sometimes we  need to write a stored procedure so that alternative user cannot see written text within  Stored Procedure.

Even you may be ineffective to see the text of the encrypted Stored Procedure in SQL Server  Activity Monitor moreover as by using Sp_helptext SpName methodology.

So what's the command to write encrypted stored procedure.

Let See

Tuesday, July 24, 2012

What's New in ASP.NET 4.5 and Visual Web Developer 11 Developer Preview

This document lists options and enhancements that are being introduced in ASP.NET 4.5. It conjointly lists enhancements being created for internet development in Visual Studio (Visual internet Developer).


  1.     ASP.NET Core Runtime and Framework
  2.     Asynchronously Reading and Writing HTTP Requests and Responses.
  3.     Enhancements to HttpRequest handling
  4.     Asynchronously flushing a response
  5.     Support for await and Task-Based Asynchronous Modules and Handlers
  6.     Asynchronous HTTP modules
  7.     Asynchronous HTTP handlers
  8.     New ASP.NET Request Validation options
  9.     Deferred ("lazy") request validation
  10.    Support for unvalidated requests.

Monday, July 23, 2012

UNION VS UNION ALL

UNION VS UNION ALL

UNION

The UNION command is employed to pick connected info from 2 tables, very similar to the be a part of command. However, when using the UNION command all selected columns have to be compelled to be of constant knowledge kind. With UNION, solely distinct values are selected.


UNION ALL

The UNION ALL command is equal to the UNION command, except that UNION ALL selects all values.

The distinction between Union and Union all is that Union all won't eliminate duplicate rows, instead it simply pulls all rows from all tables fitting your question specifics and combines them into a table.

A UNION statement effectively will a pick DISTINCT on the results set. If you recognize that each one the records came back are distinctive from your union, use UNION ALL instead, it offers faster results.