Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> .NET Development >> .NET Framework Data Access and Storage

Saving to SQL Db

I have a front-end web form that a user selects criterias for and hit a button that will retrieve a dataset of 1 column. Instead of a dataset I would like to save the 1 field into a SQL db column. This one column is a field with values separated by semicolons since it is a multi-value field.

How can I save this multi-value field as a column without truncation? Currently it appears not all the values are saved, it is truncated where the 1st line wraps.

[458 byte] By [techie3] at [2007-12-17]
«« TFS not seeing all accounts properly
»» How to make an ItemGroup reference a set of subdirectories instead of files?
# 1
techie3,

Can you post your sample code along with the structure of your table in the database? From what you are saing you should be able to do this but I'd need to see your sample to discuss what is wrong and/or how to accomplish this.

Thanks,

Carl Perry
Program Manager ADO.NET
cperry@microsoft.com

CarlPerry-Microsoft at 2007-9-9 > top of Msdn Tech,.NET Development,.NET Framework Data Access and Storage...
.NET Development
.NET Framework Data Access and Storage

.NET Development Hot Topic

.NET Development New Topic

.NET Development

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified