我想从OLEDB SQL Server获取数据并将其显示在网格视图中,我可以获取除图像之外的数据:
<asp:GridView ID="GridView1" runat="server" AllowPaging="True"
AutoGenerateColumns="False" DataSourceID="SqlDataSource1"
EnableModelValidation="True" Height="184px" Width="546px">
<Columns>
<asp:BoundField DataField="col_FirstName" HeaderText="col_FirstName"
SortExpression="col_FirstName" />
<asp:BoundField DataField="col_LastName" HeaderText="col_LastName"
SortExpression="col_LastName" />
<asp:BoundField DataField="col_age" HeaderText="col_age"
SortExpression="col_age" />
<asp:BoundField DataField="col_photo" HeaderText="col_photo"
SortExpression="col_photo" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>"
SelectCommand="SELECT [col_FirstName], [col_LastName], [col_age], [col_photo] FROM [tbl_PersonInfo_Test]">
</asp:SqlDataSource>`
您可以尝试使用此代码 - 基于 asp:ImageField
<asp:ImageField DataImageUrlField="col_photo"></asp:ImageField>
友情链接 : http://msdn.microsoft.com/en-us/library/aa479350.aspx
并替换此代码
<asp:BoundField DataField="col_photo" HeaderText="col_photo" SortExpression="col_photo" />
第二种解决方案 - 基于template field
<asp:TemplateField HeaderText="Status" ItemStyle-HorizontalAlign="Center">
<ItemTemplate>
<asp:Image ID="photo" runat="server" ImageUrl="<%# DataBinder.Eval(Container.DataItem, "col_photo")%>" />
</ItemTemplate>
</asp:TemplateField>
当您在数据库中使用二进制字段时,您可以创建一个简单的 imageHandler 类。此类知道如何从数据存储中加载图像并将其写入响应流。请参阅下面的一个非常粗略的示例。
图像处理程序.aspx
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["ID"] != null)
{
int id = Convert.ToInt32(Request.QueryString["ID"]);
// query your dataStorage for col_photo according to the current id
// ...
// access your binaryColumn
Byte[] bytes = (Byte[])dt.Rows[0]["col_photo"]; // adapt in case you use ExecuteScalar()
Response.Buffer = true;
Response.Charset = "";
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = "image/jpeg";
Response.BinaryWrite(bytes);
Response.Flush();
Response.End();
}
.ASPX
// don't forget to add the pkColumn to your select statement!!
<asp:ImageField DataImageUrlField="YOUR_PK_COLUMN"
DataImageUrlFormatString="imageHandler.aspx?ID={0}"
ControlStyle-Width="100" ControlStyle-Height="100"/>
您可以在网络上找到几个示例。请参阅在网格视图中显示图像或图像来自DBinGridView,或者直接询问Google先生。