SQL Server, MS Word and C#.

[Usman Ahmad via .NET 247]

The DB is SQL Server. The Language is C# (2003 version)

I want to insert some word files into the database and also be able to retreive them.
This is what I want to know
1) What DataType should the fiel be in the DB.
2) How can I go about inserting and reading from this field?

--------------------------------
From: Usman Ahmad

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

<Id>kaSvaFDlZECidz8+NMgsHA==</Id>

[Nicholas Paldino [.NET/C# MVP]]

Usman,

You should probably use the image data type in SQL Server (since the
files will most likely be of variable length).

The representation of this field on the .NET side should be an array of
bytes (byte[]). You should be able to load your document into an array, and
just set the field appropriately.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Usman Ahmad via .NET 247" <an*******@dotnet247.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

The DB is SQL Server. The Language is C# (2003 version)

I want to insert some word files into the database and also be able to
retreive them.
This is what I want to know
1) What DataType should the fiel be in the DB.
2) How can I go about inserting and reading from this field?

--------------------------------
From: Usman Ahmad

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

<Id>kaSvaFDlZECidz8+NMgsHA==</Id>

[Nick Malik]

Data type would be binary.

Here's a good example
http://www.akadia.com/services/dotne...rite_blob.html

Hope this helps,
--- Nick

"Usman Ahmad via .NET 247" <an*******@dotnet247.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

The DB is SQL Server. The Language is C# (2003 version)

I want to insert some word files into the database and also be able to retreive them. This is what I want to know
1) What DataType should the fiel be in the DB.
2) How can I go about inserting and reading from this field?

--------------------------------
From: Usman Ahmad

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

<Id>kaSvaFDlZECidz8+NMgsHA==</Id>

[Nick Malik]

brain freeze... Data type would be "image"
sorry about that.

"Nick Malik" <ni*******@hotmail.nospam.com> wrote in message
news:4IdZc.216372$8_6.69559@attbi_s04...

Data type would be binary.

Here's a good example
http://www.akadia.com/services/dotne...rite_blob.html

Hope this helps,
--- Nick

"Usman Ahmad via .NET 247" <an*******@dotnet247.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

The DB is SQL Server. The Language is C# (2003 version)

I want to insert some word files into the database and also be able to

retreive them.

This is what I want to know
1) What DataType should the fiel be in the DB.
2) How can I go about inserting and reading from this field?

--------------------------------
From: Usman Ahmad

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

<Id>kaSvaFDlZECidz8+NMgsHA==</Id>