presonal use Dynamically bind dropdownlist

test.aspx ---------------------------------------- test.asx.cs using MaaShardaTech.Common; public partial class test : System.Web.UI.Page { CommonFun objcf = new CommonFun(); protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { objcf.SetDoctrTypeToDDL(ddlDoctorsType); } } } ------------------------------------- in App_Code Folde CommonFun.cs namespace MaaShardaTech.Common { public class CommonFun { object[] args; public CommonFun() { // // TODO: Add constructor logic here // } public void SetDoctrTypeToDDL(DropDownList ddlc) { DoctorTypesDAL objCoun = new DoctorTypesDAL(); ddlc.Items.Clear(); ddlc.DataSource = objCoun.GetAllDoctorTypes().DefaultView; ddlc.DataTextField = "DoctorType"; ddlc.DataValueField = "DoctorTypeID"; ddlc.DataBind(); ddlc.Items.Insert(0, new ListItem("Select", "0")); } } } ------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------- public partial class PO_Registration : BasePage { protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { BindDropDownList(); } } public void BindDropDownList() { GetDataForDropDownList(DropdownListProject, "projName", "projCode", "Project"); } public void GetDataForDropDownList(DropDownList ddl, string strTextField, string strValueField, string strQueryType) { DataSet ds = null; } } ---------------------------------------------------------------------------------------------------------------------------------------------- use for multilayer ------------------------------------ public partial class Customer_PO_Add : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { BindItemName(); } } public void BindItemName() { MaashardaTech.DynamicDropDownBind.obj_DynamicDropDown.FillDropDown(MaashardaTech.DynamicDropDownBind.obj_DynamicDropDown.FillItemName(), ddlItemName, "ItemName", "ItemId", "Select Item"); } } ----------------------------------------- DynamicDropDownBind.cs namespace MaashardaTech { public class DynamicDropDownBind { public static MaashardaTech.DynamicDropDownBind obj_DynamicDropDown= new DynamicDropDownBind(); public void FillDropDown(DataSet ds, DropDownList ddl, string textfield, string valuefield, string defaultfield) { if (ds != null && ds.Tables[0].Rows.Count > 0) { ddl.DataSource = ds; ddl.DataTextField = textfield; ddl.DataValueField = valuefield; // ddl.SelectedValue = selectvalue; ddl.DataBind(); } // ddl.Items.Insert(0, defaultfield); ddl.Items.Insert(0, new ListItem(defaultfield,"0")); //ddl.SelectedIndex = 0; } public DataSet FillItemName() { DataSet DataSetState = BusinessLayer.BusinessLayer_EmployeeRegistrationDetail.Instance.getItemName(); if (DataSetState != null && DataSetState.Tables != null) { return DataSetState; } else return null; } } } ------------------------------- BusinessLayer_EmployeeRegistrationDetail.cs namespace BusinessLayer { public class BusinessLayer_EmployeeRegistrationDetail { public static BusinessLayer.BusinessLayer_EmployeeRegistrationDetail Instance = new BusinessLayer_EmployeeRegistrationDetail(); public DataSet getItemName() { return DataLayer.DataLayer_EmployeeRegistrationDetail.Instance.getItemName(); } } } -------------------------------------------- namespace DataLayer { public class DataLayer_EmployeeRegistrationDetail { public static DataLayer_EmployeeRegistrationDetail Instance = new DataLayer_EmployeeRegistrationDetail(); public DataSet getItemName() { string strQuery = "select ItemId, ItemName from MeriTech_ItemMaster where IsActive=1"; return DataLayer_GeneralMethods.Instance.FillDataSet(strQuery); } } } -------------------------------- DataLayer_GeneralMethods.cs namespace DataLayer { public class DataLayer_GeneralMethods { public static DataLayer_GeneralMethods Instance = new DataLayer_GeneralMethods(); public DataSet FillDataSet(string strQuery) { string strConnectionString = DataLayer_ConnectionString.ActiveConnectionString; SqlConnection con = new SqlConnection(strConnectionString); SqlCommand cmd = new SqlCommand(); DataSet dsData = new DataSet(); cmd.Connection = con; cmd.CommandTimeout = 5000; cmd.CommandType = CommandType.Text; cmd.CommandText = strQuery; try { con.Open(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dsData); } catch (Exception ex) { dsData = null; } finally { con.Close(); con.Dispose(); cmd.Dispose(); } return dsData; } } } ----------------------------------------------------- DataLayer_ConnectionString.cs using System.Data.SqlClient; namespace DataLayer { public class DataLayer_ConnectionString { public static DataLayer_ConnectionString Instance = new DataLayer_ConnectionString(); public static SqlConnection _ConnectionString; public DataLayer_ConnectionString() { } public static string ActiveConnectionString { get { return System.Configuration.ConfigurationManager.ConnectionStrings["conResourceTracker"].ConnectionString.ToString(); } } public SqlConnection con_Open() { SqlConnection con = new SqlConnection(); try { con = new SqlConnection(ActiveConnectionString.ToString()); if (con.State == ConnectionState.Closed) { con.Open(); } } catch (Exception ex) { } return con; } public void con_Close(SqlConnection con) { try { if (con.State == ConnectionState.Open) { con.Close(); con.Dispose(); } } catch (Exception ex) { } } } } -----------------------------------------------------------------------------------------------------------------------------


         

 if (!IsPostBack)   
            {
 String SC1 = ConfigurationManager.ConnectionStrings["AspConnectionString"].ConnectionString;
            string SqlQueery1 = "select CityId, CityName, CountryName from TblCity";
            using (SqlConnection con = new SqlConnection(SC1))
            {
                SqlCommand cmd = new SqlCommand(SqlQueery1, con);
                con.Open();
                SqlDataReader dr = cmd.ExecuteReader();
                ddlPart17B.DataSource = dr;
                ddlPart17B.DataTextField = "CityName"; 
                ddlPart17B.DataValueField = "CityId";  
                ddlPart17B.DataBind();
               
            }
}

---------------------------------------------------------------------------------------------------------------------------------------


        
        
        
        
        

#region Part 22 In Page Load
          
            if (!IsPostBack)
            {
               ddlPart22Continet.DataTextField = "ContinenetName";
               ddlPart22Continet.DataValueField = "ContinenetId";
               ddlPart22Continet.DataSource = GetData("Pro_TblContinent", null);
               ddlPart22Continet.DataBind();
               ListItem liContinent = new ListItem("-Select Continnent-", "-1");
               ddlPart22Continet.Items.Insert(0, liContinent);

               ListItem liCountry = new ListItem("-Select Country-", "-1");
               ddlPart22Country.Items.Insert(0, liCountry);
               ddlPart22Country.Enabled = false;

               ListItem liCity = new ListItem("-Select City-", "-1");
               ddlPart22City.Items.Insert(0, liCity);
               ddlPart22City.Enabled = false;
            #endregion

            }



 #region Part 22 Outside Of Page Load
        //--------------------------Part 22------------------------------------
        private DataSet GetData(string Pro_Name, SqlParameter Pro_Parameter)//since three store procedure and call again and again, which increase traffic so we write common method to call all store procedure
        {
            string Sc = ConfigurationManager.ConnectionStrings["AspConnectionString"].ConnectionString;
            SqlConnection con = new SqlConnection(Sc);
            SqlDataAdapter da = new SqlDataAdapter(Pro_Name, con);
            da.SelectCommand.CommandType = CommandType.StoredProcedure;
            if (Pro_Parameter != null)
            {
                da.SelectCommand.Parameters.Add(Pro_Parameter);
            }
            DataSet Ds = new DataSet();
            da.Fill(Ds);
            return Ds;


            //Or   When Use Blow Line through an error   Invalid attempt to call FieldCount when reader is closed.  why?

            //SqlCommand da = new SqlCommand(pro, con);
            //da.CommandType = CommandType.StoredProcedure;
            //if (param != null)
            //{
            //    da.Parameters.Add(param);
            //}
            //con.Open();
            //return da.ExecuteReader();
        }

        protected void ddlPart22Continet_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (ddlPart22Continet.SelectedIndex == 0)
            {
                ddlPart22Country.SelectedIndex = 0;
                ddlPart22Country.Enabled = false;
                ddlPart22City.SelectedIndex = 0;
                ddlPart22City.Enabled = false;
            }
            else
            {
                ddlPart22Country.Enabled = true;
                SqlParameter SqlPara = new SqlParameter("@ContinetId", ddlPart22Continet.SelectedValue);
                DataSet ds = GetData("Pro_GetCountryByContenetId", SqlPara);
                ddlPart22Country.DataTextField = "CountryName";
                ddlPart22Country.DataValueField = "CountryId";
                ddlPart22Country.DataSource = ds;
                ddlPart22Country.DataBind();
                ListItem liCountry = new ListItem("-Select- Country-", "-1");
                ddlPart22Country.Items.Insert(0, liCountry);
                ddlPart22City.SelectedIndex = 0; 
                ddlPart22City.Enabled = false;
            }
        }

        protected void ddlPart22Country_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (ddlPart22Country.SelectedIndex == 0)
            {
                ddlPart22City.SelectedIndex = 0;
                ddlPart22City.Enabled = false;
            }
            else
            {
                ddlPart22City.Enabled = true;
                SqlParameter SqlPara = new SqlParameter("@CountryId", ddlPart22Country.SelectedValue);
                DataSet ds = GetData("Pro_GetCityByCountryId", SqlPara);
                ddlPart22City.DataTextField = "CityName";
                ddlPart22City.DataValueField = "CityId";
                ddlPart22City.DataSource = ds;
                ddlPart22City.DataBind();
                ListItem liCity = new ListItem("-Select City-", "-1");
                ddlPart22City.Items.Insert(0, liCity);
            }
        }
        //End Of Part 22
        #endregion

Instead of Update Trigger in SQL Server

SQL Server No comments

Instead of Update Trigger

To Create INSTEAD OF UPDATE 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 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 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')

--Now crate 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 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 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.

Created All tables for Instead of Update Triggers

Now create the INSTEAD OF UPDATE Trigger for “tblEmployee”.

create trigger trtblEmployeeInsteadOfUpdate
on tblEmployee
INSTEAD OF update
AS
  BEGIN
     Declare @EmpId int,               
             @EmpMessage varchar(200),
             @Name varchar(30), @Gender varchar(8),
             @DepartmentId int;
     select  @EmpId =D.Id 
             from deleted D;
     select  @Name = I.Name, 
             @Gender = I.Gender,
             @DepartmentId= DeparmentId from Inserted I;
             
      
     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
            if(UPDATE(Name))
              begin
                 update tblEmployee set Name = @Name where Id= @EmpId
              end
             If(UPDATE(Gender))
               begin
                 update tblEmployee set Gender =@Gender where Id= @EmpId
               end
             If(UPDATE(DeparmentId))
               begin
                 update tblEmployee set DeparmentId =@DepartmentId where Id= @EmpId
               end
             insert into tblAudit values('Employee succefully Update with Id ' + CAST(@EmpId as varchar(5)) + 'and insert into trigger in date' + CAST(Getdate() AS nvarchar(30)))
          End
  END

Now try to Update data from tblEmployee, If we try to update id which is not exists than return message Employee with Id not exits

update tblEmployee set Name= 'janee' where id=5

Show Message Employee Not Exit

Now we try to Update id which is already exists return message successfully row effect

update tblEmployee set Name= 'janee' where id=1

Now check data from tables.

Select all tables After, Instead of Update Trigger fire

Example 2

For more understand about INSTEAD OF UPDATE 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,
  EmpOldName varchar(30) Not Null,
  EmpNewName varchar(30) Not Null,
  EmpOldGender char(8) Not Null,
  EmpNewGender char(8) Not Null,
  EmpOldDeparmentId int Not Null,
  EmpNewDeparmentId 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 UPDATE Trigger for “tblEmployee”

create trigger trtblEmployeeInsteadOfDeleteByDetail
ON tblEmployee
INSTEAD OF UPDATE
As
 BEGIN
     Declare @EmpId int, 
             @OldEmpName varchar(30), @NewEmpName varchar(30),            
             @OldEmpGender varchar(8), @NewEmpGender varchar (8),
             @OldEmpDepatmentId int, @NewEmpDepatmentId int,
             @EmpMessage varchar(300),@AuditAction varchar(2000),
             @ActionTakenBy varchar(100),@AuditTime varchar(50),
             @ServerName varchar(100), @ServerInstanceName Varchar(100);
     select  @EmpId=D.Id,             --Id Not Change
             @OldEmpName = D.Name, 
             @OldEmpGender = D.Gender,
             @OldEmpDepatmentId = D.DeparmentId from deleted D;
     select  @NewEmpName = I.Name, --delete not only keep id column value, keep all column value for which id we want delete. 
             @NewEmpGender= I.Gender, @NewEmpDepatmentId= I.DeparmentId
             from inserted I
      
     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 Update Triggers in SQL Server not fire because Employee Not Exists' 
           RollBack
       End
       Else
          Begin
             SET @AuditAction='Update Record '
             If(@OldEmpName <> @NewEmpName)
               begin
                  set @AuditAction = @AuditAction + 'Name from ' + @OldEmpName + 'to ' + @NewEmpName + ', '
                  update tblEmployee set Name= @NewEmpName where id=@EmpId
               end
             If(@OldEmpGender <> @NewEmpGender)
               begin
                 set @AuditAction =@AuditAction + 'Gender from ' + @OldEmpGender + 'to ' + @NewEmpGender + ', '
                 update tblEmployee set Gender= @NewEmpGender where id=@EmpId
               end
             If(@OldEmpDepatmentId <> @NewEmpDepatmentId)
               begin
                 set @AuditAction =@AuditAction + 'DeaparmentId from ' + CAST(@OldEmpDepatmentId as varchar(10)) + 'to ' + CAST(@NewEmpDepatmentId As varchar(10))+ ', '
                 update tblEmployee set DeparmentId= @NewEmpDepatmentId where id=@EmpId
               end
    set @ActionTakenBy = SYSTEM_USER;
 set @ServerName = CAST( SERVERPROPERTY('ServerName') AS VARCHAR(50));          -- select @@SERVERNAME return server name
 set @ServerInstanceName = CAST( SERVERPROPERTY('MachineName') AS VARCHAR(50));    --SELECT @@servicename return current machine name
             
            insert into tblAuditDetailsBy (EmpId, EmpOldName, EmpNewName, EmpOldGender, EmpNewGender,
                                 EmpOldDeparmentId, EmpNewDeparmentId, AuditAction,
                                ActionTakenBy, AuditTime,ServerName,ServerInstanceName)
                         values(@EmpId,@OldEmpName, @NewEmpName, @OldEmpGender, @NewEmpGender,
                                @OldEmpDepatmentId, @NewEmpDepatmentId, @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 Update Triggers in SQL Server'
          End
 END

Now try to Update data from tblEmployee, If we try to Update id which is not exists than return message Employee with Id not exits

update tblEmployee set Name= 'jhone', Gender='Male' where id=5

But If we try to Update id which is already exists return message successfully row effect

update tblEmployee set Name= 'jhone', Gender='Male' where id=1

Update Tables

Now check data from tables.

previous Related Post

Response.Redirect in ASP.NET and use of EndResponse

Beginners Asp.net No comments

Response.Redirect in ASP.NET

In the previous part we study about what is page navigation and there types and also study HyperLink type page navigation technique in detail. In this part we will study about Response.Redirect which also one of the navigation techniques in ASP.NET which is use to move from one web form to another that means use to redirect a user to another URL.

According to MSDN website it redirect to new URL whether execution of the current page terminated.

Redirect is a method of the HttpResponse class in ASP.NET applications, when hover mouse on it Response class and return type is void.

The HttpResponse class has two overloaded method of versions of the Redirect.

The first method takes one input parameter as a URL of the other page.

e.g.  Response.Redirect("~/default.aspx");

response.redirect c# true false

Another one is take two parameters, one as a URL and second is a Boolean value (true or false).

Response.Redirect("~/default.aspx",false);    // means current page execution is not terminated and code written after the Response.Redirect("default.aspx", false) is executed and then after the page is redirected to the default.aspx.
or
Response.Redirect("~/default.aspx",true);

When we try to use Response.Redirect("default.aspx", false) in a page then the execution of current page is not terminated instead of this code written after the Response.Redirect is executed and then after that page is redirected to the given page.

When we try to use Response.Redirect("default.aspx",true) which is by default true then the execution of current page is terminated and code written after the Response.Redirect is not executed instead of executing code written after the Response.Redirect ,the page is redirected to the given page.

Note:-

1. When you use the first overloaded version in the code, the second overloaded version is called automatically and endResponse passed True .

2. When we pass false as second parameter value that indicates we do not want an exception to be thrown to terminate the page. 3. When we use overloaded method, URL (string type) is mandatory parameter and endResponse (Boolean type, by default true) is optional parameter.

4. URL is the string parameter which takes the url or page name and endResponse is the boolean parameter which has true and false values.

We create z-test.aspx page in ASP.NET and drag and drop buttons control in this page from toolbox.

<%@ 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">
<asp:Button ID="button1" runat="server" Text="Button 1" OnClick="button1_Click" /><br />
<asp:Button ID="button2" runat="server" Text="Button 2" OnClick="button2_Click"/><br /> 
 <asp:Button ID="button3" runat="server" Text="Button 3" OnClick="button3_Click" /><br />
<asp:Button ID="button4" runat="server" Text="Button 4" OnClick="button4_Click" /><br />
</form>
</body>
</html>

Now write the code in code behind (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 button1_Click(object sender, EventArgs e)
        {
            Response.Redirect("~/test2.aspx");
        }
        protected void button2_Click(object sender, EventArgs e)
        {
            Session["Before_redirect"] = "This String is Before Response.Redirect When EndResponse values is false"; 
            Response.Redirect("~/z-test2.aspx",false);
            Session["After_redirect"] = "This String is after Response.Redirect When EndResponse values is false"; 

        }
        protected void button3_Click(object sender, EventArgs e)
        {
            Session["Before_redirect"] = "This String is Before Response.Redirect When EndResponse values is true"; 
            Response.Redirect("~/z-test2.aspx",true);
            Session["After_redirect"] = "This String is after Response.Redirect When EndResponse values is true"; 
        }
        protected void button4_Click(object sender, EventArgs e)
        {
            Response.Redirect("http://web-designing-developing-tutorials.blogspot.in/");
        }

    }
}

Now create a webform (z-test2.aspx) and write the code in code behind (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)
        {
            Response.Write("String receive from session variable Before_redirect =" + Session["Before_redirect"] + ""); 
            Response.Write("String receive from session variable After_redirect =" + Session["After_redirect"]);        
        }
     }
}

