Datagrid - include jpegs

[Jonathan]

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>

[Mark Rae [MVP]]

"Jonathan" <no**@none.comwrote in message news:fp**********@aioe.org...

In one of the 4 output columns of my Datagrid,

DataGrid? Are you still using Visual Studio.NET 2003...?

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.

http://authors.aspalliance.com/aspxt...odatagrid.aspx

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

Surely not...? The above implies that your database is in your website's
virtual root, meaning that it is fully accessible through a browser:

http://www.mysite.com/myaccessdb.mdb
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[Masudur]

On Feb 18, 4:31 pm, "Jonathan" <[e-mail]:

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>

Hi...

You can change your column's item template and add a image in item
template...
next in item data bound depenting on your data value change source of
the image...

please take a look at this section...
http://www.asp.net/learn/data-access/#formatting

Thanks
Md. Masudur Rahman
www.munna.shatkotha.com
www.kaz.com.bd

[gnewsgroup]

On Feb 18, 5:31 am, "Jonathan" <[e-mail]:

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>

If you *can* use ASP.NET 2.0, you can use the ImageField property of
GridView. An example is available here:

http://authors.aspalliance.com/aspxt...Field.aspx.src

Also, as Mark has pointed out, your database is located in your web
folder and can be directly downloaded, which needs to be fixed.