如何在另一个位置的Gridview中显示照片!!! [英] How Do I Show A Photo In The Gridview From Another Location !!!

问题描述

我有一个从我的sql server数据库填充的gridview。

注意：我在asp.net端绑定我的数据库而不是在C＃中绑定（代码隐藏）



i有2个表即

1：公司表

2：图像表



在图像表中每个img都有一个唯一的id，每个公司表都有field有一个img_ref字段，它在图像表中显示其特定图像。



我用我的两个表中的左连接填充了我的gridview。



打开图像的方法是调用.aspx文件，我的图像打开如下：



www.MyWeb.com/readAttachment.aspx?Code=aaaaa&ID=1



readAttachment.aspx文件在我的root中，我的gridview在我的/公司/添加目录。



现在我想使用我公司表中的代码和ID打开我的图像。



我的asp.net代码是：

Hi , i have an gridview which has filled from my sql server data base .
note : i bind my database in asp.net side and not in C# ( code behind )

i have 2 tables i.e
1: company table
2: image table

at image table each img has an unique id and at companytable each field has one img_ref field which reffer to its specific image at image Table .

i filled my gridview using a left join from my both tables .

my method for opening images is to call an .aspx file ant my image open like below :

www.MyWeb.com/readAttachment.aspx?Code=aaaaa&ID=1

The readAttachment.aspx file is in my root and my gridview is in my /company/add directory .

now i want to open my images using my Code and ID from my Company Table .

my asp.net code is :

<pre lang="xml"><asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ChiCarDariConnectionString1 %>" ProviderName="<%$ ConnectionStrings:ChiCarDariConnectionString1.ProviderName %>" SelectCommand="select Company.Fld_id as Fld_id,Company.Fld_Uploader as Fld_Uploader,Company.Fld_Name as Fld_Name,Company.Fld_Date as Fld_Date,Img.Fld_RandCode as Fld_RandCode from tbl_Company as Company left join tbl_Img as Img on Company.Fld_ImgRef = img.Fld_id"></asp:SqlDataSource>
<asp:GridView CssClass="GridComapny" ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource2" EmptyDataText="There are no data records to display." BackColor="White" BorderColor="#999999" BorderStyle="Solid" BorderWidth="1px" CellPadding="3" ForeColor="Black" GridLines="Vertical">
<AlternatingRowStyle BackColor="#CCCCCC" />
<RowStyle Height="100px" />

<Columns>
    <asp:TemplateField>
        <ItemTemplate>
            <asp:Image ID="Image1" ImageUrl="../../ReadAttachment.aspx?code={???}&id={???}" runat="server" />
        </ItemTemplate>
    </asp:TemplateField>
    <asp:TemplateField HeaderText="#" ItemStyle-CssClass="Company_Grid_Checkbox">
    <ItemTemplate>
        <asp:CheckBox ID="chkRow" runat="server" />
    </ItemTemplate>
    <HeaderStyle Width="10%" />
    </asp:TemplateField>
    <asp:BoundField DataField="Fld_id" HeaderText="شماره" ReadOnly="True" SortExpression="Fld_id" />
    <asp:HyperLinkField HeaderText="آپلود کننده" DataNavigateUrlFields="Fld_RandCode,Fld_id" DataTextField="Fld_Uploader" DataNavigateUrlFormatString="Company_Add.aspx?Code={0}&id={1}" />
    <asp:HyperLinkField HeaderText="تاریخ آپلود" DataNavigateUrlFields="Fld_RandCode,Fld_id" DataTextField="Fld_Date" DataNavigateUrlFormatString="Company_Add.aspx?Code={0}&id={1}" />
    <asp:

ImageField DataImageUrlField =HeaderText = تصویرSortExpression =Fld_pat h/>

< asp：HyperLinkField HeaderText =نامDataNavigateUrlFields =Fld_RandCode，Fld_idDataTextField =Fld_NameDataNavigateUrlFormatString =Company_Add.aspx？Code = {0}& id = {1}/>



< /列>