When click on Button 1

When click button1 than simply transfer to page z-test2.aspx. In button 1 we does not transfer any value to z-test.aspx.cs because we does not use session variable in button1.

But if click first button 2, or 3 than click one than session store string in session variable because Session variable store by default 20 min. In detail we study later part.

When click on Button 2

String store in session variables “Before_redirect” and “After_redirect” just before and after Response.Redirect, these session variables strings will be accessed on another page (we name it z-test2.aspx).

If we try to access these session on the other page both before and after session will be accessed because execution of current page is not terminated when EndResponse values is false. i.e code after Response.Redirect will be accessed.

When click on Button 3

Similarly as in button2 string store in session variables “Before_redirect” and “After_redirect” just before and after Response.Redirect, these session variables strings will be accessed on another page.

If we try to access these session on the other page only before Response.Redirect session will be accessed and after session will not be accessed because execution of current page is terminated when EndResponse values is true.

When click on Button 4

When click button4 it move to web-designing-developing-tutorials.blogspot blogger.

Note:-

1. The button 3 rule also apply for button 1 because EndResponse by default true if not use EndResponse.

2. If you use our code to learn than first click on Button1, Button2, than Button3 on order because Session variable store by default 20 min. In detail we study later part.

Understand Response.Redirect flow between client-and-server

