Turn off the GridLine : GridView « ADO.net Database « ASP.Net






Turn off the GridLine


<%@ Page Language="C#" AutoEventWireup="true" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:SqlDataSource ID="sourceProducts" 
                           runat="server" 
                           ConnectionString="<%$ ConnectionStrings:Northwind %>"
                           ProviderName="System.Data.SqlClient" 
                           SelectCommand="SELECT ProductID, ProductName, UnitPrice, UnitsInStock FROM Products">
        </asp:SqlDataSource>
        <asp:GridView ID="GridView1" 
                      runat="server" 
                      AutoGenerateColumns="False" 
                      CellPadding="4"
                      DataKeyNames="ProductID" 
                      DataSourceID="sourceProducts" 
                      Font-Names="Verdana" 
                      Font-Size="Small" 
                      ForeColor="Black" 
                      GridLines="None" 
                      AllowPaging="True">
            <FooterStyle BackColor="White" Font-Bold="True" ForeColor="White" />
            <RowStyle BackColor="Pink" ForeColor="Black" />
            <PagerStyle BackColor="Red" ForeColor="Black" HorizontalAlign="Center" />
            <SelectedRowStyle BackColor="Red" Font-Bold="True" ForeColor="Navy" />
            <HeaderStyle BackColor="White" Font-Bold="True" ForeColor="White" />
            <AlternatingRowStyle BackColor="White" />
            <Columns>
                <asp:BoundField DataField="ProductID" 
                                HeaderText="ID" 
                                InsertVisible="False" 
                                ReadOnly="True"
                                SortExpression="ProductID" />
                <asp:BoundField DataField="ProductName" 
                                HeaderText="Product" 
                                SortExpression="ProductName" />
                <asp:BoundField DataField="UnitPrice" 
                                DataFormatString="{0:C}" 
                                HeaderText="Price"
                                SortExpression="UnitPrice" />
                <asp:BoundField DataField="UnitsInStock" 
                                HeaderText="UnitsInStock" 
                                SortExpression="Units In Stock" />
            </Columns>
        </asp:GridView>
    
    </div>
    </form>
</body>
</html>

File: Web.config

<?xml version="1.0"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
  <appSettings/>
      <connectionStrings>
        <add name="Northwind" connectionString="Data Source=localhost;Initial Catalog=Northwind;Integrated Security=SSPI"/>
      </connectionStrings>
</configuration>

 








Related examples in the same category

1.Displaying data in database table with the GridView control.
2.The GridView control supports programmatic databinding
3.Selecting Data
4.Using Data Keys
5.Paging Through Data
6.Sortable GridView
7.Change row style for higher value
8.Highlight Rows
9.Numeric Format Strings
10.Time and Date Format Strings
11.GridView custom paging with ObjectDataSource
12.GridView format event
13.GridView selection style
14.GridView Summaries
15.Using the RowDeleted event to catch SQL errors (C#)
16.Using the RowDeleted event to catch SQL errors (VB)
17.Adding a delete link to the GridView
18.Checking for Update errors using the RowUpdated event (C#)
19.Checking for Update errors using the RowUpdated event (VB)
20.Turning off AutoGenerateColumns in the GridView control
21.Using the RowCreated Event to programmatically change the style
22.Adding Indicators to display Sorting Direction