hi,
i have stored images in a seperate folder in the website project and only image names with extension are stored in the database column. so plz tell me how to link the folder and database to retriew the images when the condition is satisfied.its urgent so plz reply me.

I'm not really sure what problem you're having?

What errors do you get when you run this code?
What's not working?

hi thanks for replying. i wrote code for tht. now my problem is
i hv passed imageid from 1st page to second page and i hv stored imageid as iid0001,iid0002,etc.,..... as varchar in database in 2nd page i hv written code as

string imgid = Request.QueryString["imageid"];
SqlDataAdapter da = new SqlDataAdapter("select * from tbluploadphoto where imageid =" + imgid, conn1);
conn1.Open();
DataSet ds = new DataSet();
da.Fill(ds);// here i am getting invalid column name'iid0001'
if (ds.Tables[0].Rows.Count > 0)
{
imagepath = "~/PostedImages/";
string str = ds.Tables[0].Rows[0]["imagename"].ToString();
imagepath = imagepath + ds.Tables[0].Rows[0]["imagename"].ToString();
lblimgtitle.Text = ds.Tables[0].Rows[0]["title"].ToString();
}
conn1.Close();
Page.DataBind();
// int imgid = Convert.ToInt32(Request.QueryString["imageid"]);
}

so pls help me wht i want to change.
thnx in advance

hi i got output
thanks