jackjohnson44
asked on
save file to database vb.net vs2005
I have the prototype of a screen where someone can browse for a file. It is supposed to be imported into the table below. I plan to use a dataset built in the designer. How do I save the file to the db?
CREATE TABLE [Banks].[tblBankAttachment s](
[BankAttachmentGUID] [PCA].[UDT_GUID] NOT NULL,
[BankGUID] [PCA].[UDT_GUID] NOT NULL,
[Filename] [varbinary](50) NOT NULL,
[Filedescription] [nchar](255) COLLATE SQL_Latin1_General_CP1_CI_ AS NOT NULL,
[FileSize] [int] NOT NULL,
[FileText] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_ AS NULL,
[CreatedOn] [datetime] NOT NULL,
[CreatedBy] [nvarchar](30) COLLATE SQL_Latin1_General_CP1_CI_ AS NOT NULL,
CONSTRAINT [PK_tblBankAttachments] PRIMARY KEY CLUSTERED
CREATE TABLE [Banks].[tblBankAttachment
[BankAttachmentGUID] [PCA].[UDT_GUID] NOT NULL,
[BankGUID] [PCA].[UDT_GUID] NOT NULL,
[Filename] [varbinary](50) NOT NULL,
[Filedescription] [nchar](255) COLLATE SQL_Latin1_General_CP1_CI_
[FileSize] [int] NOT NULL,
[FileText] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_
[CreatedOn] [datetime] NOT NULL,
[CreatedBy] [nvarchar](30) COLLATE SQL_Latin1_General_CP1_CI_
CONSTRAINT [PK_tblBankAttachments] PRIMARY KEY CLUSTERED
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What type of a data file are they opening up? A CSV (comma separated value) file, XML, a TXT file, etc?
ASKER
sql, but how do I get a file into the variable or check the size?
If I start with a file browse dialogue, where do I go from there?