Author: dwharton | Posted on: 9/23/2008 3:41:34 PM | Views : 864

 I'm trying to retrieve/display an image from SQL after I uploaded it into the DB.  My code to upload looks like this

 string conn = ConfigurationManager.ConnectionStrings["dbEmployee"].ConnectionString;
                connection = new SqlConnection(conn);

                connection.Open();
               
string sql = "UPDATE [PHOTO] Set[PHOTO] = @PHOTO WHERE [PhotoID] =
@PhotoID UPDATE [ActiveRecords]SET [PhotoID] = @PhotoID WHERE
ActiveRecords.[ActiveRecordsID] = @PhotoID";

                SqlCommand cmd = new SqlCommand(sql, connection);
         &nbs ...

Go to the complete details ...