<%@ 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>
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
GridView1.Columns(index).HeaderText = "My Header Text"
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)