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

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

Resolved Issue in Asp core 3.0 serializersettings does not exist in AddJsonOptions

-
Hello, When we want to use serializersettings  function in configure service (IN startup .cs) for CamelCasing .then we get this issue  in asp core 3.0. So we can resolve it by adding below code in configure service file public void ConfigureServices(IServiceCollection services) { services.AddMvc(setupAction => { setupAction.EnableEndpointRouting = false; }).AddJsonOptions(jsonOptions => { jsonOptions.JsonSerializerOptions.PropertyNamingPolicy = null; }) .SetCompatibilityVersion(CompatibilityVersion.Version_3_0);
Read more

.Net most asked interview questions for experienced professionals (C#,Asp WEBFORM,MVC,ASP CORE,WEB API,SQL Server,Java Script,Jquery)

-
Hello All Recently I have participated in multiple interviews. I found a lot of most frequently asked questions on the .Net framework. So I am just going to share with you, I hope it will be helpful while interview. I am just starting from C# questions and you have to find the answer over the Internet. I will update more question later C# Question    What is manage/Unmanaged code in c#  Tell me one scenario, Use of Interface instead of Abstract? Difference between Abstract Class and Interface with Scenario when to use it (Brief explain ) What happens if the inherited interfaces have conflicting method names? If one interface has 5 methods and wants to implement only 2 methods derived class. How can we do it? What Difference between Abstract and virtual method  and why we use if both near to  same  What is Constructor and its type, Default, Public, Private, Static  What is the Constructor Chaining in C#? What is...
Read more