save attachments in MS Access via a web form

[dale zhang]

Hi,

I have a C# web application in ASP.Net, which has a user contact info DB in
MS Access. Can I add a column to each user to save pdf attachments for each
user if needed? If so, how do we do this?

Thanks for help.

-Dale

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

Dale,

I don't think that you want to dynamically add a new column for every
user. Rather, you should have a table which has a user name, and a blob
field (binary, varbinary) which you can then store the bytes of the file in.
This is accompished easily through the appropriate data adapter, which will
more than likely represent the column as a byte array in the data set.

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

"dale zhang" <da*******@discussions.microsoft.com> wrote in message
news:C3**********************************@microsof t.com...

Hi,

I have a C# web application in ASP.Net, which has a user contact info DB
in
MS Access. Can I add a column to each user to save pdf attachments for
each
user if needed? If so, how do we do this?

Thanks for help.

-Dale

[dale zhang]

Nicholas,

Sure, I would have a static column dedicated for this. In MS Access, a blob
field means an OLE object? Is there any example and info about this?

Thanks. -Dale

"Nicholas Paldino [.NET/C# MVP]" wrote:

Dale,

I don't think that you want to dynamically add a new column for every
user. Rather, you should have a table which has a user name, and a blob
field (binary, varbinary) which you can then store the bytes of the file in.
This is accompished easily through the appropriate data adapter, which will
more than likely represent the column as a byte array in the data set.

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

"dale zhang" <da*******@discussions.microsoft.com> wrote in message
news:C3**********************************@microsof t.com...

Hi,

I have a C# web application in ASP.Net, which has a user contact info DB
in
MS Access. Can I add a column to each user to save pdf attachments for
each
user if needed? If so, how do we do this?

Thanks for help.

-Dale

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

Dale,

Yes, an OLE object field is what you want.

Check out the article titled "Reading and Writing Bitmaps or BLOB Data
in ADO.NET" at (watch for line wrap):

http://www.vbdotnetheaven.com/Code/Sept2003/2175.asp

It's in VB, but you can easily change that to C#.

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

"dale zhang" <da*******@discussions.microsoft.com> wrote in message
news:13**********************************@microsof t.com...

Nicholas,

Sure, I would have a static column dedicated for this. In MS Access, a
blob
field means an OLE object? Is there any example and info about this?

Thanks. -Dale

"Nicholas Paldino [.NET/C# MVP]" wrote:

Dale,

I don't think that you want to dynamically add a new column for every
user. Rather, you should have a table which has a user name, and a blob
field (binary, varbinary) which you can then store the bytes of the file
in.
This is accompished easily through the appropriate data adapter, which
will
more than likely represent the column as a byte array in the data set.

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

"dale zhang" <da*******@discussions.microsoft.com> wrote in message
news:C3**********************************@microsof t.com...

> Hi,
>
> I have a C# web application in ASP.Net, which has a user contact info
> DB
> in
> MS Access. Can I add a column to each user to save pdf attachments for
> each
> user if needed? If so, how do we do this?
>
> Thanks for help.
>
> -Dale
>

[dale zhang]

Nicholas,

The article is very good. When i tried to translate it to C# as below:

Image curImage = null;
string curFileName = null;
string savedImageName = "C:\\imageFromDb.BMP";

The compiler can not understand "Image" as below:
c:\inetpub\wwwroot\passwordProtectCSharp\adminUser File.aspx.cs(33): 'Image'
is an ambiguous reference

Any idea? Thanks. -Dale
"Nicholas Paldino [.NET/C# MVP]" wrote:

Dale,

Yes, an OLE object field is what you want.

Check out the article titled "Reading and Writing Bitmaps or BLOB Data
in ADO.NET" at (watch for line wrap):

http://www.vbdotnetheaven.com/Code/Sept2003/2175.asp

It's in VB, but you can easily change that to C#.

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

"dale zhang" <da*******@discussions.microsoft.com> wrote in message
news:13**********************************@microsof t.com...

Nicholas,

Sure, I would have a static column dedicated for this. In MS Access, a
blob
field means an OLE object? Is there any example and info about this?

Thanks. -Dale

"Nicholas Paldino [.NET/C# MVP]" wrote:

Dale,

I don't think that you want to dynamically add a new column for every
user. Rather, you should have a table which has a user name, and a blob
field (binary, varbinary) which you can then store the bytes of the file
in.
This is accompished easily through the appropriate data adapter, which
will
more than likely represent the column as a byte array in the data set.

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

"dale zhang" <da*******@discussions.microsoft.com> wrote in message
news:C3**********************************@microsof t.com...
> Hi,
>
> I have a C# web application in ASP.Net, which has a user contact info
> DB
> in
> MS Access. Can I add a column to each user to save pdf attachments for
> each
> user if needed? If so, how do we do this?
>
> Thanks for help.
>
> -Dale
>