我知道它有点复杂但我已经工作了大约1周但仍然没有得到我的适当结果:(





谢谢大家。

ImageField DataImageUrlField="" HeaderText="تصویر" SortExpression="Fld_path" />
<asp:HyperLinkField HeaderText="نام" DataNavigateUrlFields="Fld_RandCode,Fld_id" DataTextField="Fld_Name" DataNavigateUrlFormatString="Company_Add.aspx?Code={0}&id={1}" />

</Columns>



I know its a bit complicated but i have been working on it about 1 week and still didnt get my appropriate result :(


Thank you all .

推荐答案

ConnectionStrings：ChiCarDariConnectionString1％> ProviderName = <％

ConnectionStrings:ChiCarDariConnectionString1 %>" ProviderName="<%

ConnectionStrings：ChiCarDariConnectionString1.ProviderName％> SelectCommand = 选择Company.Fld_id为Fld_id，Company.Fld_Uploader为Fld_Uploader，Company.Fld_Name为Fld_Name，Company.Fld_Date为Fld_Date，Img.Fld_RandCode为来自tbl_Company的Fld_RandCode，公司左边连接tbl_Img为Img on Company。 Fld_ImgRef = img.Fld_id > < / asp：SqlDataSource >
< asp：GridView CssClass = GridComapny ID = GridView1 < span class =code-attribute> runat = 服务器 AutoGenerateColumns = False DataSourceID = SqlDataSource2 EmptyDataText = 没有要显示的数据记录。 BackColor = 白色 BorderColor = ＃999999 BorderStyle = Solid BorderWidth = 1px CellPadding = 3 ForeColor = 黑色 GridLines = 垂直 >
< AlternatingRowStyle BackColor = ＃CCCCCC / >
< RowStyle 高度 = 100px / >

< 列 >
< < span class =code-leadattribute> asp：TemplateField >
< ItemTemplate >
< asp：Image ID = Image1 ImageUrl = ../../ReadAttachment.aspx?code={???}&id={???}\" runat = server / >
< / ItemTemplate >
< / asp：TemplateField >
< asp：TemplateField HeaderText = ＃ ItemStyle-CssClass = Company_Grid_Checkbox >
< < span class =code-leadattribute> ItemTemplate >
< asp：CheckBox ID = chkRow runat = server / >
< / ItemTemplate >
< HeaderStyle 宽度 = 10％ / >
< / asp：TemplateField >
< asp：BoundField DataField = Fld_id HeaderText = شماره ReadOnly = True SortExpression = Fld_id / >
< asp：HyperLinkField HeaderText = آپلودکننده DataNavigateUrlFields = Fld_RandCode，Fld_id DataTextField = Fld_Uploader < span class =code-attribute> DataNavigateUrlFormatString = Company_Add.aspx？代码= {0}& id = {1} / >
< asp：HyperLinkField HeaderText = DataNavigateUrlFields = Fld_RandCode，Fld_id DataTextField = Fld_Date DataNavigateUrlFormatString = Company_Add.aspx？Code = {0}& id = {1} / > ;
< asp：

ConnectionStrings:ChiCarDariConnectionString1.ProviderName %>" SelectCommand="select Company.Fld_id as Fld_id,Company.Fld_Uploader as Fld_Uploader,Company.Fld_Name as Fld_Name,Company.Fld_Date as Fld_Date,Img.Fld_RandCode as Fld_RandCode from tbl_Company as Company left join tbl_Img as Img on Company.Fld_ImgRef = img.Fld_id"></asp:SqlDataSource> <asp:GridView CssClass="GridComapny" ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource2" EmptyDataText="There are no data records to display." BackColor="White" BorderColor="#999999" BorderStyle="Solid" BorderWidth="1px" CellPadding="3" ForeColor="Black" GridLines="Vertical"> <AlternatingRowStyle BackColor="#CCCCCC" /> <RowStyle Height="100px" /> <Columns> <asp:TemplateField> <ItemTemplate> <asp:Image ID="Image1" ImageUrl="../../ReadAttachment.aspx?code={???}&id={???}" runat="server" /> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="#" ItemStyle-CssClass="Company_Grid_Checkbox"> <ItemTemplate> <asp:CheckBox ID="chkRow" runat="server" /> </ItemTemplate> <HeaderStyle Width="10%" /> </asp:TemplateField> <asp:BoundField DataField="Fld_id" HeaderText="شماره" ReadOnly="True" SortExpression="Fld_id" /> <asp:HyperLinkField HeaderText="آپلود کننده" DataNavigateUrlFields="Fld_RandCode,Fld_id" DataTextField="Fld_Uploader" DataNavigateUrlFormatString="Company_Add.aspx?Code={0}&id={1}" /> <asp:HyperLinkField HeaderText="تاریخ آپلود" DataNavigateUrlFields="Fld_RandCode,Fld_id" DataTextField="Fld_Date" DataNavigateUrlFormatString="Company_Add.aspx?Code={0}&id={1}" /> <asp:

ImageField DataImageUrlField =HeaderText =تصویرSortExpression =Fld_path/>

< asp：HyperLinkField HeaderText =نامDataNavigateUrlFields =Fld_RandCode，Fld_idDataTextField =Fld_NameDataNavigateUrlFormatString =Company_Add .aspx？代码= {0}& id = {1}/>



< / Columns>







我知道它有点复杂但我已经工作了大约1周但仍未得到我的适当结果：（





谢谢大家。

ImageField DataImageUrlField="" HeaderText="تصویر" SortExpression="Fld_path" />
<asp:HyperLinkField HeaderText="نام" DataNavigateUrlFields="Fld_RandCode,Fld_id" DataTextField="Fld_Name" DataNavigateUrlFormatString="Company_Add.aspx?Code={0}&id={1}" />

</Columns>



I know its a bit complicated but i have been working on it about 1 week and still didnt get my appropriate result :(


Thank you all .

尝试这样的事情：

Try something like this:

<ItemTemplate>
    <asp:Image ID="Image1" runat="server" 

        ImageUrl='<%# string.Format("~/ReadAttachment.aspx?code={0}&id={1}", Eval("Code"), Eval("ID")) %>'

    />
</ItemTemplate>

您需要替换字段名称代码两个 Eval（...）中的和ID调用数据源中字段的真实姓名。

You'll need to replace the fields names "Code" and "ID" in the two Eval(...) calls with the real names of the fields in your data source.

这篇关于如何在另一个位置的Gridview中显示照片!!!的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！