Advertisement
Advertisement
| 06.06.2008 at 06:10AM PDT, ID: 23463537 |
|
[x]
Attachment Details
|
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: |
'Set up call to update stored procedure
conn.ConnectionString = System.Configuration.ConfigurationManager.AppSettings("strConn1")
conn.Open()
'Remove image from database
cmd.Connection = conn
cmd.CommandType = System.Data.CommandType.StoredProcedure
cmd.CommandText = "DeleteImage"
cmd.Parameters.Add(New System.Data.SqlClient.SqlParameter("@ImageID", System.Data.SqlDbType.Int, 4)).Value = Request.Params("ImageID")
cmd.Parameters.Add(New System.Data.SqlClient.SqlParameter("@ID", System.Data.SqlDbType.Int, 4)).Value = Request.QueryString("HotelID")
cmd.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Code", System.Data.SqlDbType.VarChar)).Value = "HPHTO"
objDR = cmd.ExecuteReader()
'Remove image from server
File.Delete(Path.Combine(Server.MapPath("") & "\ImagesHotels\", Request.QueryString("Image")))
objDR.Close()
conn.Close()
RefreshPage()
End If
|