how to use command builder...

Good Day

Here is some examples

http://msdn.microsoft.com/en-us/library/ms971491.aspx

http://www.programmersheaven.com/2/FAQ-ADONET-CommandBuilder-Prepare-Dataset

Thank you for Posting at DotnetFunda

Vuyiswa Maseko

Thank you for posting at Dotnetfunda
[Administrator]

Gopal_nivas, if this helps please login to Mark As Answer. | Alert Moderator

I have not heard of the CommandBuilder before.

I think it is a dead technology as this MSDN document written in 2003 is specifically aimed at discouraging developers from using it:

http://msdn.microsoft.com/en-us/library/ms971491.aspx

Gopal_nivas, if this helps please login to Mark As Answer. | Alert Moderator

I despise Wizards when i do my database work. Command Builder was one of the Wizards , that a Programmer did through code.

Thank you for posting at Dotnetfunda
[Administrator]

Gopal_nivas, if this helps please login to Mark As Answer. | Alert Moderator

Yeah I dislike wizards to a certain extent.

I started out by learning ado.net strongly typed datasets and that was a good way to get started but complicated when you wanted to do anything more advanced.

I still think the data canvas linq to sql provides which generates all the boilerplate code is very useful.

I also prefer the wizard / ui for managing my gridview, detailsview etc columns.

At the end of the day I only use the ones that have been proven to be trustworthy.

Gopal_nivas, if this helps please login to Mark As Answer. | Alert Moderator

That is Exactly my Problem. I dont use Wizards in anything that has to do with Databases. They are limited and the moment you realise that , is the time you have to start writting code you ran away a long time ago. Adapter Wizard does not Support Joins when it has to Update.Because it does not know which table to Update, so this means you have to write your own Data Layer. i Hate it , i know what Wizards can do to a good Programmer. They will spoil you until you forget the Basics :)

Thank you for posting at Dotnetfunda
[Administrator]

Gopal_nivas, if this helps please login to Mark As Answer. | Alert Moderator