About Pricing Community Teams Start Free Trial

Murray Brown

asked on 10/18/2016

ASP.net VB.net Insert picture into SQL database

Hi

I have a SQL table with a varbinary column. I need a user on my webform to be able to click a button that inserts an image
into the database. If I know the path of the database, how would the SQL statement look?

Thanks

ASP.NETVisual Basic.NETMicrosoft SQL Server

Last Comment

Murray Brown

8/22/2022 - Mon

Pawan Kumar

10/18/2016

Pls try .. This code will read the data from the table and save the jpg file @ E drive with name Pawan.jpg.

4 part name [PAWAN452801].[ABCInvestment].data.CreditReport ----- ServerName.DatabaseaName.Schema.TableName

	

	DECLARE  @Command NVARCHAR(4000)=''
	
	SET @Command = 'bcp " ' + 'SELECT CreditReport FROM [PAWAN452801].[ABCInvestment].data.CreditReport ' 
                   + ' queryout "E:\Pawan' + '.jpg' + '"' + ' -T -N'
 
	PRINT @Command
 
	EXEC xp_cmdshell  @Command

Open in new window

Murray Brown

10/18/2016

ASKER

Hi

Thank you. I need to do this in VB.net

ASKER CERTIFIED SOLUTION

10/18/2016

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

Murray Brown

10/18/2016

ASKER

Hi. Thank you for the feedback but I need this to all happen in my VB.net application because it has to work with any database from my app

All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat

Pawan Kumar

10/18/2016

ohhh okies... cool. go ahead....

Murray Brown

10/19/2016

ASKER

Thanks for the help. I can work out the rest

Plans and Pricing

Certified Expert Program

Credly Partnership

Udemy Partnership