Conditionally display columns in a datagrid

rennilmoksa · Apr 28, 2012

I have a datagrid which displays the results of a criteria typed into a search engine. One of the columns is is the URL of the page matched to the criteria. Some of these will be pages are just flat text files which are usually loaded into a content area of a template file. Others are pages which can be directly linked to. So I need to place an 'IF' statement somewhere to say 'if this URL is a flat text file then load another.aspx?file=matchedURL' otherwise just display the matched URL. And the another.aspx file will load the text into the content area. The question is where do you place the conditional statement? It can't be done inline as such code is not accepted there. Is it done prior to binding? Or do you override one of the render methods of the page class? I'm a little confused..... Here's the datagrid code <asp

ataGrid id="SearchGrid" AutoGenerateColumns="false" PageSize="10" AllowPaging="true" Width="585" CellSpacing="0" CellPadding="0" BorderColor="#cccccc" BorderWidth="0" Font-Name="Verdana" Font-Size="9pt" OnPageIndexChanged="PageIndex_Changed" runat="server"> <PagerStyle Mode="NumericPages" Font-Bold="true"/> <HeaderStyle Font-Bold="true" BackColor="#f3f3f3" ForeColor="#990000"/> <ItemStyle VerticalAlign="top"/> <FooterStyle BackColor="#cccccc"/> <Columns> <asp:BoundColumn DataField="RANK" DataFormatString="{0,-2:##0.#}%" HeaderText="Rank"> <ItemStyle Width="70"/> </asp:BoundColumn> <asp:TemplateColumn HeaderText="Document information"> <ItemStyle Width="515"/> <ItemTemplate> <a href=http://aspmessageboard.com/archive/index.php/"<%# DataBinder.Eval(Container, "DataItem.VPath")%>"> <%# DataBinder.Eval(Container, "DataItem.DocTitle") %></a> <%# DataBinder.Eval(Container, "DataItem.Characterization")%>... <a href="http://<%=Request.ServerVariables["SERVER_NAME"].Trim()%> <%# DataBinder.Eval(Container, "DataItem.VPath")%>" style="word-wrap: break-word;"> http://<%=Request.ServerVariables["SERVER_NAME"].Trim()%><%# DataBinder.Eval(Container, "DataItem.VPath")%> </a> Last modified: <%# DataBinder.Eval(Container, "DataItem.Write")%> </ItemTemplate> </asp:TemplateColumn> </Columns> </asp

ataGrid>It sounds like you could use the onItemDataBound event.....this only allows me to use a particular value in the datagrid eleswhere not actually conditionally change the value in the datagrid when it is displayed anyone got any ideas?This is just an Idea and Also PSEUDOCODE, but may orientate you, Try something like: ------------------------------------ Sub Analyse_procedure (Arguments..) Dim anString As String Dim SqlQuery As String Dim RowCounter As Integer SqlQuery="select RowCount into RowCounter from yourTable where YourLinkField='<a href=*'>" Open Conexion Execute Command (SqlQueryInto, conexion) Close Conexion If RowCounter>0 then go to aspxPage1 else go to aspxPage2 End If End Sub ------------------------------------ I Hope it is useful, Salvador Gallego.thanks but thats not reall what I'm after... what I want to do is check if the value in <%# DataBinder.Eval(Container, "DataItem.VPath")%> contains this string '/news/news_arti/'. If it does I want to build a href="1.aspx?q=DataBinder.Eval(Container, "DataItem.VPath", if not then just build <a href="<%# DataBinder.Eval(Container, "DataItem.VPath")%>" now I realise thsat kind of processing doesn't work it was just to demonstrate what Im trying to do. Use a datatable and create rows with the same binding value. when you are building your rows only add the ones that meet your requirement: Dim conn As New SqlConnection(Application.Item("conn")) Dim com As SqlCommand Dim sql As String Dim dt As DataTable Dim drow As DataRow Dim dc As DataColumn Dim dr As SqlDataReader sql = "SELECT string FROM string_table" com = New SqlCommand(sql, conn) conn.Open() dr = com.ExecuteReader dt = New DataTable("table") dc = New DataColumn("name", GetType(String)) dt.Columns.Add("name") dim dval as string Try While dr.Read dval = dr.GetString(3) If instr(dval) > 0 Then drow = dt.NewRow() drow("name") = dval End If End While dg.DataSource = dt dg.DataBind() Catch Response.Write("There was an error: ") Response.Write(Err.Description) Response.Write(" SQL Statement:" & sql) End Try conn.Close() conn.Dispose() com.Dispose() In your aspx page: <%# DataBinder.Eval(Container, "DataItem.name")%>

Conditionally display columns in a datagrid

rennilmoksa

New Member