Click here to Skip to main content
15,867,835 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi! I want to set header text to my data fields in grid view ! I am using code behind for database connection! When I run page I am getting display same as my database field name instead of my header text which is set by me!

I am using vb in code behind!


My front end code file is below
XML
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="StudentInfo.aspx.vb" Inherits="StudentInfo" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
<link rel="stylesheet" type="text/css" href="style1.css" media="screen" />
<link rel="stylesheet" type="text/css" href="menustyle.css" media="screen" />


</head>
<body>
    <form id="form1" runat="server">
    <div id="wrap">

<div id="header">

<img src="DEO copy.jpg" alt="" width="100%" />

</div>

<ul id="qm0" class="qmmc">

	<li><a class="qmparent" href="Index.aspx">મુખ્‍ય પાનુ </a></li>

	<li><a class="qmparent" href="java<!-- no -->script:void(0)">અમારા વિશે</a>

		<ul>
		<li><a href="sankul.aspx">સંકુલ </a></li>
		
		<li><a href="javabdari.aspx">જવાબદારીઓ </a></li>
		<li><a href="shakhao.aspx">શાખાઓ</a>
		<ul>
		
		<li><a href="hishabishakha.aspx">હિસાબી શાખાઓ</a></li>
		<li><a href="rajistry.aspx">રજિસ્ટ્રી શાખા</a></li>
		<li><a href="pariksha.aspx">પરીક્ષા બોર્ડ</a></li>
		</ul>
		
		</li>
		</ul></li>

	<li><a class="qmparent" href="yojana.aspx">યોજના </a>
	<ul> <li><a href="Pension.aspx ">પેન્‍શન યોજના </a></li>
     <li><a href="RMSA.aspx">આર.એમ.એસ.એ</a>
     <ul><li><a href="Ict.aspx">ICT@Schools Project </a></li> </ul>
        
     </li>
    </ul>
		</li>

	<li><a class="qmparent" href="Pravutti.aspx">પ્રવૃત્તિઓ</a>
    <ul>
    <li><a href="Ankdakiya.aspx">શાળાઓની યાદી </a></li>
    <li><a href="students.aspx">આંકડાકીય માહિતી </a></li>
    </ul>
    
    </li>
    
    <li><a class="qmparent" href="paripatro.aspx">પરિપત્રો </a> </li>
    <li><a class="qmparent" href="Photo.htm"> ફોટો ગેલેરી </a></li>
    <li><a class="qmparent" href="contact.aspx">સંપર્ક </a> </li>

<li class="qmclear"> </li></ul>


<div id="content">
        <div id="templatemo_middle">
               

<div class="left" style="width: 897px">

<h1>સરકારી માધ્‍યમિક શાળાના વિધાર્થીઓની આંકડાકીય માહિતી </h1>
<br />

<asp:GridView ID="GridView1" runat="server" BackColor="White" BorderColor="#CC9966" BorderStyle="None" BorderWidth="1px" CellPadding="8" Width="659px">
    <footerstyle backcolor="#FFFFCC" forecolor="#330099" />
    <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="#663399" />
    <pagerstyle backcolor="#FFFFCC" forecolor="#330099" horizontalalign="Center" />
    <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="#FFFFCC" />
    <rowstyle backcolor="White" forecolor="#330099" />
       
        <columns>
        <asp:BoundField DataField="SrNo" HeaderText="SrNo" />
        <asp:BoundField DataField="SchoolName" HeaderText="શાળાનુ નામ " />
        <asp:BoundField DataField="Village" HeaderText="Village" />
        <asp:BoundField DataField="Taluka" HeaderText="Taluka1" />
        <asp:BoundField DataField="Std9ScBoys" HeaderText="Boys" />
        <asp:BoundField DataField="Std9ScGirls" HeaderText="Girls" />
        <asp:BoundField DataField="Std9StBoys" HeaderText="Boys" />
        <asp:BoundField DataField="Std9StGirls" HeaderText="Girls" />
        <asp:BoundField DataField="Std9ObcBoys" HeaderText="Boys" />
        <asp:BoundField DataField="Std9ObcGirls" HeaderText="Girls" />
        <asp:BoundField DataField="Std9GenBoys" HeaderText="Boys" />
        <asp:BoundField DataField="Std9GenGirls" HeaderText="Girls" />
        <asp:BoundField DataField="Std9Total" HeaderText="Total" />
        <asp:BoundField DataField="Std10ScBoys" HeaderText="Boys" />
        <asp:BoundField DataField="Std10ScGirls" HeaderText="Girls" />
        <asp:BoundField DataField="Std10StBoys" HeaderText="Boys" />
        <asp:BoundField DataField="Std10StGirls" HeaderText="Girls" />
        <asp:BoundField DataField="Std10ObcBoys" HeaderText="Boys" />
        <asp:BoundField DataField="Std10ObcGirls" HeaderText="Girls" />
        <asp:BoundField DataField="Std10GenBoys" HeaderText="Boys" />
        <asp:BoundField DataField="Std10GenGirls" HeaderText="Girls" />
        <asp:BoundField DataField="Std10Total" HeaderText="Total" />
        <asp:BoundField DataField="GrossTotal" HeaderText="GrossTotal" />
        
        
        </columns>
        
 
       
    <br />
    <br />
    <br />
