By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,423 Members | 1,327 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,423 IT Pros & Developers. It's quick & easy.

Any help with store a file in a DB ?

P: n/a
I use VB .NET 2003 and I want to store into a binary field of a SqlServer
2003 table a File that I got on my hard disk.

Does anyone know how can I do that ?

I also use an OpenFileDialog component to get the file name and the path.
I got already a connection to my DB

and the only problem is that I don't know how to store the file into the
table ?
with the help of a variable first ? and then to insert it into the table in
a binary field ?

Nov 22 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Some good articles that may be able to help
http://www.netmag.co.uk/tutorials/de...bsectionid=176
http://www.csharpfriends.com/Article...?articleID=112

Sorry the articles are in C#. The concepts are the same, and the HTML parts
don't change at all.

Hope this helps,
--- Nick

"Rastarizer" <st******@taxydromiki.gr> wrote in message
news:uR*************@TK2MSFTNGP11.phx.gbl...
I use VB .NET 2003 and I want to store into a binary field of a SqlServer
2003 table a File that I got on my hard disk.

Does anyone know how can I do that ?

I also use an OpenFileDialog component to get the file name and the path.
I got already a connection to my DB

and the only problem is that I don't know how to store the file into the
table ?
with the help of a variable first ? and then to insert it into the table in a binary field ?

Nov 22 '05 #2

P: n/a
On Tue, 5 Oct 2004 14:11:32 +0300, "Rastarizer" <st******@taxydromiki.gr> wrote:

I use VB .NET 2003 and I want to store into a binary field of a SqlServer
2003 table a File that I got on my hard disk.

Does anyone know how can I do that ?

I also use an OpenFileDialog component to get the file name and the path.
I got already a connection to my DB

and the only problem is that I don't know how to store the file into the
table ?
with the help of a variable first ? and then to insert it into the table in
a binary field ?

See the following:

How To Read and Write BLOB Data by Using ADO.NET with Visual Basic .NET
http://support.microsoft.com/default...b;en-us;308042
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)
Nov 22 '05 #3

P: n/a
Some good articles that may be able to help
http://www.netmag.co.uk/tutorials/de...bsectionid=176
http://www.csharpfriends.com/Article...?articleID=112

Sorry the articles are in C#. The concepts are the same, and the HTML parts
don't change at all.

Hope this helps,
--- Nick

"Rastarizer" <st******@taxydromiki.gr> wrote in message
news:uR*************@TK2MSFTNGP11.phx.gbl...
I use VB .NET 2003 and I want to store into a binary field of a SqlServer
2003 table a File that I got on my hard disk.

Does anyone know how can I do that ?

I also use an OpenFileDialog component to get the file name and the path.
I got already a connection to my DB

and the only problem is that I don't know how to store the file into the
table ?
with the help of a variable first ? and then to insert it into the table in a binary field ?

Nov 22 '05 #4

P: n/a
On Tue, 5 Oct 2004 14:11:32 +0300, "Rastarizer" <st******@taxydromiki.gr> wrote:

I use VB .NET 2003 and I want to store into a binary field of a SqlServer
2003 table a File that I got on my hard disk.

Does anyone know how can I do that ?

I also use an OpenFileDialog component to get the file name and the path.
I got already a connection to my DB

and the only problem is that I don't know how to store the file into the
table ?
with the help of a variable first ? and then to insert it into the table in
a binary field ?

See the following:

How To Read and Write BLOB Data by Using ADO.NET with Visual Basic .NET
http://support.microsoft.com/default...b;en-us;308042
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)
Nov 22 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.