GridView Question
in [ASP .NET]
|
From: sjsean on 24 Jul 2010 20:34 If you have suggestions on how to display I'm all ears...just learning gridview, detailsview, etc. and not sure how to make them display data in "my" layout/format. Still accustomed to using asp classic. I have placed a gridview on my page and want it to display address information. However, sometimes the address information field in the database will be null and I don't want the page to show a blank space. Modified this from a page on the net, but it either shows all the information including the blank line or it shows nothing and all of this is depends on row.cells(0).visible = false Example: Name address1 address2 city, state zip telephone for the most part address 2 would be blank/null so it should "hide". Protected Sub GridView1_DataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles GridView1.DataBound Dim row As GridViewRow For Each row In GridView1.Rows If String.IsNullOrEmpty(row.Cells(0).Text) Then row.Cells(0).Visible = False End If Exit Sub Next End Sub <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" GridLines="None"> <Columns> <asp:TemplateField> <ItemTemplate> <b><asp:Label ID="Label4" runat="server" Text='<%# Bind("location_nickname") %>'></asp:Label></b><br /> <asp:Label ID="Label5" runat="server" Text='<%# Bind("location_add1") %>'></asp:Label><br /> <asp:Label ID="Label6" runat="server" Text='<%# Bind("location_add2") %>'></asp:Label><br /> <asp:Label ID="Label1" runat="server" Text='<%# Bind("location_city") %>'></asp:Label>, <asp:Label ID="Label2" runat="server" Text='<%# Bind("location_state") %>'></asp:Label><br /> <asp:Label ID="Label3" runat="server" Text='<%# Bind("location_zip") %>'></asp:Label><br /> </ItemTemplate> </asp:TemplateField> </Columns> </asp:GridView>
From: mick0987b on 26 Jul 2010 17:17 Not tested this but something like this in your label should work: Visible='<%# Not(Eval("location_add2") is DBNull.Value)%>' On Jul 25, 1:34 am, sjsean <sjsean95...(a)gmail.com> wrote: > If you have suggestions on how to display I'm all ears...just learning > gridview, detailsview, etc. and not sure how to make them display data > in "my" layout/format. Still accustomed to using asp classic. > > I have placed a gridview on my page and want it to display address > information. However, sometimes the address information field in the > database will be null and I don't want the page to show a blank space. > > Modified this from a page on the net, but it either shows all the > information including the blank line or it shows nothing and all of > this is depends on row.cells(0).visible = false > > Example: > > Name > address1 > address2 > city, state zip > telephone > > for the most part address 2 would be blank/null so it should "hide". > > Protected Sub GridView1_DataBound(ByVal sender As Object, ByVal e > As System.EventArgs) Handles GridView1.DataBound > Dim row As GridViewRow > For Each row In GridView1.Rows > > If String.IsNullOrEmpty(row.Cells(0).Text) Then > row.Cells(0).Visible = False > > End If > Exit Sub > Next > End Sub > > <asp:GridView ID="GridView1" runat="server" > AutoGenerateColumns="False" > DataSourceID="SqlDataSource1" GridLines="None"> > <Columns> > <asp:TemplateField> > > <ItemTemplate> > <b><asp:Label ID="Label4" runat="server" Text='<%# > Bind("location_nickname") %>'></asp:Label></b><br /> > <asp:Label ID="Label5" runat="server" Text='<%# > Bind("location_add1") %>'></asp:Label><br /> > <asp:Label ID="Label6" runat="server" Text='<%# > Bind("location_add2") %>'></asp:Label><br /> > <asp:Label ID="Label1" runat="server" Text='<%# > Bind("location_city") %>'></asp:Label>, > <asp:Label ID="Label2" runat="server" Text='<%# > Bind("location_state") %>'></asp:Label><br /> > <asp:Label ID="Label3" runat="server" Text='<%# > Bind("location_zip") %>'></asp:Label><br /> > </ItemTemplate> > > </asp:TemplateField> > </Columns> > </asp:GridView>
|
Pages: 1 Prev: Help About URL Rewriting Next: Site integration--Reverse Proxy |