instead of delete trigger in SQL Server using views


To Create INSTEAD OF DELETE Triggers first of all we need to create a table (but we create two table) for which we apply trigger and need another table that hold all activity in main table.
--We create table tblDeparment

create table tblDeparment(
Id int identity(1,1) primary key not null,
DeparmentName varchar(30) not null,
Location Char(8) not null,
DeparmentHead varchar(20) not null
)

--insert data's into tblDeparment

Insert into tblDeparment values('IT','London','Carrie')
Insert into tblDeparment values('HR','Mexico','Toy')
Insert into tblDeparment values('Purchasing','Delhi','Ravi')
Insert into tblDeparment values('Finance','New York','Janie')

--Create table tblEmployee

create table tblEmployee(
Id int identity(1,1) primary key not null,
Name varchar(30) not null,
Gender Char(8) not null,
DeparmentId int null constraint FK_tblEmployee_DeparmentId foreign key(DeparmentId) references tblDeparment(Id)
)

--insert data's into tblEmployee 

insert into tblEmployee values('Jane', 'Female', 1) 
insert into tblEmployee values('Levis', 'Male', 3)
insert into tblEmployee values('Lee', 'Female', Null)
insert into tblEmployee values('Rose', 'Female', 1)
Here we create two table “tblDeparment” and “tblEmployee “ which are inter-connected through Foreign key constraint.
We will apply trigger for these tables.
Now create Views.
create View VwTblEmployeeJoinWithtblDepartment
as
select tblEmployee.Id, Name, Gender, DeparmentName
from tblEmployee
join tblDeparment
on tblEmployee.DeparmentId = tblDeparment.Id

Now create table that hold activity of main table by user.
create table tblAudit
(
Id int primary key identity(1,1) not null,
AuditData nvarchar(500)
) 

We have tables and views are given below with data.
all-tables-for-instead-of-insert-trigger
We have all tables for instead of delete trigger using vies

If we try to delete data from view than not delete show an error multiple base table affects.
try-to-delete-data-from-instead-of-delete-trigger-using-views
Try to delete data from view than show an error

So create the INSTEAD OF DELETE Trigger for “VwTblEmployeeJoinWithtblDepartment”
create trigger trtblEmployeeInsteadOfDeatilByView
ON VwTblEmployeeJoinWithtblDepartment
INSTEAD OF DELETE
As
 BEGIN
     Declare @EmpId int, @EmpName varchar(30), 
             @EmpGender varchar(8), @EmpDepatmentName varchar(20),
             @EmpMessage varchar(200);
     select  @EmpId = D.Id, @EmpName = D.Name, 
             @EmpGender= D.Gender, @EmpDepatmentName= D.DeparmentName
             from deleted D              --Here inserted table keep data which we want insert through view.
      
          If(Not exists(Select id from tblEmployee where id = @EmpId))   --If Alredy Name Exists in Cloumn than through message we can also check by UserName, EmailId etc.
             Begin
              Raiserror('Employee With Id Not Exists in the DataBase.', 16, 1)
              Print 'INSTEAD OF DELETED Triggers in SQL Server not fire.' 
              RollBack
             End
           Else
             Begin
              delete tblEmployee from tblEmployee --delete command 
              join deleted
              on tblEmployee.Id = deleted.Id                         
              insert into tblAudit values('Employee succefully deleted with Id ' + CAST(@EmpId as varchar(5)) + 'in trigger in date' + CAST(Getdate() AS nvarchar(30)))
             End
      
 END

Now delete data from view.
delete from VwTblEmployeeJoinWithtblDepartment where Id=2
Now check tables and view.
select-all-table-after-fire-instead-of-delete-trigger-using-views
select All tables and view after fire trigger

