I Want To Fetch Image On Page Load From Table In Which The Path Of Image Is Stored And The Actual Image Is In The Folder Of Solution. I Have Used Image Control. Should I Use Another Control ? Asp.Net

Question

0.00/5 (No votes)

See more:

I want to fetch image on page load from table in which the path of image is stored and the actual image is in the folder of solution. I have used image control. should i use another control ? in ASP.net

Posted 14-Mar-14 3:00am

jayraj86

Add a Solution

Comments

MAYANK GEETE 14-Mar-14 9:35am

just fetch your data into datatable then
string path = dt.rows[0]["IMGpath"].tostring();
ImageButton1.ImageUrl = "~//" + path;

jayraj86 14-Mar-14 11:57am

My code is as below. I just want to display image on page load. i am using image control. what changes i should make in this code ?

protected void Page_Load(object sender, EventArgs e)
{

if (Convert.ToInt16(Session["CompanyID"].ToString()) > 0)
{
con.Open();
SqlCommand cmd = new SqlCommand("select * from Companies where CompanyID=" + Session["CompanyID"], con);
SqlDataAdapter da = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();

da.Fill(ds, "Companies");

if (ds.Tables[0].Rows.Count > 0)
{
email.Text = ds.Tables[0].Rows[0]["EmailID"].ToString();
firstname.Text = ds.Tables[0].Rows[0]["FirstName"].ToString();
lastname.Text = ds.Tables[0].Rows[0]["LastName"].ToString();
designation.Text = ds.Tables[0].Rows[0]["Designation"].ToString();
mobile.Text = ds.Tables[0].Rows[0]["ContactNo"].ToString();

Label9.Text = ds.Tables[0].Rows[0]["CompanyName"].ToString();
Label10.Text = ds.Tables[0].Rows[0]["City"].ToString();
Label16.Text = ds.Tables[0].Rows[0]["Address"].ToString();
Label11.Text = ds.Tables[0].Rows[0]["Website"].ToString();
Label12.Text = ds.Tables[0].Rows[0]["CompanyCategory"].ToString();
Label13.Text = ds.Tables[0].Rows[0]["NoOfEmployees"].ToString();
Label15.Text = ds.Tables[0].Rows[0]["Aboutcompany"].ToString();

}
}
}
}
}

ZurdoDev 14-Mar-14 11:43am

I don't understand your question. You're asking if you should use something other than the image control to show an image? No. Use the image control.

jayraj86 14-Mar-14 11:49am

My code is as below. I just want to display image on page load. i am using image control. what changes i should make in this code ?

protected void Page_Load(object sender, EventArgs e)
{

if (Convert.ToInt16(Session["CompanyID"].ToString()) > 0)
{
con.Open();
SqlCommand cmd = new SqlCommand("select * from Companies where CompanyID=" + Session["CompanyID"], con);
SqlDataAdapter da = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();

da.Fill(ds, "Companies");

if (ds.Tables[0].Rows.Count > 0)
{
email.Text = ds.Tables[0].Rows[0]["EmailID"].ToString();
firstname.Text = ds.Tables[0].Rows[0]["FirstName"].ToString();
lastname.Text = ds.Tables[0].Rows[0]["LastName"].ToString();
designation.Text = ds.Tables[0].Rows[0]["Designation"].ToString();
mobile.Text = ds.Tables[0].Rows[0]["ContactNo"].ToString();

Label9.Text = ds.Tables[0].Rows[0]["CompanyName"].ToString();
Label10.Text = ds.Tables[0].Rows[0]["City"].ToString();
Label16.Text = ds.Tables[0].Rows[0]["Address"].ToString();
Label11.Text = ds.Tables[0].Rows[0]["Website"].ToString();
Label12.Text = ds.Tables[0].Rows[0]["CompanyCategory"].ToString();
Label13.Text = ds.Tables[0].Rows[0]["NoOfEmployees"].ToString();
Label15.Text = ds.Tables[0].Rows[0]["Aboutcompany"].ToString();

}
}
}
}
}

ZurdoDev 14-Mar-14 11:50am

I don't see an image control. Add an image control and set it's image path to the url of where it is.

jayraj86 14-Mar-14 11:52am

I have added image control.. will you please write that in code ?

ZurdoDev 14-Mar-14 11:54am

http://www.w3schools.com/aspnet/control_image.asp

Set the ImageUrl.

jayraj86 14-Mar-14 11:56am

Thanks.. but I am using session so I want image as per session id.

ZurdoDev 14-Mar-14 11:57am

I don't follow. This is pretty trivial. You need to have images on the server, right? You store their path in the database. So, when you retrieve your record get the path and set the ImageUrl.

jayraj86 14-Mar-14 12:04pm

the case here is the user who get's logged in only his/her photo should be displayed.

ZurdoDev 14-Mar-14 12:10pm

So in your sql pull their image.

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)