 |
interactive | editorial | code | resource |
|
|
Single tables |
Multiple tables |
Advanced Searching |
Demonstration using the Northwind database included with SQL server |
Advanced Demonstrations using QuickAdmin v1.1
You are line manager Andrew Fuller and you want to edit the employees table. |
You are Michael Suyama and you take and place orders for your customers. |
|
|
Demonstrations > Advanced Demonstrations > Employee Example
Viewing the Employees Table as Andrew Fuller.
Displayed below is Andrew Fuller's record and the Employees for whom he is their
Line-manager. Andrew can...
-
Edit any of the Employees who have him as their Line-Manager
-
View his record (it doesn't hold any sensitive information)
-
Add an Employee with himself set to the Line-Manager
Feel free
to try any of the above options.
|
| Results |
|---|
|
| Search |
|---|
| | Advanced |
|---|
| Territory | |
| Hire Date | |
| Setting the WhereClause to
"(Employees.EmployeeID = 2 OR Employees.ReportsTo = 2)"
in the SearchingEventArgs in the OnSearching event,
filters the results so you only see the Employees
you are in-charge of and yourself in the results. |
|
Html View Code
Click here to view all the Html View code that is used to generate this page.
|
|
|
|
Code Behind Code
Click here to view all the code-behind that is used to generate this page.
|
|
Demonstrations > Advanced Demonstrations > Employee Example | |
|
Here's a representation of the database:  |
|
|
 |
You are not logged in. |
Quick search:
|
This site is part of the allasp.net network. Take a look at our great ASP.NET components: dbcombo.net
Web combo-box that autocompletes values from the server as you type! Great for selecting from long lists. quickadmin.net
Professional database admin pages in minutes rather than days! - fully ranked search / view / add / edit etc. imageadmin.net
Web-based image upload manager. Lets you set criteria on uploaded images to enforce consistency. |
|