Click here to Skip to main content
15,887,746 members
Home / Discussions / C#
   

C#

 
AnswerRe: How to convert object type into 'int' type? Pin
Are Jay5-Mar-07 9:41
Are Jay5-Mar-07 9:41 
GeneralRe: How to convert object type into 'int' type? Pin
Khoramdin5-Mar-07 9:51
Khoramdin5-Mar-07 9:51 
GeneralRe: How to convert object type into 'int' type? Pin
Colin Angus Mackay5-Mar-07 13:51
Colin Angus Mackay5-Mar-07 13:51 
QuestionDateTimepicker commercial replacement ? Pin
CAE5-Mar-07 8:45
CAE5-Mar-07 8:45 
Questionsend a wav file through a socket in C# Pin
trab0075-Mar-07 7:33
trab0075-Mar-07 7:33 
AnswerRe: send a wav file through a socket in C# Pin
Ennis Ray Lynch, Jr.5-Mar-07 10:18
Ennis Ray Lynch, Jr.5-Mar-07 10:18 
GeneralRe: send a wav file through a socket in C# Pin
trab0075-Mar-07 20:56
trab0075-Mar-07 20:56 
QuestionTrouble updating Access DB in C# [modified] Pin
bward845-Mar-07 6:50
bward845-Mar-07 6:50 
Greetings,

I'm currently working on a C# application which interacts with data in an Access DB containing 2 tables. One table has 56 columns which I store related ID's in corresponding to the second table. These ID's are of the Text type and I have set the size field to 255 which is the maximum allowed text field in Access. The trouble is when I go to call the DataAdapter Update command passing it a dataset, after the update successfully updates 16 of the columns the 17th fails and says "Record too large". I have verified that the data in this column is exactly the same size as the others, 251 bytes, and also that it does not matter which column is the 17th to be updated I always recieve this error; i.e. even if the 17th column to be updated is actually the 24th in the database the error still occurs. I am not using the CommandBuilder object because I have had problems with the default optimitic concurrency creating an SQL Update Command that is too large for Access, it has too many AND parameters.

At first I believed it to be a problem with the amount of data that I am updating with one single update call so I split the UpdateCommand into 4 different Commands, updated using the first update command, set the rows in the dataset to modified, changed the update command to the second one, etc...
This is how I determined that it is always the 17th column to be updated. If I have 16 columns in the first update command the first successfully completes and the error occurs in the second. However if I have 17 in the first the error occurs there. Any help appreciated and I will clarify and confusion or questions that you have.



Thank you for your time,

Blake M. Ward


-- modified at 13:31 Monday 5th March, 2007
AnswerRe: Trouble updating Access DB in C# Pin
Guffa5-Mar-07 9:03
Guffa5-Mar-07 9:03 
GeneralRe: Trouble updating Access DB in C# Pin
bward845-Mar-07 9:05
bward845-Mar-07 9:05 
Question.Net Framework version Problem Pin
Abu Syed Khan5-Mar-07 6:41
Abu Syed Khan5-Mar-07 6:41 
AnswerRe: .Net Framework version Problem Pin
Ed.Poore5-Mar-07 11:35
Ed.Poore5-Mar-07 11:35 
GeneralRe: .Net Framework version Problem Pin
Abu Syed Khan6-Mar-07 3:41
Abu Syed Khan6-Mar-07 3:41 
GeneralRe: .Net Framework version Problem Pin
Ed.Poore6-Mar-07 4:39
Ed.Poore6-Mar-07 4:39 
Questiongeneric collections of generic collections - .net 2.0 Pin
arkiboys5-Mar-07 6:12
arkiboys5-Mar-07 6:12 
AnswerRe: generic collections of generic collections - .net 2.0 Pin
led mike5-Mar-07 6:21
led mike5-Mar-07 6:21 
GeneralRe: generic collections of generic collections - .net 2.0 Pin
arkiboys5-Mar-07 6:27
arkiboys5-Mar-07 6:27 
GeneralRe: generic collections of generic collections - .net 2.0 Pin
Judah Gabriel Himango5-Mar-07 7:01
sponsorJudah Gabriel Himango5-Mar-07 7:01 
GeneralRe: generic collections of generic collections - .net 2.0 Pin
arkiboys5-Mar-07 21:32
arkiboys5-Mar-07 21:32 
GeneralRe: generic collections of generic collections - .net 2.0 Pin
led mike5-Mar-07 8:13
led mike5-Mar-07 8:13 
GeneralRe: generic collections of generic collections - .net 2.0 Pin
arkiboys5-Mar-07 19:00
arkiboys5-Mar-07 19:00 
GeneralRe: generic collections of generic collections - .net 2.0 Pin
led mike6-Mar-07 4:24
led mike6-Mar-07 4:24 
QuestionLocking data to user Pin
Dominik Reichl5-Mar-07 5:40
Dominik Reichl5-Mar-07 5:40 
AnswerRe: Locking data to user Pin
Dave Kreskowiak5-Mar-07 5:48
mveDave Kreskowiak5-Mar-07 5:48 
QuestionRe: Locking data to user Pin
Dominik Reichl5-Mar-07 5:58
Dominik Reichl5-Mar-07 5:58 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.