中科新闻网微店下单骗局:++高手请赐教asp.net中datagrid的格式问题
来源：百度文库 编辑：中科新闻网 时间：2024/04/28 15:57:07
我用的vb.net版的，想用datagrid在网页中显示留言本 把数据库中的不同字段在网页中用表格来显示出来 问题是：如果我想让库中姓名为空的字段，在网页中隐藏 例如第一条留言姓名为空，则隐藏它 该怎么在代码中编写？？？ 如有哪位大哥回答上来，赏100分，绝不食言 我的QQ：120568194
原代码如下：
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script language="VB" runat="server">
Sub BindList()
Dim SqlString as String = "Select * From guest_book"
Dim ConnString as String = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" &
Server.MapPath("#Guestbook.mdb")
Dim ObjCmd as New OleDbDataAdapter(SqlString, ConnString)
Dim DS As New DataSet()
ObjCmd.Fill(DS, "guest_book")
myDataGrid.DataSource = DS
myDataGrid.DataBind()
End Sub
Sub Page_load(Sender As Object,e As Eventargs)
if Not IsPostBack Then BindList()
End Sub
Sub DataGrid_PageChanged(Sender As Object,e As DataGridPageChangedEventargs)
myDataGrid.CurrentPageIndex = e.NewPageIndex
BindList()
End Sub
</script>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>留言本</title>
</head>
<body>
<form runat="server">
<asp:datagrid runat="server" ID="mydatagrid" AutoGenerateColumns="false"
AllowPaging="true" PageSize="5" Width="600"
HorizontalAlign="Center" OnPageIndexChanged="DataGrid_PageChanged">
<PagerStyle HorizontalAlign="Center" Mode="numericPages" backcolor="#ffffcc"/>
<Columns>
<asp:TemplateColumn>
<headerTemplate>
<table id="mydatagrid_table" cellpadding="0" cellspacing="0">
</headerTemplate>
<ItemTemplate>
<tr align="left"><td>标题：<%# Container.DataItem("subject") %></td></tr>
<tr>
<td>留言人：<%# Container.DataItem("name") %></td>
<td><img alt="留言时间" src="images/date.gif"><%# Container.DataItem("date") %></td>
</tr>
<tr>
<td><img src="images/<%# Container.DataItem("image") %>" alt="形象照片"></td>
<td>
<%# Container.DataItem("content") %>
</td>
</tr>
</ItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:TemplateColumn>
</Columns>
</asp:datagrid>
</form>
</body>
</html>
原代码如下：
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script language="VB" runat="server">
Sub BindList()
Dim SqlString as String = "Select * From guest_book"
Dim ConnString as String = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" &
Server.MapPath("#Guestbook.mdb")
Dim ObjCmd as New OleDbDataAdapter(SqlString, ConnString)
Dim DS As New DataSet()
ObjCmd.Fill(DS, "guest_book")
myDataGrid.DataSource = DS
myDataGrid.DataBind()
End Sub
Sub Page_load(Sender As Object,e As Eventargs)
if Not IsPostBack Then BindList()
End Sub
Sub DataGrid_PageChanged(Sender As Object,e As DataGridPageChangedEventargs)
myDataGrid.CurrentPageIndex = e.NewPageIndex
BindList()
End Sub
</script>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>留言本</title>
</head>
<body>
<form runat="server">
<asp:datagrid runat="server" ID="mydatagrid" AutoGenerateColumns="false"
AllowPaging="true" PageSize="5" Width="600"
HorizontalAlign="Center" OnPageIndexChanged="DataGrid_PageChanged">
<PagerStyle HorizontalAlign="Center" Mode="numericPages" backcolor="#ffffcc"/>
<Columns>
<asp:TemplateColumn>
<headerTemplate>
<table id="mydatagrid_table" cellpadding="0" cellspacing="0">
</headerTemplate>
<ItemTemplate>
<tr align="left"><td>标题：<%# Container.DataItem("subject") %></td></tr>
<tr>
<td>留言人：<%# Container.DataItem("name") %></td>
<td><img alt="留言时间" src="images/date.gif"><%# Container.DataItem("date") %></td>
</tr>
<tr>
<td><img src="images/<%# Container.DataItem("image") %>" alt="形象照片"></td>
<td>
<%# Container.DataItem("content") %>
</td>
</tr>
</ItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:TemplateColumn>
</Columns>
</asp:datagrid>
</form>
</body>
</html>