Bound Control (Data control)

 · DATA CONTROL :-

DATA CONTROL IS USED FOR REPORTING CONCEPT.

 

· PROPERTY OF DATA CONTROL :-

1) DATA SOURCE – DR

2) DATA BIND – ()

 

· PROPERTY WITH NAME IS ERROR WHICH MEANS COLUMN NAME DOES NOT MATCH WITH GRID VIEW COLUMN.

 

 

THERE ARE FOLLWING DATA CONTROL

1) GRID VIEW  :-

A) DISPLAY DATA IN TABULAR FORMAT

B) GRID VIEW INDEX STARTING FROM 0----N.

C) GRID VIEW IMPLEMENTATION

a. BASIC BINDING –

STEP = SEARCH GRID VIEW à  CLICK ARROW à EDIT COLUMN à SELECT BOUND FIELD à ADD

 

PROPERTY OF BOUND FIELD

1) HEADERTEXT

2) DATAFIELD – NAME OF COLUMN

 

HOW TO REMOVE EXTRA COLUMN 

AUTO GENERATE CHECKBOX UNSELECT.

 

Ø CODE OF BASIC BINDING

Ø             //OPEN CONNECTION

Ø             string PATH = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\COLLEGE.mdf;Integrated Security=True";

Ø             connect = new SqlConnection(PATH);

Ø             connect.Open();

Ø 

Ø             //APPLY COMMAND

Ø             string dtc = "SELECT * FROM CONNECTDB";

Ø             comm = new SqlCommand(dtc, connect);

Ø 

Ø             //EXECUTE DATA READER

Ø             datared = comm.ExecuteReader();

Ø 

Ø             //CONNECT DATA CONTROL

Ø             GridView1.DataSource = datared;

Ø             GridView1.DataBind();

Ø 

Ø             datared.Close();

 

b. GRID VIEW FORMATING :-

c. GRID VIEW FOOTER

d. GRID EVENT HANDLING

e. TEMPLATE FIELD

f. EVAL()

g. GRID VIEW EXPORT

h. GRID VIEW DATA BOUND

Comments

Post a Comment

Popular posts from this blog

l 3-tier architecture (TIER)

DAY - 28-06-2003   l  3-tier architecture (TIER) 1.  3tier architecture provides three specific layer A.  BussinessObject layer B.  BussinessLogic layer C.  DataAcess layer   A.  BussinessObject layer :- It only created data member as per database column.   B.  BussinessLogic Layer  :- This layer only communicated with aspx page.   C.  DataAcess layer  :- In this layer we work on database .   l  How to create 3 tier architecture? Step 1 :- create layer GO TO SOLUTION EXPLOSER -> RIGHT CLICK ON SOLUTION-------->CLICK ON NEW PROJECT ->SELECT CLASS LIBRARY (.NET FRAMEWORK)C# -> NAME OF LIBRARY. Step 2 :- create a class in each layer 1.  BussinessLogic - classname=userBL. 2.  BussinessObject - classname=userBO. 3.  DataAccess-classname=userDA   How to create a class :- Rightclick on the layer -> add class Step 3 - change all class to public which we made. All class is used for ...
Read more

3 tier

  NEW FOLDER (newtier) userBO   using  System; using  System.Collections.Generic; using  System.Linq; using  System.Text; using  System.Threading.Tasks;   namespace  BussinessObject {        public   class   UserBO       {          private   int  _Roll;          private   string  _Name;            public   int  Roll         {              get             {                  return  _Roll;               }   ...
Read more

New html

 padding: 10px;             margin-top: 15px;             background: #28a745;             border: none;             color: white;             font-size: 16px;             border-radius: 4px;             cursor: pointer;         }         .btn:hover {             background: #218838;         }         .message {             margin-top: 10px;             text-align: center;             font-weight: bold;         }     </style> </head> <body>     <form id="form1" runat="server">         <div clas...
Read more