Every thing seems correct but blank in web page. not showing Grid view values
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();
}
}
<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;
}