Example 2
For more understand about INSTEAD OF INSERT Trigger by view when multiple base table update so we take another trigger example.
First we create another table that hold all activity of main table done by user.
create table tblAuditDetailsBy
(
  Id int not null Primary key identity(1,1),
  EmpId int Not Null,
  EmpName varchar(30) Not Null,
  EmpGender char(8) Not Null,
  EmpDeparmentName varchar(50) Not Null,
  AuditAction varchar(1000) Not Null,
  ActionTakenBy varchar(50) Not Null,
  AuditTime datetime not null default Getdate(),
  ServerName varchar(100) Not Null,
  ServerInstanceName varchar(100) Not Null
)

Now create the INSTEAD OF DELETE Trigger for “VwTblEmployeeJoinWithtblDepartment”
create trigger trtblEmployeeInsteadOfDeleteByDetailView
ON VwTblEmployeeJoinWithtblDepartment
INSTEAD OF DELETE
As
 BEGIN
     Declare @EmpId int, @EmpName varchar(30), 
             @EmpGender varchar(8), @DeparmentName varchar(50),
             @EmpMessage varchar(300),@AuditAction varchar(2000),
             @ActionTakenBy varchar(100),@AuditTime varchar(50),
             @ServerName varchar(100), @ServerInstanceName Varchar(100);
             
     select  @EmpId=D.Id, @EmpName = D.Name, --delete not only keep id column value, keep all column value for which id we want delete. 
             @EmpGender= D.Gender, @DeparmentName= D.DeparmentName
             from deleted D
      
     If not exists(Select Id from tblEmployee where Id = @EmpId)   --If Id not Exists in Cloumn than through message, you can check other condition like departmentId =1 or Gender=Male, than you can print message you can not delete
       Begin
           Raiserror('Id does not exists', 16, 1)
           Print 'INSTEAD OF DELETED Triggers in SQL Server not fire because Id does not exists'
           RollBack
       End
       Else
          Begin
              delete tblEmployee from tblEmployee --delete command 
              join deleted
              on tblEmployee.Id = deleted.Id                                      
             
             SET @AuditAction='Delete Record'
             SET @ActionTakenBy= SYSTEM_USER
             SET @ServerName = CAST(SERVERPROPERTY('ServerName') as varchar(100))
             SET @ServerInstanceName = CAST(SERVERPROPERTY('MachineName') as varchar)
             insert into tblAuditDetailsBy(EmpId, EmpName, EmpGender, EmpDeparmentName, AuditAction,
                                           ActionTakenBy, AuditTime, ServerName, ServerInstanceName)
                                    values(@EmpId,@EmpName, @EmpGender, @DeparmentName, @AuditAction,
                                           @ActionTakenBy, GETDATE(), @ServerName, @ServerInstanceName)
             PRINT 'Successfully Delete Data with ID= ' + CAST(@EmpId as varchar(5)) + CAST(Getdate() AS nvarchar(30));
             PRINT 'Fired the INSTEAD OF Delete Triggers in SQL Server'
          End
 END
Now delete data from view VwTblEmployeeJoinWithtblDepartment.
delete from VwTblEmployeeJoinWithtblDepartment where Id = 2
instead-delete-trigger-using-views-fire-when-delete-data
Try to delete data from view than fire Instead of delete trigger
Now check tables and view.
instead-of-delete-trigger-using-views



How to get javascript query string in asp.net

In the previous chapter we study how QueryString transfer variable from one page to another page through URL using C# code. In this chapter we will study how to use QueryString through JavaScript to transfer data.
z-test.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="z-test.aspx.cs" Inherits="AspDotNets.z_test" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
     <script type="text/javascript">
         function OpenNewWindowPart57() {
             var Name = document.getElementById("txtName").value;
             var Email = document.getElementById("txtEmail").value;
             window.open('z-test2.aspx?UserName=' + Name + '&EmailId=' + Email, '_blank', 'location=no,resizable=no', true);  //true means not maintain the history if false than maintain history
         }
    </script>