When we use response.redirect, there are two request-response cycle round trip will be happend, Suppose, when we click on button immediately postback response is happened for the page and send to web server have code for respose.redirect than web server send response header back to the client and then client initiate new request for the new page and web server receive the request and process and send html page back to the client browser, this type of page navigation technique does not involve two response cycle.

Initial request with redirect                                               
                             ----------------------->

                            Got Response header from server
                           <--------------------------
       Client                                                      Web Server
                              New Request Initiated
                            ------------------------>

                           Response sent back as HTML
                           <-------------------------

NOTE:-

1. Reponse.Redirect is maintained browser history which help to back previous using back button. Redirect can be used to navigate pages/website on the same web server or different web server.

2. Response.Redirect is similar to the HyperLink technique use to navigate any website/Pages on same webserver or different web server.
In the above example, in button4_click event is satisfy this rule. 3. Due to Round trip it is bit slow.

4. After sending headers to the client and try to redirect, you receive an HttpException exception error.

Interview Question:-

Q1. What is difference between Response.Redirect true and Response.Redirect false and Rsponse.Redirect?

Page navigation techniques in asp.net-Hyperlink

Beginners Asp.net No comments

Page Navigation

In this part we will study what is page navigation technique? Why use them? Basically there are different types of page navigation technique in ASP.NET but each technique has its own importance and benefits, and which page-navigation technique should be used depends on the current scenario of the application.

