Repeater

1) Create one page – gridview.aspx

             2)  Insert one table

            3)  Place “Repeater“ from toolbox

            4)  Go to  “HTML” source.

            5) Add the code inside “REPEATER”  tag

                    <HeaderTemplate>

                  <Table><TR>

                              <td>Dept id</td>

                            <td>Dept Name</td>

                      </TR>

                              </HeaderTemplate>

                              <ItemTemplate>

                               <TR>

                              <td><a href=”ab.aspx?id=<%#Eval(“deptid”)%”>><%#Eval(“deptid”)%></a></td> 

                              <td><asp:LinkButton ID="LinkButton1" runat="server"

              CommandArgument='<%#Eval("user_name")%>'     

                       CommandName="Editme">Editme</asp:LinkButton></td>                 

                              </TR>

                               </ItemTemplate>

                               <footerTemplate>

                              </Table>

                                </FooterTemplate>

                      

          6)   C# code to fill Repeater

                            protected void Page_Load(object sender, EventArgs e)

               {

                  con.Open();

                  String str = "select * from login";

                  SqlDataAdapter sda = new SqlDataAdapter(str,con);

                  DataTable dt = new DataTable();

                  sda.Fill(dt);

                   Repeater1.DataSource = dt;

                   Repeater1.DataBind();

               }        

           7)    Select “Repeater” – right Click – properties – Events    (write this code)

                              protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)

                {

                  if (e.CommandName == "Editme")

                  {

                     String U_name = e.CommandArgument.ToString();

                     Response.Write(U_name);

                   }

           }

3 tier architecture example in asp.net with C#

Introduction

Here I will explain about uses of 3-Tier architecture and how to create or implement 3-tier architecture for our project in asp.net 

Description

1.    What is the use of 3-tier architecture and why we go for that architecture? 

2.    First we need to know what 3-Tier architecture is. 

3.    How to create 3-Tier architecture for our project?

 Uses of 3-Tier Architecture

  

1.    To make application more understandable. 

2.    Easy to maintain, easy to modify application and we can maintain good look of architecture.

3.    If we use this 3-Tier application we can maintain our application in consistency manner.   

Basically 3-Tier architecture contains 3 layers

1.    Application Layer or Presentation Layer 

2.    Business Access Layer(BAL) or Business Logic Layer(BLL) 

3.    Data Access Layer(DAL)

Here I will explain each layer with simple example that is User Registration

Application Layer or Presentation Layer

Presentation layer contains UI part of our application i.e., our aspx pages or input is taken from the user. This layer mainly used for design purpose and get or set the data back and forth. Here I have designed my registration aspx page like this

This is Presentation Layer for our project Design your page like this and double click on button save now in code behind we need to write statements to insert data into database this entire process related to Business Logic Layer and Data Access Layer.

Now we will discuss about Business Access Layer or Business Logic Layer 

Business Access Layer (BAL) or Business Logic Layer (BLL)

This layer contains our business logic, calculations related with the data like insert data, retrieve data and validating the data. This acts as a interface between Application layer and Data Access Layer

Now I will explain this business logic layer with my sample

I have already finished form design (Application Layer) now I need to insert user details into database if user click on button save. Here user entering details regarding Username, password, Firstname, Lastname, Email, phone no, Location. I need to insert all these 7 parameters to database. Here we are placing all of our database actions into data access layer (DAL) in this case we need to pass all these 7 parameters to data access layers.

In this situation we will write one function and we will pass these 7 parameters to function like this

String Username= InserDetails (string Username, string Password, string Email, string Firstname, string Lastname, string phnno, string Location)

If we need this functionality in another button click there also we need to declare the parameters likestring Username, string Password like this rite. If we place all these parameters into one place and use these parameters to pass values from application layer to data access layer by using single object to whenever we require how much coding will reduce think about it for this reason we will create entity layer or property layer this layer comes under sub of group of our Business Logic layer

Don't get confuse just follow my instructions enough

How we have to create entity layer it is very simple 

Right click on your project web application---> select add new item ----> select class file in wizard --->give name as BEL.CS because here I am using this name click ok

 Open the BEL.CS class file declare the parameters like this in entity layer 

Don’t worry about code it’s very simple for looking it’s very big nothing is there just parameters declaration that’s all check I have declared whatever the parameters I need to pass to data access layer I have declared those parameters only .