Solved

SqlCommandBuilder or manual updates?

Posted on 2008-10-27
2
192 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

IP addresses can be stored in a database in any of several ways.  These ways may vary based on the volume of the data.  I was dealing with quite a large amount of data for user authentication purpose, and needed a way to minimize the storage.   …
For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…

749 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