图片显示链接,image类型 如题,数据库中是image类型,在aspx用什么控件将来显示出来,并且还可以用于链接? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 但是数据库中的数据类型是image,如何将它显示出来呢?有没有例子可以参与一下呀? 这个取决于你的Image中到底存放的是什么内容,如果是图片,网上从数据库读取图片的资料很多,如果是声音视频的话,要用其他的方法! SqlConnection con = new SqlConnection(constr.getCon()); con.Open(); SqlCommand cmd = new SqlCommand("insert into organ.organ values(@name ,@photo)", con); cmd.Parameters.AddWithValue("@name", name); //操作图片 Stream ms; byte[] picbyte = null; try { if ((ms = this.openFileDialog1.OpenFile()) != null) { //MessageBox.Show("ok"); picbyte = new byte[ms.Length]; ms.Position = 0; ms.Read(picbyte, 0, Convert.ToInt32(ms.Length)); } } catch { picbyte=new byte[10];} cmd.Parameters.AddWithValue("@photo", picbyte); if (cmd.ExecuteNonQuery() == 1) result = true; con.Close(); 不知道你在数据库里保存的图片,是以什么方式保存的。如果是以路径保存的话,只的直接读就可以了,用dataset直接读就可以了 <%@ Page Language="vb" Debug="true" %><%@ Import Namespace="System.Data" %><%@ Import Namespace="System.Data.OleDb" %><script language="VB" runat="server"> dim MyConnection As OleDbConnection Sub Page_Load(s As Object, E As EventArgs) MyConnection = New OleDbConnection( "Provider=Microsoft.Jet.OLEDB.4.0; Data Source =" + Server.MapPath(".")+"/db/kk.mdb") If Not (IsPostBack) then BindDataGrid() End If End SubSub BindDataGrid() dim dadTitles as OleDbDataAdapter dim dstTitles as DataSet dadTitles=new OleDbDataAdapter("select * from [imgs] order by id desc",MyConnection) dstTitles=new DataSet dadTitles.fill(dstTitles) MyDataGrid.DataSource=dstTitles MyDataGrid.DataBind()End SubSub Mydatagrid_PageIndexChanged(s as object,e as DataGridPageChangedEventargs) MyDataGrid.CurrentPageIndex=e.newPageIndex BindDataGrid()End SubFunction FormatURL(strArgument) as String Return ("RetrieveImgByDataGrid_SelectImg.aspx?id=" & strArgument)End Function</script><html><head><title>DataGrid_CheckBox.aspx</title></head><body><B><A HREF="insertimgtodatabase.aspx">Insert Img To DataBase</A></B><form runat="server"><asp:DataGrid id="MyDataGrid" width="300" Runat="server" AllowPaging="true" pageSize="5" OnPageIndexChanged="Mydatagrid_PageIndexChanged" cellPadding="3" AutoGenerateColumns="false" HeaderStyle-BackColor="#ff0000" HeaderStyle-Font-Bold="True" HeaderStyle-Font-Name="Verdana" HeaderStyle-Font-Size="13px" HeaderStyle-ForeColor="#ffffff" ItemStyle-BackColor=Beige ItemStyle-Font-Name="verdana" ItemStyle-Font-Size="13px" > <PagerStyle Mode="NumericPages" Font-Bold="true" BackColor="#FFCC99" HorizontalAlign="right" > </PagerStyle> <Columns> <asp:TemplateColumn HeaderText="ID"> <ItemTemplate> <asp:Label ID="lblID" Text='<%# DataBinder.Eval(Container.DataItem, "id") %>' Runat=server /> </ItemTemplate> </asp:TemplateColumn> <asp:TemplateColumn HeaderText="NAME"> <ItemTemplate> <asp:Label ID="lblName" Text='<%# DataBinder.Eval(Container.DataItem, "name") %>' Runat=server /> </ItemTemplate> </asp:TemplateColumn> <asp:TemplateColumn HeaderText="Image"> <ItemTemplate> <asp:Image Width="150" Height="125" ImageUrl='<%# FormatURL(DataBinder.Eval(Container.DataItem, "ID")) %>' Runat=server /> </ItemTemplate> </asp:TemplateColumn> <asp:TemplateColumn HeaderText="ShowImage_HyperLink"> <ItemTemplate> <asp:HyperLink Width="150" Height="125" ImageUrl='<%# FormatURL(DataBinder.Eval(Container.DataItem, "ID")) %>' NavigateUrl='<%# "RetrieveImgByDataGrid_SelectImg.aspx?id=" & DataBinder.Eval(Container.DataItem, "ID")%>' Runat="server" /> </ItemTemplate> </asp:TemplateColumn> </Columns></asp:DataGrid></form></body></html> sqldatasource ,gridview,detailview,几个控件就可以实现 现在有人在吗- -! url重写问题 怎样根据两个文本框textbox的值,读出相应的记录。谢谢! 做下载时如何禁止使用下载工具??? 如何在页面上直接显示word文档中的内容,包括文字和图表,谢谢! textbox输入验证的问题 颜色转换 asp.net中关于treeview控件的问题,求助 那有vs2003.net msdn下载啊,急啊,谢谢。100分 如何在网页中显示DOC文件 Repeater,DataGril,DataList 中数据可以横着显示吗? 新装的出现这个错,请大家帮忙看一下,谢谢 求人写个.NET存储过程 我不知道从哪下手...
con.Open();
SqlCommand cmd = new SqlCommand("insert into organ.organ values(@name ,@photo)", con);
cmd.Parameters.AddWithValue("@name", name);
//操作图片
Stream ms;
byte[] picbyte = null;
try
{
if ((ms = this.openFileDialog1.OpenFile()) != null)
{
//MessageBox.Show("ok");
picbyte = new byte[ms.Length];
ms.Position = 0;
ms.Read(picbyte, 0, Convert.ToInt32(ms.Length)); }
}
catch { picbyte=new byte[10];} cmd.Parameters.AddWithValue("@photo", picbyte);
if (cmd.ExecuteNonQuery() == 1)
result = true;
con.Close();
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script language="VB" runat="server">
dim MyConnection As OleDbConnection Sub Page_Load(s As Object, E As EventArgs)
MyConnection = New OleDbConnection( "Provider=Microsoft.Jet.OLEDB.4.0; Data Source =" + Server.MapPath(".")+"/db/kk.mdb")
If Not (IsPostBack) then
BindDataGrid()
End If
End SubSub BindDataGrid()
dim dadTitles as OleDbDataAdapter
dim dstTitles as DataSet
dadTitles=new OleDbDataAdapter("select * from [imgs] order by id desc",MyConnection)
dstTitles=new DataSet
dadTitles.fill(dstTitles)
MyDataGrid.DataSource=dstTitles
MyDataGrid.DataBind()
End SubSub Mydatagrid_PageIndexChanged(s as object,e as DataGridPageChangedEventargs)
MyDataGrid.CurrentPageIndex=e.newPageIndex
BindDataGrid()
End SubFunction FormatURL(strArgument) as String
Return ("RetrieveImgByDataGrid_SelectImg.aspx?id=" & strArgument)
End Function</script>
<html>
<head><title>DataGrid_CheckBox.aspx</title></head>
<body>
<B><A HREF="insertimgtodatabase.aspx">Insert Img To DataBase</A></B>
<form runat="server">
<asp:DataGrid id="MyDataGrid"
width="300"
Runat="server"
AllowPaging="true"
pageSize="5"
OnPageIndexChanged="Mydatagrid_PageIndexChanged"
cellPadding="3"
AutoGenerateColumns="false"
HeaderStyle-BackColor="#ff0000"
HeaderStyle-Font-Bold="True"
HeaderStyle-Font-Name="Verdana"
HeaderStyle-Font-Size="13px"
HeaderStyle-ForeColor="#ffffff"
ItemStyle-BackColor=Beige
ItemStyle-Font-Name="verdana"
ItemStyle-Font-Size="13px"
>
<PagerStyle Mode="NumericPages"
Font-Bold="true"
BackColor="#FFCC99"
HorizontalAlign="right"
>
</PagerStyle>
<Columns>
<asp:TemplateColumn HeaderText="ID">
<ItemTemplate>
<asp:Label ID="lblID" Text='<%# DataBinder.Eval(Container.DataItem, "id") %>' Runat=server />
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="NAME">
<ItemTemplate>
<asp:Label ID="lblName" Text='<%# DataBinder.Eval(Container.DataItem, "name") %>' Runat=server />
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Image">
<ItemTemplate>
<asp:Image Width="150" Height="125" ImageUrl='<%# FormatURL(DataBinder.Eval(Container.DataItem, "ID")) %>' Runat=server />
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="ShowImage_HyperLink">
<ItemTemplate>
<asp:HyperLink Width="150" Height="125" ImageUrl='<%# FormatURL(DataBinder.Eval(Container.DataItem, "ID")) %>' NavigateUrl='<%# "RetrieveImgByDataGrid_SelectImg.aspx?id=" & DataBinder.Eval(Container.DataItem, "ID")%>' Runat="server" />
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
</asp:DataGrid>
</form>
</body>
</html>