• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 223
  • Last Modified:

SqlCommandBuilder or manual updates?

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
arcross
Asked:
arcross
  • 2
1 Solution
 
ororioleCommented:
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
 
ororioleCommented:
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now