Page Navigation technique in the ASP.NET
1. HyperLink Control
2. Rsponse.Redirect
3. Server.Execute
4. Cross Page PostBack
5. Window.Open

Page-Navigation use to navigate a page by suggested path. Not only you navigate a page you can also apply website navigation.

In real time in web application we need to navigate a page from one page to another page, but if not properly navigate than through an error at runtime (like 404 error).

Hyperlink

The easiest way to navigate from one web page to another web page with an ASP.NET hyperlink control.

Hyper link control maintain the history, Hyper link control is a like html anchor tag, which is use to navigate same web-server or different server.

Hyperlink does not expose server side events, so when user click on a HyperLink, there is no server side event to intercept the click where button click event is intercept.

We create Page-Navigation.aspx page in ASP.NET and drag and drop HyperLink control in this page from toolbox.

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Page-Navigation.aspx.cs" Inherits="AspDotNets.Page_Navigation" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
      <asp:HyperLink ID="hyperlink1" runat="server" NavigateUrl="~/Default.aspx" Text="Navigate to another page"></asp:HyperLink><br/>
<a href="~/Default.aspx" title=""> Navigate to another page</a>
    </form>
</body>
</html>

You can see in the above example we link Default.aspx page in the NavigateUrl property.

We also developed an anchor tag (a href link), which also move to the same page (Default.aspx) when click on anchor tag as we said above hyperlink control of ASP.NET is similar to anchor tag of html.

We create another webform to which we want to navigate through Hyperlink and we name it Default.aspx.

In the above example we show, this is the one of the simple and good website (paste link of website path in navigateUrl) or page navigation method through which we simply navigate a page from one page to another page.

Complete Web Designing & Developing Tutorials

complete web developing asp.net c-sharp (c#), sql-server and complete responsive web designing (html-html5, css-css3, java-script, jquery, bootstrap, photoshop)

presonal use Dynamically bind dropdownlist

Instead of Update Trigger in SQL Server

Instead of Update Trigger

Response.Redirect in ASP.NET and use of EndResponse

Response.Redirect in ASP.NET

response.redirect c# true false

Interview Question:-

Page navigation techniques in asp.net-Hyperlink

Page Navigation

Hyperlink

Popular Posts

Latest Post

Categories

Blogger Pages

Blog Archive