Solved

SqlCommandBuilder or manual updates?

Posted on 2008-10-27
2
190 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

The object model of .Net can be overwhelming at times – so overwhelming that quite trivial tasks often take hours of research. In this case, the task at hand was to populate the datagrid from SQL Server database in Visual Studio 2008 Windows applica…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

770 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