</head>
<body>
    <form id="form1" runat="server">
        Name:<asp:TextBox ID="txtName" runat="server"></asp:TextBox><br />
        Email:<asp:TextBox ID="txtEmail" runat="server"></asp:TextBox><br />
        <input id="btnPart57B" onclick="OpenNewWindowPart57()" type="button" value="Window Open using Html Button"/><br />
        <!--or-->
        <!--<asp:Button ID="btn" runat="server" OnClientClick="OpenNewWindowPart57()" Text="Window Open using Asp.Net Button"/><br />-->
       </form>
</body>
</html>

z-test2.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="z-test2.aspx.cs" Inherits="AspDotNets.z_test2" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
     Name:-<asp:Label ID="lblName" runat="server"></asp:Label><br />
     EmailId:-<asp:Label ID="lblEmail" runat="server"></asp:Label><br />

    </form>
</body>
</html>

z-test2.aspx.cs
using System;

namespace AspDotNets
{
    public partial class z_test2 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            lblName.Text = Request.QueryString["UserName"];
            lblEmail.Text = Request.QueryString["EmailId"];
        }
    }
}

Now Run the z-test.aspx and eneter "Mark" in name textbox and mark@gmail.com in email textbox After click on button on "go to Another Page" new window will open with output.

Example 2
z-test.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="z-test.aspx.cs" Inherits="AspDotNets.z_test" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
        Name:<asp:TextBox ID="txtName" runat="server"></asp:TextBox><br />
        Email:<asp:TextBox ID="txtEmail" runat="server"></asp:TextBox><br />
        <asp:Button ID="btnSubmit" runat="server" Text="Window Open using Asp.NEt Button" OnClick="btnSubmit_Click"/><br />
       </form>
</body>
</html>

z-test.aspx.cs
using System;
namespace AspDotNets
{
    public partial class z_test : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            
        }
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            string StrJavaScript = "";
            Response.Write(StrJavaScript);
        }
    }
}

z-test2.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="z-test2.aspx.cs" Inherits="AspDotNets.z_test2" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
     Name:-<asp:Label ID="lblName" runat="server"></asp:Label><br />
     EmailId:-<asp:Label ID="lblEmail" runat="server"></asp:Label><br />

    </form>
</body>
</html>
using System;

namespace AspDotNets
{
    public partial class z_test2 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            lblName.Text = Request.QueryString["UserName"];
            lblEmail.Text = Request.QueryString["EmailId"];
        }
    }
}


Instead of delete trigger in sql server

INSTEAD OF INSERT Trigger


To Create INSTEAD OF DELETE Triggers first of all we need to create a table (but we create two table) for which we apply trigger and we need another table that hold all activity in main table.

--We create tblDeparment table

create table tblDeparment(
Id int identity(1,1) primary key not null,
DeparmentName varchar(30) not null,
Location Char(8) not null,
DeparmentHead varchar(20) not null
)

--Now insert data into tblDeparment 

Insert into tblDeparment values('IT','London','Carrie')
Insert into tblDeparment values('HR','Mexico','Toy')
Insert into tblDeparment values('Purchasing','Delhi','Ravi')
Insert into tblDeparment values('Finance','New York','Janie')

--We create tblEmployee table

create table tblEmployee(
Id int identity(1,1) primary key not null,
Name varchar(30) not null,
Gender Char(8) not null,
DeparmentId int null constraint FK_tblEmployee_DeparmentId foreign key(DeparmentId) references tblDeparment(Id)
)

--Now insert data into tblEmployee 

insert into tblEmployee values('Jane', 'Female', 1) 
insert into tblEmployee values('Levis', 'Male', 3)
insert into tblEmployee values('Lee', 'Female', Null)
insert into tblEmployee values('Rose', 'Female', 1)

Here we create two table “tblDeparment” and “tblEmployee“ which are inter-connected through Foreign key constraint.
We will apply trigger for these tables.

Example 1 Now create table that hold activity of main table by user.
create table tblAudit
(
Id int primary key identity(1,1) not null,
AuditData nvarchar(500)
) 
We have table are given below with data.
all-tables-for-instead-of-delete-trigger
All table are given

