On Feb 18, 4:31 pm, "Jonathan" <n...@none.com> wrote:
> In one of the 4 output columns of my Datagrid, I have a Yes/No Boolean
> field.
>
> I'd like to show a graphical tick (e.g. tick.jpg) or a cross e.g.
> (cross.jpg) instead of True/False or Yes/No.
>
> How could I do that? Here's the code:
>
> </head>
>
> <%@ Page language="VB" Debug="true" %>
> <%@ Import Namespace="System.Data" %>
> <%@ Import Namespace="System.Data.OleDb" %>
>
> <script language="VB" runat="server">
>
> Sub Page_Load(Sender as Object, E as EventArgs)
>
> Dim oConn As OleDbConnection
> Dim oComm As OleDbDataAdapter
> Dim sConn As String
> Dim sComm As String
> Dim oDataSet As New DataSet
>
> 'Build the connection string
> sConn = "Provider=Microsoft.Jet.OLEDB.4.0;"
> sConn += "Data Source=D:\inetpub\www\mysite\myaccessdb.mdb;"
> sConn += "Persist Security Info=False"
>
> 'Build the SQL string
> sComm = "SELECT qryDataGrid01.* "
> sComm += "FROM qryDataGrid01;"
>
> 'Create the connection and command objects
> oConn = New OleDbConnection(sConn)
> oComm = New OleDbDataAdapter(sComm, oConn)
>
> 'Fill the dataset with the results of the query
> oComm.Fill(oDataSet, "qryDataGrid01")
>
> 'Set the grid source to the dataset and bind the data
> oGrid.DataSource=oDataSet.Tables("qryDataGrid01").DefaultView
> oGrid.DataBind()
>
> End Sub
> </script>
>
> <asp:DataGrid runat="server" id="oGrid" BackColor="#eeeeee"
> HorizontalAlign="Left">
> <HeaderStyle Font-Bold="True"/>
> <AlternatingItemStyle BackColor="White" />
> </asp:datagrid>

On Feb 18, 5:31 am, "Jonathan" <n...@none.com> wrote:
> In one of the 4 output columns of my Datagrid, I have a Yes/No Boolean
> field.
>
> I'd like to show a graphical tick (e.g. tick.jpg) or a cross e.g.
> (cross.jpg) instead of True/False or Yes/No.
>
> How could I do that? Here's the code:
>
> </head>
>
> <%@ Page language="VB" Debug="true" %>
> <%@ Import Namespace="System.Data" %>
> <%@ Import Namespace="System.Data.OleDb" %>
>
> <script language="VB" runat="server">
>
> Sub Page_Load(Sender as Object, E as EventArgs)
>
> Dim oConn As OleDbConnection
> Dim oComm As OleDbDataAdapter
> Dim sConn As String
> Dim sComm As String
> Dim oDataSet As New DataSet
>
> 'Build the connection string
> sConn = "Provider=Microsoft.Jet.OLEDB.4.0;"
> sConn += "Data Source=D:\inetpub\www\mysite\myaccessdb.mdb;"
> sConn += "Persist Security Info=False"
>
> 'Build the SQL string
> sComm = "SELECT qryDataGrid01.* "
> sComm += "FROM qryDataGrid01;"
>
> 'Create the connection and command objects
> oConn = New OleDbConnection(sConn)
> oComm = New OleDbDataAdapter(sComm, oConn)
>
> 'Fill the dataset with the results of the query
> oComm.Fill(oDataSet, "qryDataGrid01")
>
> 'Set the grid source to the dataset and bind the data
> oGrid.DataSource=oDataSet.Tables("qryDataGrid01").DefaultView
> oGrid.DataBind()
>
> End Sub
> </script>
>
> <asp:DataGrid runat="server" id="oGrid" BackColor="#eeeeee"
> HorizontalAlign="Left">
> <HeaderStyle Font-Bold="True"/>
> <AlternatingItemStyle BackColor="White" />
> </asp:datagrid>

"Jonathan" <none@none.com> wrote in message news:fpbmta$vak$1@aioe.org...

> In one of the 4 output columns of my Datagrid,

> I'd like to show a graphical tick (e.g. tick.jpg) or a cross e.g.
> (cross.jpg) instead of True/False or Yes/No.

> sConn += "Data Source=D:\inetpub\www\mysite\myaccessdb.mdb;"