在DATAGRID中显示图片[数据库中存入的是图片名称]
<%@ Page Language="VB" AutoEventWireup="True" Debug="true"%>
<%@ Import Namespace =Namespace="System.Data" %>
<%@ Import Namespace =Namespace="System.Data.OleDb" %>
<script runat="server">
dim MyConnection as OleDbConnection
Sub Page_Load()Sub Page_Load(sender As Object, e As EventArgs)
MyConnection = New OleDbConnection( "Provider=Microsoft.Jet.OLEDB.4.0; Data Source =" + Server.MapPath(".")+"/db/data.mdb")
If Not IsPostBack Then
BindGrid()
End If
End Sub
Sub MyDataGrid_Page()Sub MyDataGrid_Page(sender as Object, e As DataGridPageChangedEventArgs)
MyDataGrid.CurrentPageIndex = e.NewPageIndex
BindGrid()
End Sub
Sub BindGrid()Sub BindGrid()
Dim MyCommand As OleDbDataAdapter = new OleDbDataAdapter("SELECT * FROM [info]", MyConnection)
Dim DS As DataSet = new DataSet()
MyCommand.Fill(DS,"info")
MyDataGrid.DataSource = DS.Tables("info").DefaultView
MyDataGrid.DataBind()
End Sub
</script>
<form runat="server">
<asp:DataGrid id="MyDataGrid"
AllowPaging="True"
PageSize="5"
OnPageIndexChanged="MyDataGrid_Page"
runat="server"
AutoGenerateColumns="False"
Width="200">
<HeaderStyle BackColor="Navy"
ForeColor="White"
Font-Bold="True"
HorizontalAlign="Center"/>
<PagerStyle Mode="NextPrev"
HorizontalAlign="Right"
NextPageText="Next"
PrevPageText="Prev"/>
<Columns>
<asp:BoundColumn DataField="id" HeaderText="ID"/>
<asp:TemplateColumn HeaderText="">
<ItemTemplate>
<asp:Label ID="lblTitle" Text='<%#(Container.DataItem("title"))%>' Runat="server" />
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Picture">
<ItemTemplate>
<asp:Image id="image1" runat="server" AlternateText='<%#Container.DataItem("uploadpic")%>' ImageAlign="left" ImageUrl='<%#"uploadimages/" & Container.DataItem("uploadpic")%>'/>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Picture_2">
<ItemTemplate>
<img align="top" src='uploadimages/<%#DataBinder.Eval(Container.DataItem,"uploadpic").ToString()%>'>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
</asp:DataGrid>
</form>
<%@ Import Namespace =Namespace="System.Data" %>
<%@ Import Namespace =Namespace="System.Data.OleDb" %>
<script runat="server">
dim MyConnection as OleDbConnection
Sub Page_Load()Sub Page_Load(sender As Object, e As EventArgs)
MyConnection = New OleDbConnection( "Provider=Microsoft.Jet.OLEDB.4.0; Data Source =" + Server.MapPath(".")+"/db/data.mdb")
If Not IsPostBack Then
BindGrid()
End If
End Sub
Sub MyDataGrid_Page()Sub MyDataGrid_Page(sender as Object, e As DataGridPageChangedEventArgs)
MyDataGrid.CurrentPageIndex = e.NewPageIndex
BindGrid()
End Sub
Sub BindGrid()Sub BindGrid()
Dim MyCommand As OleDbDataAdapter = new OleDbDataAdapter("SELECT * FROM [info]", MyConnection)
Dim DS As DataSet = new DataSet()
MyCommand.Fill(DS,"info")
MyDataGrid.DataSource = DS.Tables("info").DefaultView
MyDataGrid.DataBind()
End Sub
</script>
<form runat="server">
<asp:DataGrid id="MyDataGrid"
AllowPaging="True"
PageSize="5"
OnPageIndexChanged="MyDataGrid_Page"
runat="server"
AutoGenerateColumns="False"
Width="200">
<HeaderStyle BackColor="Navy"
ForeColor="White"
Font-Bold="True"
HorizontalAlign="Center"/>
<PagerStyle Mode="NextPrev"
HorizontalAlign="Right"
NextPageText="Next"
PrevPageText="Prev"/>
<Columns>
<asp:BoundColumn DataField="id" HeaderText="ID"/>
<asp:TemplateColumn HeaderText="">
<ItemTemplate>
<asp:Label ID="lblTitle" Text='<%#(Container.DataItem("title"))%>' Runat="server" />
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Picture">
<ItemTemplate>
<asp:Image id="image1" runat="server" AlternateText='<%#Container.DataItem("uploadpic")%>' ImageAlign="left" ImageUrl='<%#"uploadimages/" & Container.DataItem("uploadpic")%>'/>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Picture_2">
<ItemTemplate>
<img align="top" src='uploadimages/<%#DataBinder.Eval(Container.DataItem,"uploadpic").ToString()%>'>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
</asp:DataGrid>
</form>