Why SqlCommandBuilder

[Krishna Varadharajan]

Hi, I know the functionality of sqlcommandBuilder. But when to use sqlcommandbuilder instant of sql query. If sqlcommandBuilder does everything( insert/update/delete ), than why I required sql query's. I can do everything through sqlcommandBuilder rite. Is there any particular sinario that i can use sqlcommandBuilder or I cant use sqlcommandBuilder ? krishna

[Lost User]

krishnavaradharajan wrote:

If sqlcommandBuilder does everything( insert/update/delete ), than why I required sql query's.

It doesn't do "everything", just the crud-operations. It's not used when creating a table using a query, or when things get complex. As the documentation states, it only generates a single-table update.

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

[Krishna Varadharajan]

Hi Mr.Eddy, So you mean to say that, commanbuilder can be used only for simple and single query operation. Another thing is, consider I have a dataset(ds) of 1000 records, and how do I edit dataset, means how to update without using commanbuilder and fetch only updated rows from ds. krishna

[PIEBALDconsult]

krishnavaradharajan wrote:

when to use sqlcommandbuilder

Never.

[Krishna Varadharajan]

Do you have any particular reason to say never.. krishna

[Lost User]

krishnavaradharajan wrote:

So you mean to say that, commanbuilder can be used only for simple and single query operation.

Yup. It's a shortcut, an easy way to generate a simple query.

krishnavaradharajan wrote:

Another thing is, consider I have a dataset(ds) of 1000 records, and how do I edit dataset, means how to update without using commanbuilder and fetch only updated rows from ds.

The GetChanges method will give you everything that changed in the dataset.

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

[PIEBALDconsult]

Experience. It has always bitten me with its limitations. Plus it's closely associated with DataAdapter which is even worse.

[Krishna Varadharajan]

Thank you... krishna

[Krishna Varadharajan]

Thank you.. :) krishna

[Lost User]

You're welcome :)