i'm having a problem, in displaying the image in the imagebox. i'm having the following fields in my table User:
1 user name
2 email- primary key
and the folder in which the image is saved named - User_Pic.
now, i have saved the image name and path in the database using the following code:
FileUpload.PostedFile.SaveAs(Server.MapPath("~/User_Pic/") + FileUpload.FileName.ToString());
string Filename = Path.GetFileName(FileUpload.PostedFile.FileName);
string sql = "insert into User_Table values('" + txtUser_Name.Text + "','" + txtEmail_Id.Text + "','" + txtAge.Text + "','" + txtPassword.Text + "','" + Filename + "','" + "User_Pic/"+Filename + "')";
ob.cmd = new System.Data.SqlClient.SqlCommand(sql, ob.con);
lblInfo.Text = "REGISTERED SUCCESSFULLY";
Now how to display it in image box using the query as email id:
string sql = "select Image_Path from User_Table where Email_Id = ('" + TextBox1.Text + "')";
after this i'm having the trouble ??