</div>

<div style="clear:both;">  </div>

</div>
</div>
<br />
<br />
<br />
<br />
<br />


<center><a href="http://www.gseb.org"><img src="gseb.jpg" alt="" /></a>  <a href="http://india.gov.in/"><img src="india_gov_logo.gif"  alt="" /></a>  <a href="http://www.gujaratindia.com/"><img src="guj_govt_logo.gif"  alt="" /></a>  <a href="http://www.gujarattourism.com/"><img src="guj_tourism_logo.gif"  alt="" /></a></center>
<div id="footer">
Designed by <a href=" ">Rudra Infotech</a>
</div>

</div>    

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



My code behind coding is below

VB
Imports System.Data.OleDb.OleDbCommand
Imports System.Data.OleDb.OleDbDataReader
Imports System.Data.OleDb
Imports System
Imports System.Data.OleDb.OleDbConnection
Imports System.IO

Partial Class StudentInfo
    Inherits System.Web.UI.Page
    Dim cn As OleDbConnection
    Dim cmd As OleDbCommand
    Dim dr As OleDbDataReader
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

        cn = New OleDbConnection("Provider = Microsoft.Jet.OleDb.4.0;Data source=" & Server.MapPath("DEO.mdb"))
        cn.Open()
        cmd = New OleDbCommand("select * from Student", cn)
        dr = cmd.ExecuteReader

        If dr.HasRows = True Then
            GridView1.DataSource = dr
            GridView1.Visible = True
            GridView1.DataBind()
            'MsgBox(GridView1.Columns.Count)
            'GridView1.Columns(0).Visible = False
            'GridView1.Columns(1).Visible = False
            'GridView1.Columns(2).Visible = False
            'GridView1.Columns(3).Visible = False
            'GridView1.Columns(4).Visible = False
            'GridView1.Columns(5).Visible = False
            'GridView1.Columns(6).Visible = False
            'GridView1.Columns(7).Visible = False
            'GridView1.Columns(8).Visible = False
            'GridView1.Columns(9).Visible = False
            'GridView1.Columns(10).Visible = False
            'GridView1.Columns(11).Visible = False
            'GridView1.Columns(12).Visible = False
            'GridView1.Columns(13).Visible = False
            'GridView1.Columns(14).Visible = False
            'GridView1.Columns(15).Visible = False
            'GridView1.Columns(16).Visible = False
            'GridView1.Columns(17).Visible = False
            'GridView1.Columns(18).Visible = False
            'GridView1.Columns(19).Visible = False
            'GridView1.Columns(20).Visible = False
            'GridView1.Columns(21).Visible = False
            'GridView1.Columns(22).Visible = False

        End If
        
        dr.Close()

        cmd.ExecuteNonQuery()
        MsgBox(GridView1.Columns.Count)
    End Sub
End Class
Posted
Updated 21-Mar-13 6:36am
v3

1 solution

Hey when you bind you data to the Gridview use
VB
GridView1.Columns(index).HeaderText = "My Header Text"
 
Share this answer
 
Comments
Md Jamaluddin Saiyed 21-Mar-13 13:01pm    
When I using above code GridView1.Columns(index).HeaderText = "My Header Text" I am getting
"Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index" error
frostcox 21-Mar-13 13:21pm    
Hey you need to replace index with your column index I.e 0 etc.........
Md Jamaluddin Saiyed 22-Mar-13 10:38am    
sir I have all ready do that !! but got above error
frostcox 22-Mar-13 11:02am    
Hi Replace dr = cmd.ExecuteReader with:
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);GridView1.DataSource = dt;
Also you are calling cmd.ExecuteNonQuery() after your closing your reader why?

Md Jamaluddin Saiyed 22-Mar-13 13:24pm    
This method is working same as data reader I want to change header text !! When I trying to do that error " Index was out to range" is coming !! please give me solution for this , thanks for support

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900