Now create the INSTEAD OF DELETE Trigger for “tblEmployee”.
create trigger trtblEmployeeInsteadOfDelete
on tblEmployee
INSTEAD OF DELETE
AS
  BEGIN
     Declare @EmpId int,               
             @EmpMessage varchar(200);
     select  @EmpId =D.Id 
             from deleted D
      
     If(Not exists(Select Id from tblEmployee where Id = @EmpId))   --If Id not Exists in Cloumn than through message. you can check other condition like departmentId =1 or Gender=Male, than you can print message you can not delete
       Begin
           SET @EmpMessage  = 'Employee With Id ' + CAST(@EmpId as varchar(5)) + 'Not Exists in the DataBase'
           Raiserror(@EmpMessage, 16, 1)
           Print 'Employee Not Exists'
           RollBack
       End
       Else
          Begin
             delete from tblEmployee where Id= @EmpId     --delete command      
             insert into tblAudit values('Employee succefully Delete with Id ' + CAST(@EmpId as varchar(5)) + 'and insert into trigger in date' + CAST(Getdate() AS nvarchar(30)))
          End
  END
Now try to delete data from tblEmployee.
If we try to delete id which is not exists than return message Employee with Id not exits delete from tblEmployee where Id=5.
try-to-delete-row-from-table-when-instead-of-insert-trigger
Try to delete from table

Now we try to delete id which is already exists return message succefully row effect delete from tblEmployee where Id=4.
delete-row-from-table
Try to delete from table

Now check data from tables.
select-table-after-fire-instead-of-insert-trigger
Selete table after fire instead of delete trigger

Example 2

For more understand about INSTEAD OF DELETE Trigger we take another trigger example.

First we create another table that hold all activity of main table done by user.
create table tblAuditDetailsBy
(
  Id int not null Primary key identity(1,1),
  EmpId int Not Null,
  EmpName varchar(30) Not Null,
  EmpGender char(8) Not Null,
  EmpDeparmentId int Not Null,
  AuditAction varchar(1000) Not Null,
  ActionTakenBy varchar(50) Not Null,
  AuditTime datetime not null default Getdate(),
  ServerName varchar(100) Not Null,
  ServerInstanceName varchar(100) Not Null
)
Now create the INSTEAD OF DELETE Trigger for “tblEmployee”.
create trigger trtblEmployeeInsteadOfDeleteByDetail
ON tblEmployee
INSTEAD OF DELETE
As
 BEGIN
     Declare @EmpId int, @EmpName varchar(30), 
             @EmpGender varchar(8), @EmpDepatmentId int,
             @EmpMessage varchar(300),@AuditAction varchar(2000),
             @ActionTakenBy varchar(100),@AuditTime varchar(50),
             @ServerName varchar(100), @ServerInstanceName Varchar(100);
             
     select  @EmpId=D.Id, @EmpName = D.Name, --delete not only keep id column value, keep all column value for which id we want delete. 
             @EmpGender= D.Gender, @EmpDepatmentId= D.DeparmentId
             from deleted D
      
     If not exists (Select Id from tblEmployee where Id = @EmpId)   --If Id not Exists in Cloumn than through message, you can check other condition like departmentId =1 or Gender=Male, than you can print message you can not delete
       Begin
           SET @EmpMessage  = 'Employee With Id ' + CAST(@EmpId as varchar(5)) + 'Not Exists in the DataBase.'
           Raiserror(@EmpMessage, 16, 1)
           Print 'INSTEAD OF DELETED Triggers in SQL Server not fire because ' + @EmpMessage
           RollBack
       End
       Else
          Begin
             delete from tblEmployee where Id= @EmpId --delete command                             
             
             SET @AuditAction='Delete Record'
             SET @ActionTakenBy= SYSTEM_USER
             SET @ServerName = CAST(SERVERPROPERTY('ServerName') as varchar(100))
             SET @ServerInstanceName = CAST(SERVERPROPERTY('MachineName') as varchar)
             insert into tblAuditDetailsBy(EmpId, EmpName, EmpGender, EmpDeparmentId, AuditAction,
                                           ActionTakenBy, AuditTime, ServerName, ServerInstanceName)
                                    values(@EmpId,@EmpName, @EmpGender, @EmpDepatmentId, @AuditAction,
                                           @ActionTakenBy, GETDATE(), @ServerName, @ServerInstanceName)
             PRINT 'Successfully Delete Data with ID= ' + CAST(@EmpId as varchar(5)) + CAST(Getdate() AS nvarchar(30));
             PRINT 'Fired the INSTEAD OF Delete Triggers in SQL Server'
          End
 END
