ASP.NET

ASP.NET RSS

Not able to display all image from DB except 1st image.

Please support our ASP.NET advertiser: $4.95 a Month - ASP.NET Web Hosting – Click Here!

•

Join Date: Jan 2009

Posts: 1

Reputation: Makjain is an unknown quantity at this point

Solved Threads: 0

Makjain

Offline

Newbie Poster

Not able to display all image from DB except 1st image.

Jan 4th, 2009

On the selection of value from dropdownlist, image is displayed in display page. Selectedvalue has many image in DB say 50+ but as per my query below it reads only 1st image of DB i.e.1st image of database. So do let me know where my code is gng wrong.

CODE VIEW OF DISPLAY PAGE:

 Help with Code Tags 
 asp.net Syntax (Toggle Plain Text) 
public string FormatURL(object strArgument)
    {
        return ("Read.aspx?Coins=" + strArgument);
    }
public string FormatURL(object strArgument)
    {
        return ("Read.aspx?Coins=" + strArgument);
    }

SOURCE VIEW OF DISPLAY PAGE:

 Help with Code Tags 
 asp.net Syntax (Toggle Plain Text) 
<asp:DataList ID="DataList1" runat="server" DataSourceID="SqlDataSource1"> 
<ItemTemplate>
 
Image:<asp:Image ID="Image1" runat="server" Height="50px" Width="100px" imageUrl='<%#FormatURL(DataBinder.Eval(Container.DataItem, "coins")) %>'/>
 
</ItemTemplate>
 
</asp:DataList>
 
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:CoinsString %>" 
 
SelectCommand="SELECT [imgdata], [imgtype], [Coins] FROM [TABLE] WHERE ([Coins] = @Coins)">
 
<SelectParameters>
 
<asp:ControlParameter ControlID="DropDownList1" Name="Coins" PropertyName="SelectedValue" Type="String" />
 
</SelectParameters>
 
</asp:SqlDataSource>
<asp:DataList ID="DataList1" runat="server" DataSourceID="SqlDataSource1"> 
<ItemTemplate>

Image:<asp:Image ID="Image1" runat="server" Height="50px" Width="100px" imageUrl='<%#FormatURL(DataBinder.Eval(Container.DataItem, "coins")) %>'/>

</ItemTemplate>

</asp:DataList>

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:CoinsString %>" 

SelectCommand="SELECT [imgdata], [imgtype], [Coins] FROM [TABLE] WHERE ([Coins] = @Coins)">

<SelectParameters>

<asp:ControlParameter ControlID="DropDownList1" Name="Coins" PropertyName="SelectedValue" Type="String" />

</SelectParameters>

</asp:SqlDataSource>

CODE VIEW OF READ PAGE:

 Help with Code Tags 
 asp.net Syntax (Toggle Plain Text) 
protected void Page_Load(object sender, EventArgs e)
    {
        string strImageID = Request.QueryString[0];
        SqlConnection cn = new SqlConnection("Data Source=MAKJAIN;Initial Catalog=DATABASE;Integrated Security=True");
        SqlCommand cmd = new SqlCommand("select imgtype,imgdata from TABLE where coins='" + strImageID + "' ", cn);
        //
        try
        {
            cn.Open();
            SqlDataReader dr;
            dr = cmd.ExecuteReader();
            while (dr.Read())
            //yup we found our image
            {
                //retrving the image content type                
                Response.ContentType = dr["imgtype"].ToString();
                //displaying the image                
                Response.BinaryWrite((byte[])dr["imgdata"]);
            }
            cn.Close();
        }
        catch
        {
        }
protected void Page_Load(object sender, EventArgs e)
    {
        string strImageID = Request.QueryString[0];
        SqlConnection cn = new SqlConnection("Data Source=MAKJAIN;Initial Catalog=DATABASE;Integrated Security=True");
        SqlCommand cmd = new SqlCommand("select imgtype,imgdata from TABLE where coins='" + strImageID + "' ", cn);
        //
        try
        {
            cn.Open();
            SqlDataReader dr;
            dr = cmd.ExecuteReader();
            while (dr.Read())
            //yup we found our image
            {
                //retrving the image content type                
                Response.ContentType = dr["imgtype"].ToString();
                //displaying the image                
                Response.BinaryWrite((byte[])dr["imgdata"]);
            }
            cn.Close();
        }
        catch
        {
        }

Last edited by peter_budo; Jan 11th, 2009 at 2:38 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.