?
Solved

SqlCommandBuilder or manual updates?

Posted on 2008-10-27
2
Medium Priority
?
200 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 2000 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

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

It seems a simple enough task, yet I see repeated questions asking how to do it: how to pass data between two forms. In this article, I will show you the different mechanisms available for you to do just that. This article is directed towards the .N…
This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

765 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