Now try to delete data from tblEmployee.
If we try to delete id which is not exists than return message Employee with Id not exits delete from tblEmployee where Id=5.
And if try to delete id which is already exists return message successfully row effect
delete from tblEmployee where Id=2
Delete-data-from-table-than-Instead-of-delete-trigger-fire
Delete data from table than Instead of delete trigger fire
 Now check data from tables.

query string in asp.net


QueryString


When we need to pass variables content from one aspx or html page to another page through URL we use QueryString.
There several choice to pass variables from one page to another but in this session we use QueryString.

QueryString use to display different data on the same page.

Syntax of QueryString

Request.QueryString(variable)[(index).count].

e.g. http://localhost:50419/z-test2.aspx?UserName=Mark&EmailId=Mark@gmail.com  
get-QueryString-in-url
Note:-
1. QueryString consist of two parts (field and value), and each of pair separated by ampersand (&) or semicolon(‘;’). i.e & or ; is used between variables.
2. ? (QuestionMark) sign, indicates the start of a QueryString and & indicate start of another QueryString.

Example
First we create new website "AspDotNets" (you can keep any name) and add "z-test.aspx" webform in website and then write the following code in source mode (look at bottom in webform three mode show design, split and source).
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="z-test.aspx.cs" Inherits="AspDotNets.z_test" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
        Name:<asp:TextBox ID="txtName" runat="server"></asp:TextBox><br />
        Email:<asp:TextBox ID="txtEmail" runat="server"></asp:TextBox><br />
        <asp:Button ID="btnSubmit" runat="server" Text="go to Another Page" OnClick="btnSubmit_Click"/><br />
       </form>
</body>
</html>

Now double click on button in design mode and paste the following code in code behind of z-test.aspx i.e. in z-test.aspx.cs
using System;
namespace AspDotNets
{
    public partial class z_test : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {  }
        protected void btnSubmit_Click(object sender, EventArgs e)        //carefully copy paste the code because "btnSubmit_Click" should must match with onclick event of button in aspx page i.e. OnClick="btnSubmit_Click" 
        {
          Response.Redirect("~/z-test2.aspx?UserName=" + txtName.Text + "&EmailId=" + txtEmail.Text);
        }
    }
}
Now For receiving the value from the z-test.aspx, we add “z-test2.aspx” webform.
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="z-test2.aspx.cs" Inherits="AspDotNets.z_test2" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
     Name:-<asp:Label ID="lblName" runat="server"></asp:Label><br />
     EmailId:-<asp:Label ID="lblEmail" runat="server"></asp:Label><br />
    </form>
</body>
</html>
Now write the following code in behind (go to code behind by right click on aspx then select View Code).
using System;
namespace AspDotNets
{
    public partial class z_test2 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            lblName.Text = Request.QueryString["UserName"];  // We can also retrieve value using their position so we can write code like Request.QueryString[0] also
            lblEmail.Text = Request.QueryString["EmailId"];  // Request.QueryString[1]  
        }
    }
}
Now run the “z-test.aspx” by right click view in browser. Now, enter "Mark" in name textbox and mark@gmail.com in email textbox.
Enter-data-in-textboxes
Enter Value in textbox
After click on button on "go to Another Page"
transfer-deatil-from-one-page-to-another-in-asp.net-using-query-string
Show transfer data from one page to another using QueryString through url

