By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,403 Members | 891 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,403 IT Pros & Developers. It's quick & easy.

anyone using CommandBuilder to generate update logic at runtime?

P: n/a
What we've done so far in our web applications:
1. We have no datasets dragged-and-dropped in Visual Studio. They are all
defined in the code, generated at runtime.
2. when a user updates or hits a 'delete' button next to a row in a
datagrid, we call a webservice. In there, we coded insert, update & delete
functionality.

I'm tired of seeing all that update logic in our code. I am looking for a
way to have .NET generate its own update / delete / insert statements. BUT,
I don't want to use that DataAdapter Configuration Wizard because if we
change around a field in the db, everything breaks and there's too much
going on under the hood to fix it. If a query changes in our dataset, I
would like the update logic to automatically change as well. I've been
looking at CommandBuilder -- is this something good to use? In order to use
it, do I need to define the dataset at Design Time (visually drag it on to
the web service etc) ?

Any other suggestions would be appreciated
TY
Jason Shohet
Nov 15 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
CommandBuilder isn't going to do this automatically. If you find it does,
let me know. :-) I'd use the DA Config Wiz. If you change a field, go back
through the wiz and tell it to regenerate. If you have classes that use
this as a independent object, it should be simple to go back and add/remove
the edits you make to that particular table.

Nick Harris, MCSD
http://www.VizSoft.net
" Jason Shohet" <as****@hotmail.com> wrote in message
news:O1**************@TK2MSFTNGP11.phx.gbl...
What we've done so far in our web applications:
1. We have no datasets dragged-and-dropped in Visual Studio. They are all defined in the code, generated at runtime.
2. when a user updates or hits a 'delete' button next to a row in a
datagrid, we call a webservice. In there, we coded insert, update & delete functionality.

I'm tired of seeing all that update logic in our code. I am looking for a
way to have .NET generate its own update / delete / insert statements. BUT, I don't want to use that DataAdapter Configuration Wizard because if we
change around a field in the db, everything breaks and there's too much
going on under the hood to fix it. If a query changes in our dataset, I
would like the update logic to automatically change as well. I've been
looking at CommandBuilder -- is this something good to use? In order to use it, do I need to define the dataset at Design Time (visually drag it on to
the web service etc) ?

Any other suggestions would be appreciated
TY
Jason Shohet

Nov 15 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.