更新时间:2023-11-18 15:40:58
Gridview具有名为EmptyDataText的属性..将其设置为您要显示的任何消息...
Gridview has property called EmptyDataText .. set it to whatever message you want to display...
<asp:gridview id="grdViewKeyType" runat="server" allowpaging="True" autogeneratecolumns="False" xmlns:asp="#unknown">
BackColor="White" BorderColor="#999999" BorderStyle="Solid"
CellPadding="5" CellSpacing="1"
CssClass="Grid"
EmptyDataText="No Records found"
....
</asp:gridview>
请参阅gridview中空数据模板的以下链接
http://msdn.microsoft.com/en-us/library/syst em.web.ui.webcontrols.gridview.emptydatatemplate.aspx [ ^ ]
see below link for empty data template in gridview
http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.gridview.emptydatatemplate.aspx[^]
你有另一个数据表选项,
you have another option with datatable,
DataTable dt = new DataTable();
try
{
Con_Open();
cmd = new SqlCommand("select * from Stu", con);
dr = cmd.ExecuteReader();
if (dr.HasRows)
{
dt.Columns.Add(new DataColumn("Reg No"));
dt.Columns.Add(new DataColumn("Name"));
dt.Columns.Add(new DataColumn("Mark1"));
dt.Columns.Add(new DataColumn("Mark2"));
dt.Columns.Add(new DataColumn("Mark3"));
while (dr.Read())
{
DataRow temp;
temp = dt.NewRow();
temp[0] = (System.Convert.IsDBNull(dr[0]) ? "" : dr[0].ToString());
temp[1] = (System.Convert.IsDBNull(dr[1]) ? "" : dr[1].ToString());
temp[2] = (System.Convert.IsDBNull(dr[2]) ? "" : dr[2].ToString());
temp[3] = (System.Convert.IsDBNull(dr[3]) ? "" : dr[3].ToString());
temp[4] = (System.Convert.IsDBNull(dr[4]) ? "" : dr[4].ToString());
dt.Rows.Add(temp);
}
cmd.Dispose();
dr.Close();
con.Close();
}
else
{
dt.Columns.Add(new DataColumn("Records"));
DataRow temp;
temp = dt.NewRow();
temp[0] = "No Records Found!!";
dt.Rows.Add(temp);
}
}
问候
sarva
regards
sarva
>