且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

找不到记录消息

更新时间: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

>