>>I can only say for the future developers - don't try to use DataSet/TA designer unless MS will make them easier to use / more configurable.
>
>Naomi, I just want to clarify that it's not the DataSet that's causing you headaches, it's the TableAdapter. You can still utilize the DataSet designer, but do it using the XML view rather than the designer that shows the tables like a visio diagram ... as soon as you use that, it'll auto-gen the damn TableAdapters as soon as you save any changes. Does anyone know if you can turn that off? The only way I've found is just to never open that version of the designer (or at least don't save changes from that "view" if you inadvertently open it).
>
>~~Bonnie
>
>
>
>
>>>Hi everybody,
>>>
>>>I read this http://www.experts-exchange.com/Programming/Languages/C_Sharp/Q_24094031.html
>>>
>>>Just want to clarify. If I create a new TA class named the same and copy the code from the designer and then change it manually, can I get rid of the original designer generated class and use this one exactly the same way as the one generated?
>>>
>>>I found I'm stack with the auto-generated class and can not do anything - I'd rather apply my changes now manually - it should not be very hard, I hope.
>>>
>>>Thanks in advance.
>>
>>Somehow I can not get it to work / not sure how exactly to program and would it help me or not.
>>
>>I guess I don't have any luck anymore getting this question resolved / receiving any help from colleagues here.
>>
>>I can only say for the future developers - don't try to use DataSet/TA designer unless MS will make them easier to use / more configurable.

The only option I know of is one I came across by accident - you can change where the code is generated:

http://www.u2u.info/Blogs/Peter/Lists/Posts/Post.aspx?ID=246