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.

 All Forums
 Development Tools
 ASP.NET
 update question

Author  Topic 

alpoor
Starting Member

29 Posts

Posted - 2005-07-19 : 13:58:19
I have some 100+ fields in sql server table which will be displayed on webform in multiple panels. Most of the time I will be updating couple of fields only. What is the easiest way of updating the record without much coding.

jhermiz

3564 Posts

Posted - 2005-07-19 : 15:55:19
Easiest way is to bound data to some sort of dataview / grid, but it lacks performance. Why dont you just call an update procedure from your client application?


Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]
Imperfection living for perfection --
[url]http://jhermiz.blogspot.com/[/url]
Go to Top of Page

TheBluePhoenix
Starting Member

4 Posts

Posted - 2005-07-22 : 15:18:53
The “easiest” way may not be the “best” way. I would handle this like any other database edit task: create a method and stored procedure to handle the updates.

-----------------------------------------
Move like you have a purpose.
Go to Top of Page
   

- Advertisement -