在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> 
posted on 2005-04-29 10:46  №阿儒№  阅读(618)  评论(0编辑  收藏  举报