Uploading files

[ozzroo]

Anyone know a link to code which will allow me to work with to upload files (word docs, pdfs) to an sql server.

I want to also rename the file to include the client reference number which is an incremental id field in the database.

I want it to add the new registration to the database, then get the new allocated reference number and use that to link the updated cv in another table.

I have the registrations working fine. so a new client registers and gets the number 12345. This will then add the doc they uploaded to a 'document' table and will be linked to 12345

Any help?

Thanks

 

[macleod1021]

I found this site very quickly from googling "store file in SQL Server C#"

http://chiragrdarji.wordpress.com/2007/08/31/storing-and-retrieving-docpdfxls-files-in-sql-server/

 

[ozzroo]

Ok. I can now upload files to the document table perfectly fine, but how would i get the client id from the clients table to link it to the document uploaded at time of registration.

my code adds the new user to the database and gives them a unique number. then i run the code to add the file to the database. this is the same form. i want it to pull through the created unique number so i know which documents are linked to which users.

i assume it adds the client first, so there must be a way i can get the information from the new registration

any ideas please

 

[ca8msm]

You could use scope_identity() if you are using SQL Server to return the inserted key for the client.


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]

 

[ozzroo]

How would I use scope_identity with asp.net. I have looked at some tutorials online, but cant seem to get it working.

Any ideas or starter points

 

[ozzroo]

Here is my store procedure. But how would I use that scope_identity to insert a record in another table

Create Procedure InsertNewRegistration
)
@Title nvarchar(50)
@Forename nvarchar(255)
@Surname nvarchar(255)
@Company nvarchar(50)
@AddressLine1 nvarchar(255)
@AddressLine2 nvarchar(255)
@AddressLine3 nvarchar(255)
@AddressLine4 nvarchar(255)
@County nvarchar(50)
@Postcode nvarchar(255)
@Region nvarchar(50)
@HomePhone nvarchar(255)
@BusinessPhone nvarchar(255)
@MobilePhone nvarchar(255)
@Email nvarchar(50)
@Password nchar(10)
@AssociateRef int OUTPUT

)
AS

-- INSERT the new record
INSERT INTO dbo.Associates(Title, Forename, Surname, Company, AddressLine1, AddressLine2, AddressLine3, AddressLine4, County, Postcode, Region, HomePhone, BusinessPhone, MobilePhone, Email, Password )
VALUES(@Title, @Forename, @Surname, @Company, @AddressLine1, @AddressLine2, @AddressLine3, @AddressLine4, @County, @Postcode, @Region, @HomePhone, @BusinessPhone, @MobilePhone, @Email, @Password)

-- Read the just-inserted ProductID into @AssociateRef
SET @AssociateRef = SCOPE_IDENTITY()