Grid View[Bound Field and Template Field ]

-

Grid view is a data control.

It is used to display the records.

Grid View has two properties-

1. Data Source(it always equals to dr[datareader] )

2. Data Bind 

How to insert Grid view in our project- 

1. Select Grid view from toolbox (in data tools) 

2. Select Grid View > Master tag  

3. Select Auto format (can select the desired format) 

Bound Field- 

It is used to connect the database column to Grid View.

Bound field has two properties-

1. Header text(give the column name which will be displayed in the grid view ..Not mandatory to give the column name as same as the data base column )

2. Data field(Mandatory to give the name as same as database column ) 


How to insert bound field- 

Steps- 

Select grid view >Master tag >Edit columns >Select bound field >Click on add.

then- 

fill the data field and header text. 

Note:- Unchecked the auto generate check box.


How to show the data base records in Grid View-

Select a Button > change text property to display > Double click on it. 

CODE-

{

string k = @"path";

cn = new SqlConnection(k); 

cn.Open();


string q = "select * from Table_name "; 

cm = new SqlCommand(q,cn); 

dr = cm.ExecuteReader(); 

GridView1.DataSource = dr;

GridView1.DataBind();


} 

Template Field-

It is used to connect controls with the Grid view.

It has only one property-

Header Text.

 

How to insert Template field in data Grid view- 

Steps- 

Select the Grid View > master tag > Edit columns > Select Template Field > fill the Header text > Set the position of template in the grid view > ok  


How to insert control in Grid view- 

Steps- 

Select the Grid View > Go to source > Put the cursor in between the Template Field > Create an Item Template tag > Put the cursor in between > Select a control from toolbox.







 


Comments

Post a Comment

Popular posts from this blog

Parameter Query

-
If we pass the value with (, ' " ! $) symbols in the control that will not be accepted through normal query. Parameter Query is used to accept the value with special symbols in the control like textbox. Parameter Query use a user defined variable with an @ sign.  In Parameter Query control is written in a different syntax. Column name and variable name can not be the same. Without column_name we can not perform Parameter query. Syntax- Insert- string s= "insert into Table_name (Column_name) values (@variable_name)"; cm = new SqlCommand(s,cn); cm.Parameters.AddWithValue("variable_name", control_name); cm.ExecuteNonQuery(); Update- string q = "update Proc_table set name=@name1 where email = @email1"; cm = new SqlCommand(q, cn); cm.Parameters.AddWithValue("name1", TextBox1.Text); cm.Parameters.AddWithValue("email1", TextBox2.Text); cm.ExecuteNonQuery();  
Read more

Final Project

-
Image
Registration form project   CODING- using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient; using System.Configuration; public partial class RegPage : System.Web.UI.Page {     SqlConnection cn;     SqlCommand cm;     SqlDataReader dr;     FinalClass fc = new FinalClass();     protected void Page_Load(object sender, EventArgs e)     {         if (!IsPostBack)         {             statedisplay();         }     }     protected void connect()     {         string s = ConfigurationManager.AppSettings["Ch_Db"];         cn = new SqlConnection(s);         cn.Open();          }     protected void statedisplay...
Read more

Grid View Paging

-
  Grid View paging- Grid view paging is used when we have to read the data in bulk then we divide the complete data records into pages consists 10 records in one page. SqlDataAdapter - It is used for Grid View Paging Data Adapter reads data in group of 10 records unlike DataReader which reads the data line by line. DataSet - DataSet Object is created, it accepts the data in bulk. Fill() - Fill() is used. CODE - protected void display() { //Connection Code string s = ConfigurationManager.AppSettings["db"]; cn = new SqlConnection(s); cn.Open(); //DataSet Object DataSet ds = new DataSet(); string s = "select * from Videodb"; //SqlDataAdapter object SqlDataReader adp = new SqlDataAdapter(); adp.Fill(ds); GridView1.DataSoruce = ds; GridView1.DataBind(); } Source code-   <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"              Height="589px" Width="483px" OnPageIndexChanging="click...
Read more