Click here to Skip to main content
15,891,902 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: Graficos en Visual Basic Pin
Steve Pullan8-Mar-06 18:48
Steve Pullan8-Mar-06 18:48 
AnswerRe: Graficos en Visual Basic Pin
progload8-Mar-06 19:58
progload8-Mar-06 19:58 
Questionstoring images in database for dating site. Pin
uglyeyes8-Mar-06 18:08
uglyeyes8-Mar-06 18:08 
Hi all,

I am building a online dating site (users may be 200-300 or more). each user can only store upto 5 images. my table structure looks like below

------
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UserImage]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[UserImage]
GO

CREATE TABLE [dbo].[UserImage] (
[Bits] [image] NULL ,
[Description] [nvarchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[UserId] [int] NULL ,
[UserImageId] [int] NULL ,
[UploadTime] [datetime] NULL ,
[ImageSize] [int] NULL ,
[Mime] [nvarchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO


------

I just want to know will it have any performance issue when i store images in DB rather than in file and only have a reference to that filename in DB?

I dont want my user to type the URL parameter and do silly stuff such as.

i only want them to type

www.mysite.com
and if they type in URL anything other than that it should take them to
a page saying page not found or sumthing. the reason is.

when i delete image i am getting a parameter from query. like

www.mysite.com/managepictures.aspx?UserId=12&DeleteImgId=4

that means if user passes diff. parameter it will actually delete others image and they can even browse the pic by chaning UserID para.

i dont know how to achieve this

please help

many thanks in forward
Robin
AnswerRe: storing images in database for dating site. Pin
Steve Pullan8-Mar-06 18:45
Steve Pullan8-Mar-06 18:45 
AnswerRe: storing images in database for dating site. Pin
Steve Pullan8-Mar-06 18:53
Steve Pullan8-Mar-06 18:53 
GeneralRe: storing images in database for dating site. Pin
uglyeyes9-Mar-06 1:24
uglyeyes9-Mar-06 1:24 
GeneralRe: storing images in database for dating site. Pin
Steve Pullan9-Mar-06 11:09
Steve Pullan9-Mar-06 11:09 
GeneralRe: storing images in database for dating site. Pin
uglyeyes9-Mar-06 17:03
uglyeyes9-Mar-06 17:03 
Questionhow to clear datagridview w/c is data-bound Pin
thepityone8-Mar-06 17:52
thepityone8-Mar-06 17:52 
AnswerRe: how to clear datagridview w/c is data-bound Pin
abhinish8-Mar-06 18:11
abhinish8-Mar-06 18:11 
QuestionVB.NET / MS Access Threading Issue... Pin
mayhem_rules8-Mar-06 17:51
mayhem_rules8-Mar-06 17:51 
QuestionIssue on the List Items Collection Editor Class Pin
KaKa'8-Mar-06 15:19
KaKa'8-Mar-06 15:19 
AnswerRe: loan payment Pin
Steve Pullan8-Mar-06 15:32
Steve Pullan8-Mar-06 15:32 
GeneralRe: loan payment Pin
Garth J Lancaster8-Mar-06 15:39
professionalGarth J Lancaster8-Mar-06 15:39 
GeneralRe: loan payment Pin
Tank528-Mar-06 16:06
Tank528-Mar-06 16:06 
GeneralRe: loan payment Pin
Tank528-Mar-06 16:09
Tank528-Mar-06 16:09 
GeneralRe: loan payment Pin
nzmike8-Mar-06 16:18
nzmike8-Mar-06 16:18 
GeneralRe: loan payment Pin
Tank528-Mar-06 16:22
Tank528-Mar-06 16:22 
GeneralRe: loan payment Pin
progload8-Mar-06 16:30
progload8-Mar-06 16:30 
Questionhow to import Bookmarks favorites file to TreeView Pin
segaal8-Mar-06 13:41
segaal8-Mar-06 13:41 
AnswerRe: how to import Bookmarks favorites file to TreeView Pin
segaal11-Mar-06 6:51
segaal11-Mar-06 6:51 
QuestionHow to reference checkedlistbox from one class to another Pin
JK11508-Mar-06 12:24
JK11508-Mar-06 12:24 
QuestionScrolling datagrid without scrollbar visible - possible? Pin
nzmike8-Mar-06 11:51
nzmike8-Mar-06 11:51 
QuestionIssue with manual adding data to Checked list box Pin
devarajchandra8-Mar-06 9:54
devarajchandra8-Mar-06 9:54 
QuestionExecution speed - question re: vb.net Pin
guruvar28-Mar-06 9:53
guruvar28-Mar-06 9:53 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.