how to display image on image control.getting the path from the database

Question

1.00/5 (1 vote)

See more:

how to display image on image button control.getting the path from the database

Here i am saving the photo in database successfully.what i am facing is to display that photo on the image button control.
can any one help fast..

Posted 20-Dec-12 1:07am

ntitish

Updated 20-Dec-12 1:29am

v2

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)

Krunal Rohit · Answer 1 · 2012-12-20T01:12:00

Solution 1

C#

string SelStr = "select * from Users";
SqlDataAdapter da = new SqlDataAdapter(SelStr, con);
DataTable dt = new DataTable();

da.Fill(dt);

foreach(DataRow dr in dt.Rows)
{
    ImageCtrl.ImageUrl = dr["ImagePath"].ToString();
}

Try if it works.. just my blind assumption..

Posted 20-Dec-12 1:12am

Krunal Rohit

Updated 20-Dec-12 1:21am

v2

Comments

ntitish 20-Dec-12 7:18am

actually i want to display the image accordingly to login_id.
if the particular login person is having the image means it should display on the image. not the image button i posted wrongly....

[no name] 20-Dec-12 7:20am

please correct your question first... I'm updating my solution..

ntitish 20-Dec-12 7:19am

image control not the image button control...

ntitish 20-Dec-12 7:23am

sir if u dont mind i am not getting the update button on this page...can u update the question....actually i am trying from last 10 min.....

[no name] 20-Dec-12 7:25am

" Improve Question " use it

[no name] 20-Dec-12 7:23am

Solution been updated.. take a look.. :) If its not working, let me know...

ntitish 20-Dec-12 7:34am

sir i am totally confused bec u given here the code that i am not getting
actually i am explaining my full problem to u.i am having a registration page of user there i am uploading a photo nd i am successfully saving.here what was the problem is i have to display on registration page on image control where should i have to write the code.sir i am fresher to this job dont be mistaken..

[no name] 20-Dec-12 7:35am

Use this code on logIn button...

ntitish 20-Dec-12 7:43am

u mean signin button when we are entering into user page.

ntitish 20-Dec-12 7:47am

protected void btnSignin_Click(object sender, EventArgs e)
{
try
{
SqlCommand cmd = DBManager.DataAccess.command();
cmd.Parameters.Add(new SqlParameter("@option", SqlDbType.VarChar, 50));
cmd.Parameters["@option"].Value = "SignIn";

cmd.Parameters.Add(new SqlParameter("@login_id", SqlDbType.NVarChar, 50));
cmd.Parameters["@login_id"].Value = txtbxLoginID.Text;

cmd.Parameters.Add(new SqlParameter("@password", SqlDbType.NVarChar, 20));
cmd.Parameters["@password"].Value = txtbxPassword.Text;

string sqlquery = "Alumniproc";
DataSet dset = DBManager.DataAccess.getdata(sqlquery);
if (dset.Tables[0].Rows.Count > 0)
{

string loginId = Convert.ToString(dset.Tables[0].Rows[0]["Login_Id"]);
string firstName = Convert.ToString(dset.Tables[0].Rows[0]["First_Name"]);
string designation = Convert.ToString(dset.Tables[0].Rows[0]["Designation"]);
string status = Convert.ToString(dset.Tables[0].Rows[0]["Status"]);
Session["loginId"] = loginId;
Session["firstName"] = firstName;
Session["designation"] = designation;
Session["status"] = status;
if (Session["status"].ToString().ToLower() == "active")
{

if (Session["designation"].ToString().ToLower() == "admin")
{
Response.Redirect("admin.aspx", false);
}
if (Session["designation"].ToString().ToLower() == "user")
{
Response.Redirect("mypage.aspx", false);
}
if (Session["designation"].ToString().ToLower() == "recruiter")
{
Response.Redirect("recruitermypage.aspx", false);
}
}
else
{
lblInvalidLoginIdPwd.Text = "Sorry! Your account has been disabled";
lblInvalidLoginIdPwd.Visible = true;
}

}
else
{
txtbxLoginID.Text = "";
txtbxPassword.Text = "";
txtbxLoginID.Focus();
panelLogin.Visible = true;
lblInvalidLoginIdPwd.Visible = true;
lblInvalidLoginIdPwd.Text = "Invalid Login Id / Password";
}
}
catch (Exception ex)
{

}
}

ntitish 20-Dec-12 7:47am

that was the code in my signin page.....

[no name] 20-Dec-12 7:50am

Okay similarly try to fetch the Image path..

ntitish 20-Dec-12 8:09am

sir my upload photo code is done in registration page...and my image control also in that registration page.

ntitish 20-Dec-12 8:10am

SqlCommand cmddisplayphoto = DBManager.DataAccess.command();
cmddisplayphoto.Parameters.Add(new SqlParameter("@option",SqlDbType.VarChar,50));
cmddisplayphoto.Parameters["@option"].Value = "DisplayPhoto";

cmddisplayphoto.Parameters.Add(new SqlParameter("@login_id", SqlDbType.NVarChar, 50));
cmddisplayphoto.Parameters["@login_id"].Value = txtbxLoginID.Text;

string sqlquerydisplayphoto = "Alumniproc";
DataSet dsdisplayphoto = DBManager.DataAccess.getdata(sqlquerydisplayphoto);
if (dsdisplayphoto.Tables[0].Rows.Count > 0)
{
string path = Server.MapPath("~/");

string displayphotopath = path + dsdisplayphoto.Tables[0].Rows[0]["Photo_Path"].ToString();

}

ntitish 20-Dec-12 8:12am

in displayphotopath i am getting the path from data base.then how can i display the photo in image control.

[no name] 20-Dec-12 8:22am

Now assign this path to your Image control...

ntitish 20-Dec-12 8:45am

string path = Server.MapPath("~/");
string displayphotopath = path + ViewState["Photo_Path"].ToString();
imgDisplayPhoto.ImageUrl = displayphotopath;
//like this i applied sir,but it is not showing the image.

ntitish 20-Dec-12 9:19am

sir r u there.........

[no name] 21-Dec-12 3:43am

imgDisplayPhoto.ImageUrl = ViewState["Photo_Path"].ToString();

Surendra0x2 · Answer 2 · 2012-12-20T02:22:00

Solution 2

Refer this Link-
http://www.dotnetcode.in/2011/06/how-to-store-imageurl-in-database-and.html[^]

Posted 20-Dec-12 2:22am

Surendra0x2

ntitish · Answer 3 · 2012-12-20T21:41:00

Solution 3

imgDisplayPhoto.ImageUrl = ViewState["Photo_Path"].ToString();

directly we can give the path of the photo which is saving in the database.

thanks for every one who spended their valuable time for me....

Posted 20-Dec-12 21:41pm

ntitish