Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
 Posted - 2007-03-20 : 10:14:46
|
| hi All,i normally use SP to modify data in my database, however with the new wizards in .net (GRID VIEW) that allow direct modification of data with update, delete and insert statements...... though quite easy to use, i feel a bit uncomfortable allowing direct modification of data.Any advice, suggestions, comments, opinions on this ???thanksEhi |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-03-20 : 10:33:31
|
| I vote for SP. For me, it doesn't matter how much easy it is to generate the code, but it does matter what is the quality of the code produced.Generally, I use those GUI features only to get the feel of the control/environment or to build some quick-n-dirty apps but when it comes to serious work, I don't even bother to consider it.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
jhermiz
3564 Posts |
Posted - 2007-03-20 : 11:09:45
|
quote:
Originally posted by afrika
hi All,i normally use SP to modify data in my database, however with the new wizards in .net (GRID VIEW) that allow direct modification of data with update, delete and insert statements...... though quite easy to use, i feel a bit uncomfortable allowing direct modification of data.Any advice, suggestions, comments, opinions on this ???thanksEhi
You have to be careful with code like this as at times it means a direct connection to the database at all times.Programmers HowTo's -- [url]http://jhermiz.googlepages.com[/url] |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2007-03-20 : 11:31:09
|
quote:
You have to be careful with code like this as at times it means a direct connection to the database at all times.
Can you explain this a little more? I'm not quite sure what you mean. I thought that in ASP.NET as soon as the page is rendered and returned, all database connections are closed since the page object doesn't persist. Or maybe you were referring to windows forms apps, not web apps?- Jeffhttp://weblogs.sqlteam.com/JeffS |
|
|
|
jhermiz
3564 Posts |
Posted - 2007-03-20 : 14:05:24
|
quote:
Originally posted by jsmith8858
quote:
You have to be careful with code like this as at times it means a direct connection to the database at all times.
Can you explain this a little more? I'm not quite sure what you mean. I thought that in ASP.NET as soon as the page is rendered and returned, all database connections are closed since the page object doesn't persist. Or maybe you were referring to windows forms apps, not web apps?- Jeffhttp://weblogs.sqlteam.com/JeffS
Sorry was referring to win forms. Ugh I do this a lot on the asp.net forum...Programmers HowTo's -- [url]http://jhermiz.googlepages.com[/url] |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2007-03-20 : 14:24:38
|
quote:
Originally posted by harsh_athalye
I vote for SP. For me, it doesn't matter how much easy it is to generate the code, but it does matter what is the quality of the code produced.Generally, I use those GUI features only to get the feel of the control/environment or to build some quick-n-dirty apps but when it comes to serious work, I don't even bother to consider it.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED"
quote:
Originally posted by jhermiz
quote:
Originally posted by afrika
hi All,i normally use SP to modify data in my database, however with the new wizards in .net (GRID VIEW) that allow direct modification of data with update, delete and insert statements...... though quite easy to use, i feel a bit uncomfortable allowing direct modification of data.Any advice, suggestions, comments, opinions on this ???thanksEhi
You have to be careful with code like this as at times it means a direct connection to the database at all times.Programmers HowTo's -- [url]http://jhermiz.googlepages.com[/url]
I agree with you guys there. thanks |
|
|
|
|
|
|
|
|
Visual Studio GRID VIEW: commands vs SP