Solved

SqlCommandBuilder or manual updates?

Posted on 2008-10-27
2
188 Views
Last Modified: 2013-11-08
Im going to build a test application that connects a database and it is multi-user.
Would be the SQlCommandBuilder sufficient to update, delete and insert records or should I do the updates manually ?
I dont know in which situations I could encounter problems with the command builder. Any suggestions or ideas on this?

thanks!
0
Comment
Question by:arcross
  • 2
2 Comments
 
LVL 16

Expert Comment

by:ororiole
ID: 22814385
If you know even a moderate amount of SQL, I would write them myself, and put them in the Command object. Using builder produces an extremely large amount of code, that is bady written and hard to follow. I have only used it twice, and it worked, but if you look at the commands it generates they are just huge.

0
 
LVL 16

Accepted Solution

by:
ororiole earned 500 total points
ID: 22814484
Oh and if your sql isnt as strong, use the wizards to build your commands. I know they work great on SQL server.  Use a SqlDataSource control and let it walk you thru. Or in the right side by solution explorer you should see or can bring up the database explorer. Right click on the database you want and it will let you check the parts of the query you need. Both are pretty easy, sqlDataSource maybe easiest
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Flash (http://en.wikipedia.org/wiki/Adobe_Flash) has evolved over the years to where it has become a masterful tool for displaying content screen.  It has excellent layout placement, UI precision as well as rendering capabilities. This, along with t…
More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now