show gridview header.

-
asp.net show  gridview header when no data or no recoards  in gridview. 

 Here I explain how to display or show gridview header even if gridview does not contain data or show gridview header with no records or data.

 aspx page-

 <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="Admin_Exam_Default" %>
<!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></title>
    <style type="text/css">
        .Gridview
        {}
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <asp:GridView ID="gvdata" runat="server" CssClass="Gridview" GridLines="Both" 
            AutoGenerateColumns="false" HeaderStyle-BackColor="#123b6a" 
            HeaderStyle-ForeColor="White" Width="1006px">
<Columns>
 <asp:TemplateField HeaderText=" Id" >
                <ItemTemplate>

                     
                    <asp:Label ID="lblsljjno" runat="server" Text=' <%#Eval("store_id") %>'></asp:Label>
                    
              
                </ItemTemplate>
             <HeaderStyle  ForeColor="White"  CssClass="gridviewcourseheader"  />
            </asp:TemplateField>
             <asp:TemplateField HeaderText=" Name" >
                <ItemTemplate>

                     
                    <asp:Label ID="lblaaasno" runat="server" Text=' <%#Eval("store_name") %>'></asp:Label>
                    
              
                </ItemTemplate>
             <HeaderStyle  ForeColor="White"  CssClass="gridviewcourseheader"  />
            </asp:TemplateField>
            <asp:TemplateField HeaderText=" Code" >
                <ItemTemplate>

                     
                    <asp:Label ID="lbaswsflsno" runat="server" Text=' <%#Eval("store_code") %>'></asp:Label>
                    
              
                </ItemTemplate>
             <HeaderStyle  ForeColor="White"  CssClass="gridviewcourseheader"  />
            </asp:TemplateField>
            <asp:TemplateField HeaderText=" store_type_id" >
                <ItemTemplate>

                     
                    <asp:Label ID="ffff" runat="server" Text=' <%#Eval("store_type_id") %>'></asp:Label>
                    
              
                </ItemTemplate>
             <HeaderStyle  ForeColor="White"  CssClass="gridviewcourseheader"  />
            </asp:TemplateField>
</Columns>
</asp:GridView>
    
    </div>
    </form>
</body>

</html>


and c# code-

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public partial class Admin_Exam_Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            BindGridviewData();
        }
    }
    protected void BindGridviewData()
    {
        SqlConnection con = new SqlConnection("Data Source=MANVENDRA;Initial Catalog=Newerp;Integrated Security=True");
        con.Open();
        SqlCommand cmd = new SqlCommand("select store_id,store_name,store_code,store_type_id from tbl_store", con);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds);
        if (ds.Tables[0].Rows.Count == 0)
        {
            ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
            gvdata.DataSource = ds;
            gvdata.DataBind();
            int columncount = gvdata.Rows[0].Cells.Count;
            gvdata.Rows[0].Cells.Clear();
            gvdata.Rows[0].Cells.Add(new TableCell());
            gvdata.Rows[0].Cells[0].ColumnSpan = columncount;
            gvdata.Rows[0].Cells[0].Text = "No Records Found";
        }
        else
        {
            gvdata.DataSource = ds;
            gvdata.DataBind();
        }
        con.Close();

    }
}

Comments

Post a Comment

Popular posts from this blog

Dynamic Mega Menu With Asp.Net with c#,java script and Sql Server.

-
Image
Introduction: In this article you’ll see how to Create dynamic  Mega Menu in asp.net .Having a menu and sub menus with links is very normal in a Web application. Typically, we create static menu and menu items. But sometimes we need dynamic mega menu when we do not know what the menu names and links will be called. Mega menus are a growing trend in web design . For sites that involve a lot of pages and/or products, a mega menu may be able to improve navigation and usability. Dynamic Mega Menu with ASP.NET, C#, jQuery and SQL Server solution that I would like to share with others puzzled with the same as was one of my website development i was having a tough time creating a Mega menu from database. Step1  Database:  I have 4 table category,subcategory  subcategory2 and  Brand  GO /****** Object:  Table [dbo].[tbl_Category]    Script Date: 07/30/2015 08:03:43 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON ...
Read more

Bootstrap Modal Popup keep open on PostBack in ASP.Net

-
In This tutorial will show you how keep open Bootstrap Modal Popup when Postback in asp.net I have added one button inside  bootstrap model. in some requirement we need to save data and get some output on popup after button click in model popup . source code- <form id="form1" runat="server"> <asp:ScriptManager ID="ScriptManager1" runat="server"> </asp:ScriptManager> <div class="container"> <div class="row"> <h1> Hello, world! Hello, world!</h1> <!-- jQuery (necessary for Bootstrap's JavaScript plugins) --> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.2/jquery.min.js"></script> <!-- Include all compiled plugins (below), or include individual files as needed --> <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.2/js/bootstrap.min....
Read more

Export div content to PDF Using ITextSharp in asp.net

-
Image
In this short article I will explain how to export content in a div to a PDF using ITextSharp  in ASP.Net. Step1: ITextSharp is a free and open source assembly that helps to convert page output or HTML content in a PDF file.Download it first from given link  and add dll file in bin folder- https://sourceforge.net/projects/itextsharp/files/itextsharp/ Step2 -add Page <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Studentdetails.aspx.cs" Inherits="Studentdetails" EnableEventValidation = "false" %> <!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></title> </head> <body>     <form id="form1" runat="server">   <div id="studentdetails" runat=...
Read more