Configuring a data adapter

[sparkle999]

I can't believe this:

 

I have an database table with 101 columns. They are all genuine attributes of that entity, i.e. this is a 'customer' table with lots of information about that customer.

 

I run into problems when configuring a dataadapter - works ok up to 100 columns, but no more than that.

 

Can anyone confirm this to be the case - I can't find anything the MS knowledge base.

 

If this *is* the case, then what do I do?! I need to maintain this table (adds, inserts, updates, deletes). Any ideas?

 

Thanks in advance!

[Robby]

Are you using OLEDB or SqlClient ? (Not that it should make any difference)

[Denaes]

One of the best ways to learn with OleDB (I'm not sure about SQL Server) is to create your dataase and add it to your server explorer, then drag the table onto your form designer. It will create a dataadaptor in which you can go in and look at the sql statements and the peramaters. It might throw you an error if you can't have 101 columns in a database.

[Robby]

It seems that the OLE DA is limited to 100 columns.

[Robby]

SqlClient is also 100 columns max. A way around this is to design your table structure with some normalization.

[sparkle999]

Thanks - not the answer I wanted !

 

Yes, I'm using SqlClient, and you are correct, there *are* some things I can do with normalisation, at the expense of introducing additional complexity - just creates loads more work! :mad:

[Denaes]

Yeah, its often easier to make a 101 column table than it is to make 15 tables related with the same data.

[Robby]

Second or Third normal is usually best. read this http://www.4guysfromrolla.com/webtech/042699-1.shtml