会员
众包
新闻
博问
闪存
赞助商
HarmonyOS
Chat2DB
所有博客
当前博客
我的博客
我的园子
账号设置
会员中心
简洁模式
...
退出登录
注册
登录
着迷Linux
菲一打
在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
>
发表于
2004-11-20 09:42
菲一打
阅读(
1379
) 评论(
0
)
收藏
举报
刷新页面
返回顶部
公告
导航
博客园
首页
新随笔
新文章
联系
订阅
管理