Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

DataTpe Question ASP.NET

2 posts in General Discussion Last posting was on 2003-09-09 21:49:55.0Z
VBM Posted on 2003-09-09 21:47:36.0Z
From: "VBM" <legendnews@lycos.co.uk>
Newsgroups: ianywhere.public.general
Subject: DataTpe Question ASP.NET
Lines: 19
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: 12.25.165.67
Message-ID: <3f5e4ad6$1@forums-2-dub>
X-Original-Trace: 9 Sep 2003 14:49:10 -0700, 12.25.165.67
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 9 Sep 2003 14:44:51 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 9 Sep 2003 14:47:36 -0700
X-Trace: forums-1-dub 1063144056 10.22.108.75 (9 Sep 2003 14:47:36 -0700)
X-Original-Trace: 9 Sep 2003 14:47:36 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1730
Article PK: 3951

see the below code module

BinaryFormatter formatter = new BinaryFormatter();
MemoryStream stream = new MemoryStream();
formatter.Serialize(stream, obj);

IDbDataParameter parmObject = pf.CreateDataParameter("@Object",
System.Data.DbType.Binary);
parmObject.Value = stream.ToArray()
cmdSql.Parameters.Add(parmObject);
Store proc has parameter with type IMAGE. I am using Sybase. I want to know
the exact DataType from System.Data.DbType so that will match for Image
datatype from ther database side for very large binary objects.

I am using Sybase ASA.

Thanks


VBM Posted on 2003-09-09 21:49:55.0Z
From: "VBM" <legendnews@lycos.co.uk>
Newsgroups: ianywhere.public.general
References: <3f5e4ad6$1@forums-2-dub>
Subject: Re: DataTpe Question ASP.NET
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: 12.25.165.67
Message-ID: <3f5e4b65$1@forums-2-dub>
X-Original-Trace: 9 Sep 2003 14:51:33 -0700, 12.25.165.67
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 9 Sep 2003 14:47:11 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 9 Sep 2003 14:49:55 -0700
X-Trace: forums-1-dub 1063144195 10.22.108.75 (9 Sep 2003 14:49:55 -0700)
X-Original-Trace: 9 Sep 2003 14:49:55 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1731
Article PK: 3952

I am using Sybase ASA 9.0

VBM wrote:
> see the below code module
>
> BinaryFormatter formatter = new BinaryFormatter();
> MemoryStream stream = new MemoryStream();
> formatter.Serialize(stream, obj);
>
> IDbDataParameter parmObject = pf.CreateDataParameter("@Object",
> System.Data.DbType.Binary);
> parmObject.Value = stream.ToArray()
> cmdSql.Parameters.Add(parmObject);
> Store proc has parameter with type IMAGE. I am using Sybase. I want
> to know the exact DataType from System.Data.DbType so that will match
> for Image datatype from ther database side for very large binary
> objects.
>
> I am using Sybase ASA.
>
> Thanks