not use data bound controls

Question

I am a long time VB programmer (VB3 to VB6) just getting into c#. I have always hated data bound controls. You lose too much control over the data, the data validation, editing, updating etc. etc.

For example (but not the only issue) a user starts to edit the data for a customer. When they get to the state field the realize the don't know so they try to hit the cancel button so the can go and find out. The validation says the MUST enter a state and does not allow the cancel. I know they could enter a fake state, but (1) this stinks - enter fake data just to exit a screen, (2) they are from a foreign country and do not have a clue as to what fake data to enter.

I am looking for a good book or source to learn ado + c# that DOES NOT focus on data binding. I have spent way too much time searching the net on this issue. Any information would be a big help.

Please do not say "just use data binding" that is the whole point of this request.

theLizard · Answer

I will be happy to help I also used vb3 but did not like the versions after it so moved to c++ builder I use c# but prefer c++ way more control.

Arkay Mann · Answer

Lizard Thanks for the reply. I am new to the group and so am not familiar with Giorgio but I am going to do some looking this evening.

Hirendra Sisodiya · Answer

check this link http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson01.aspx thanks

theLizard · Answer

Good to see there are others who also HATE data bound controls if you follow the threads by Giorgio here you will find a post that has a class which will give you examples of loading list boxes grids combo boxes without the need of any bindings. If you have already done similar with VB you should understand the examples.