Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sqlserver webform application design

Status
Not open for further replies.

evilmousse

Programmer
Apr 15, 2003
85
0
0
US

I'm working on some forms for a sqlserver asp.net webforms application.
These forms will deal with only one db record's information at a time.

It appears that only simple controls (combobox etc) and the all-powerful
datagrid control have binding and committal functionality.

Therefore I see my options as
a) use a datagrid. I believe I must disqualify this though, because the
number of fields are far beyond screen-length and I'm not displaying more
than one record. Hence, unless I can break a datagrid's normally tabular
display, I don't think this is the option.

b) implement my own transactional integrity accross standard textbox /
combobox controls. Using a dataset to prepopulate the controls,
strong data validation, and well-structured try-catch clauses & error
handling, issue my own sql insert/updates directly to the db.

Are there options available to me that I don't see? I'm honestly very
accustomed to MSAccess's binding controls to datasources, and I'm
kind of longing for them... Not that I can't code what I see needs to be
done in option b, I'd just rather save what work I can.

-evilme
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top