Showing image from folder and values from database in the same datalist

Question

5.00/5 (1 vote)

See more:

Hi all!!

I want to show image that i have upload into a folder and fetch the values from database inside a Datalist. The problem that i am facing is that i am able to bound only images to the datalist. how to bind both images and database table at the same time??

i am calling this function on pageload

private void bindDatalist()
    {
        DirectoryInfo dir = new DirectoryInfo(MapPath("Thumb"));
        FileInfo[] files = dir.GetFiles();
        ArrayList listItems = new ArrayList();
        foreach (FileInfo info in files)
        {
            listItems.Add(info);
        }
        dtlistMedia.DataSource = listItems;
        dtlistMedia.DataBind();

this is my .aspx code

XML

<asp:DataList ID="dtlistMedia" runat="server" RepeatColumns="4" CellPadding="6" >
           <ItemTemplate>
            <asp:Image Width="300px" Height="200px" ID="Image1" ImageUrl='<%# Eval("Name", "~/Thumb/{0}") %>' runat="server"  />
            <br />
                     <asp:HyperLink ID="HyperLink1" Text='<%# Bind("Name") %>' NavigateUrl='<%# Bind("Name", "~/Thumb/{0}") %>' runat="server"/>
          <br />
         <asp:Label runat="server" Text='<%#Eval("Cost") %>'></asp:Label>
           </ItemTemplate>
           <ItemStyle BorderColor="Brown" BorderStyle="dotted" BorderWidth="3px" HorizontalAlign="Center"
VerticalAlign="Bottom" />

the problem is that how to bind the datalist. here i have bound it to listitems but listitem only contains images not the cost which is stored in database.

plz help me out

Posted 21-Dec-11 20:10pm

ujjwal uniyal

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Answer 1 · 2011-12-21T21:22:00

Solution 1

You cannot have multiple datasources at a given time for the Datalist. You have to collate the data from directory and database into one and then use that as a datasource.
Retrieve the data separately, merge the data into a third and it should be good to go.

Posted 21-Dec-11 21:22pm

Sandeep Mewara

Sachin Suryawanshi · Answer 2 · 2011-12-22T20:41:00

XML

If your want to show Image from Folder Then store the image in Folder and store image name in database

And use following code to show the image

 <asp:Image Width="300px" Height="200px" ID="Image1" ImageUrl='<%# Eval("ImageName", , "~/ProductImages/{0}" runat="server"  />


EVal("ImageName" is a Column name of Table

And ~/ProductImages is  a folder name in your website

obaidullah khan · Answer 3 · 2012-12-24T22:55:00

Solution 3

I want to show image that i have uploaded into a folder and fetch the values from database inside a Datalist. The problem that i am facing is that i am able to bound only images to the datalist. how to bind both images and database table at the same time??

ImageName from database
here image from folder
linkbutton to redirect specific page

i need output this way,,,,

pls help me

Posted 24-Dec-12 22:55pm

obaidullah khan

Comments

André Kraak 25-Dec-12 7:32am

You posted a question as an solution which was probably not want you intended.

If you have a question or comment about the original question use the "Have a Question or Comment?" option beneath the question.
On the other hand if you have a similar problem your best option is to create your own new question, for this use the "Ask a Question" button at the top of the page.

Please move the content of this solution to the appropriate section and remove the solution.

Thank you.

Member 11446311 6-Jul-16 2:55am

i want to display the image from particulor folder into label in asp.net using database table path

Member 11446311 6-Jul-16 2:55am

DataTable dt = BAL.Latest_NewsLoadedFor_Updataereg(id);
if (dt.Rows.Count > 0)
{
txtreg.Text = dt.Rows[0]["RegistrationNo"].ToString();
txtApplication.Text = dt.Rows[0]["ApplicationNo"].ToString();

txtName.Text = dt.Rows[0]["Name"].ToString();
txtSurname.Text = dt.Rows[0]["Surname"].ToString();
txtdob.Text = dt.Rows[0]["DOB"].ToString();
txtNationality.Text = dt.Rows[0]["Nationality"].ToString();
txtReligion.Text = dt.Rows[0]["Religion"].ToString();
txtCaste.Text = dt.Rows[0]["Caste"].ToString();
txtAddress.Text = dt.Rows[0]["Address"].ToString();
txtRes.Text = dt.Rows[0]["ResPhone"].ToString();
txtOffice.Text = dt.Rows[0]["officeadd"].ToString();
txtOfPhone.Text = dt.Rows[0]["offphone"].ToString();
txtStatus.Text = dt.Rows[0]["status"].ToString();
Lblimg1.Text = dt.Rows[0]["ImgData"].ToString();
txtRegs.Text = dt.Rows[0]["regstatus"].ToString();

Member 11446311 6-Jul-16 2:56am

Please can anyone help me

Member 11446311 6-Jul-16 2:57am