从gridview中的代码设置标题文本 [英] Set header text from code behind in gridview

查看：64
本文介绍了从gridview中的代码设置标题文本的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

嗨！我想在网格视图中将标题文本设置为我的数据字段！我正在使用代码隐藏数据库连接！当我运行页面时，我得到的显示与我的数据库字段名称相同，而不是我设置的标题文本！



我在代码后面使用vb！< br $> b $ b



我的前端代码文件在下面

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

<%@ 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






My code behind coding is below

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

推荐答案

Hey when you bind you data to the Gridview use

Hey when you bind you data to the Gridview use
GridView1.Columns(index).HeaderText = "My Header Text"


这篇关于从gridview中的代码设置标题文本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！

查看全文
相关文章
其他开发语言最新文章
热门教程
热门工具
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