Note:-
If we enter "Mark & Tony" in Name textbox and Email textbox "mark@gmail.com" than outPut Will be like Name:-Mark and Email:- mark@gmail.com.
transfer-deatil-from-one-page-to-another-in-asp.net-using-query-string
Transfer data from one page to another using QueryString through url

After click on button
Show transfer data from one page to another using QueryString through url
Show transfer data from one page to another using QueryString through url

If we use code like below.
lblName.Text = Request.QueryString[0];
lblEmail.Text = Request.QueryString[1];
0 receive first QueryString and 1 receive second QueryString and as we know QueryString separate by & sign.
If retrieve value using their position and we enter we enter "Mark" in Name textbox and in Email textbox enter "mark@gmail.com" than outPut Will be like Name:-Mark Emial:-mark@gmail.com.
But if we enter "Mark & Tony" in name textbox and mark@gmail.com in Email textbox than outPut Will be like Name:-Mark, Emial:-Tony because & use as separator for second QueryString. see in example below.

Example

code at z_test.aspx.cs
code at z_test.aspx.cs
using System;
namespace AspDotNets
{
    public partial class z_test : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        { }
        protected void btnSubmit_Click(object sender, EventArgs e) 
        {
          Response.Redirect("~/z-test2.aspx?UserName=" + txtName.Text + "&EmailId=" + txtEmail.Text);
        }
    }
}
code at z_test2.aspx.cs
using System;
namespace AspDotNets
{
    public partial class z_test2 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            lblName.Text = Request.QueryString[0];  
            lblEmail.Text = Request.QueryString[1];
        }
    }
}
Now run program, and enter "Mark & Tony" in Name textbox and click on button.
transfer-deatil-from-one-page-to-another-in-asp.net-using-query-string
Show transfer data from one page to another using QueryString through url

use & as value in QueryString

If we want to use & as value in name, not as separator for second QueryString, we can achieve this by two way.
1. using UrlEncode
2. By Repalce & and space

Example
1. using UrlEncode

code at z_test.aspx.cs
using System;
namespace AspDotNets
{
    public partial class z_test : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        { }
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            Response.Redirect("~/z-test2.aspx?UserName=" + Server.UrlEncode(txtName.Text) + "&EmailId=" + Server.UrlEncode 
(txtEmail.Text));   //UrlEncode Encode the value which is in the url.
        }
    }
}
code at z_test2.aspx.cs
using System;
namespace AspDotNets
{
    public partial class z_test2 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            lblName.Text = Request.QueryString[0];    //or   lblName.Text = Request.QueryString["UserName"]; 
            lblEmail.Text = Request.QueryString[1];   //or   lblEmail.Text = Request.QueryString["EmailId"];
        }
    }
}

Now run the programe and Enter Mark & Tony in Name textbox and enter mark@gmail.com in EmailId textbox and click on button.
transfer-deatil-from-one-page-to-another-in-asp.net-using-query-string
Transfer data from one page to another using QueryString through url
transfer-deatil-from-one-page-to-another-in-asp.net-using-query-string
Show transfer data from one page to another using QueryString through url

2. By Repalce & and space

z_test.aspx.cs
using System;
namespace AspDotNets
{
    public partial class z_test : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        { }
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            Response.Redirect("~/z-test2.aspx?UserName=" + txtName.Text.Replace("&","%26") + "&EmailId=" + txtEmail.Text.Replace 
("&","%26")); 
        }
    }
}
code at z_test2.aspx.cs
using System;
namespace AspDotNets
{
    public partial class z_test2 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            lblName.Text = Request.QueryString[0];    //or   lblName.Text = Request.QueryString["UserName"];
            lblEmail.Text = Request.QueryString[1];   //or   lblEmail.Text = Request.QueryString["EmailId"];
        }
    }
}
Now run the program and enter "Mark & Tony" in name textbox and enter mark@gmail.com in email and click on button.
transfer-deatil-from-one-page-to-another-in-asp.net-using-query-string
Show transfer data from one page to another using QueryString through url

Note:-
In URL space is replace by %20 and & is replace by %26.