Hello,
I have a table with products. The table contains several columns. A
column with the product ID (datatype 'long'), a column with the product
name (datatype 'text') and a column with the product description (data
type 'memo').
My query shows the product id column and combines the product name and
description in 1 column as follows:
Product: txtName & ": " & memDescription
The query shows all data correct.
In ASP.NET I connect to the database (the connectionstring works fine):
dim conn as new oledb.oledbconnection(CONNECTIONSTRING)
dim da as new oledb.oledbdataadapter("SELECT * FROM qryProducts", conn)
dim ds as new dataset
da.fill(ds)
The 'Product' column in the query now shows all characters, but the
dataset only contains the first 255 characters.
Greetings,
Christian.
*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!