Click here to Skip to main content
15,891,248 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Every thing seems correct but blank in web page. not showing Grid view values

C#
public partial class Treatments : System.Web.UI.Page
{
    string sqlstr;
    SqlDataReader dr;
    SqlCommand cmd = new SqlCommand();
    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString());


    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            FillGrid();
        }
    }

    public void FillGrid()
    {

        sqlstr = "select TID,Title,Description,Date,ImagePath from Treatments";
        DataTable dt = new DataTable();
        dt = DAL.getData(sqlstr);
        if (dt.Rows.Count > 0)
        {
            Grdtreatments.DataSource = dt;
            Grdtreatments.DataBind();
        }

    }


C#
<asp:GridView ID="Grdtreatments" runat="server" AutoGenerateColumns="False" OnRowCommand="Grdtreatments_RowCommand"
            CssClass="Grid" AllowPaging="True" AlternatingRowStyle-CssClass="alt" PagerStyle-CssClass="pgr"
            Width="100%">
            <HeaderStyle BackColor="#993333" CssClass="dgHeaderStyle" Font-Bold="True" Font-Italic="False"
                Font-Overline="False" Font-Size="Medium" Font-Strikeout="False" Font-Underline="False" />
            <AlternatingRowStyle CssClass="alt"></AlternatingRowStyle>
            <Columns>
                <asp:TemplateField HeaderText="Treatments ID">
                    <ItemTemplate>
                        <asp:Label ID="TID" runat="server" Text='<%# Eval("TID") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="Title">
                    <ItemTemplate>
                        <asp:Label ID="Title" runat="server" Text='<%# Eval("Title") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="Description">
                    <ItemTemplate>
                        <asp:Label ID="Description" runat="server" Text='<%# Eval("Description") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField>
                    <ItemTemplate>
                        <asp:LinkButton ID="LinkView" runat="server" CommandName="Select" Text="View" OnClick="LinkView_Click"></asp:LinkButton>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField>
                    <ItemTemplate>
                        <asp:HyperLink ID="HyperLinkEdit" runat="server" NavigateUrl='<%#"TreatmentsDetails.aspx?ID="+Eval("TID")%>'
                            Target="_blank" Text="Edit"></asp:HyperLink>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField>
                    <ItemTemplate>
                        <asp:LinkButton ID="HyperLinkDelete" runat="server" Text="Delete" CommandArgument='<%# Eval("TID") %>'
                            CommandName="Vdelete" OnClientClick="return ConfirmOnDelete('');" />
                    </ItemTemplate>
                </asp:TemplateField>
            </Columns>
            <PagerStyle CssClass="pgr"></PagerStyle>
        </asp:GridView>



using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
public class DAL
{
public static SqlConnection getSqlConnection()
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ConnectionString);
return conn;
}
public static DataTable getData(string Query)
{
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(Query, getSqlConnection());
da.Fill(dt);
return dt;
}
C#

Posted
Updated 4-Dec-14 22:52pm
v4
Comments
[no name] 5-Dec-14 4:06am    
Hi,

Query returns any rows (records)?
CP_vicky 5-Dec-14 4:47am    
Yes

Post code for DAL.getdata().
Otherwise, code looks fine.
 
Share this answer
 
ASP.NET
<asp:gridview id="Grdtreatments" runat="server" autogeneratecolumns="False" onrowcommand="Grdtreatments_RowCommand" xmlns:asp="#unknown">
            CssClass="style1" AllowPaging="True" AlternatingRowStyle-CssClass="alt" PagerStyle-CssClass="pgr"
            Width="100%" ForeColor="Black" Height="298px" CellSpacing="1">
            <headerstyle backcolor="#993333" cssclass="dgHeaderStyle" font-bold="True" font-italic="False">
                Font-Overline="False" Font-Size="Medium" Font-Strikeout="False" Font-Underline="False" />
            <alternatingrowstyle cssclass="alt"></alternatingrowstyle>
            <columns>
                <asp:templatefield headertext="Treatments ID">
                    <itemtemplate>
                        <asp:label id="TID" runat="server" text="<%# Eval("TID") %>"></asp:label>
                    </itemtemplate>
                </asp:templatefield>
                <asp:templatefield headertext="Title">
                    <itemtemplate>
                        <asp:label id="Title" runat="server" text="<%# Eval("Title") %>"></asp:label>
                    </itemtemplate>
                </asp:templatefield>
                <asp:templatefield headertext="Description">
                    <itemtemplate>
                        <asp:label id="Description" runat="server" text="<%# Eval("Description") %>"></asp:label>
                    </itemtemplate>
                </asp:templatefield>
                <asp:templatefield>
                    <itemtemplate>
                        <asp:linkbutton id="HyperLinkDelete" runat="server" text="Delete" commandargument="<%# Eval("TID") %>">
                            CommandName="Vdelete" OnClientClick="return ConfirmOnDelete('');" />
                    </asp:linkbutton></itemtemplate>
                </asp:templatefield>
            </columns>
          
        </headerstyle></asp:gridview><pre lang="HTML">
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900