Click here to Skip to main content
16,008,490 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: Help with gridview.. Pin
cometburn0071-Aug-07 17:54
cometburn0071-Aug-07 17:54 
GeneralRe: Help with gridview.. Pin
Michael Sync1-Aug-07 18:00
Michael Sync1-Aug-07 18:00 
GeneralRe: Help with gridview.. Pin
T.EDY1-Aug-07 18:05
T.EDY1-Aug-07 18:05 
GeneralRe: Help with gridview.. Pin
cometburn0071-Aug-07 18:25
cometburn0071-Aug-07 18:25 
GeneralRe: Help with gridview.. Pin
T.EDY1-Aug-07 18:53
T.EDY1-Aug-07 18:53 
GeneralRe: Help with gridview.. Pin
cometburn0071-Aug-07 19:17
cometburn0071-Aug-07 19:17 
GeneralRe: Help with gridview.. Pin
T.EDY1-Aug-07 20:39
T.EDY1-Aug-07 20:39 
GeneralOf datagrids, database constraints and other short stories... Pin
Malcolm Smart1-Aug-07 11:49
Malcolm Smart1-Aug-07 11:49 
I usually roll my own 'admin' type grids, where users can add new rooms, add new departments etc to an app. No problem. I've been looking at the DataGrid (a tad late in the day maybe) and have a few questions...

Basic Database Table For Room:-

ID   DESCRIPTION
1    Room 1
2    Room 2
3    Room 3


Obviously, ideal for a datagrid to add, update, delete etc. All fine up to now.

Table for Subject

ID   DESCRIPTION
1    Subject 1
2    Subject 2
3    Subject 3


Again, no problem, users happily adding subjects.

Now....Teachers. (This is all hypothetical by the way....)

ID DESCRIPTION ROOMID SUBJECTID
1  Mr Big      1      2
2  Mr Large    2      3


The RoomID and SUbjectID are constrained in MS SQL so only rooms and subjects that exist can be used. When displayed on the front end, this would show Mr Big, Room 1, Subject 2. But...how would I get the user to populate this sort of table using the built in datagrid (or other controls)? Rolling my own, I usually have a label showing the word 'room' and when clicked, it magically turns into a dropdown with the available rooms, the same for subjects. But does ASP.NET have some magic stuff that allows me to do similar?

All the samples of the datagrid I see are for flat tables, not relational like this, or if they are relational, they are 'select' only. Happy to be made to look stupid and have a google link posted in all it's glory that i missed...



"More functions should disregard input values and just return 12. It would make life easier." - comment posted on WTF

Questionhow can i use LINQ to query in xml? Pin
kimo code1-Aug-07 8:43
kimo code1-Aug-07 8:43 
AnswerRe: how can i use LINQ to query in xml? Pin
Not Active1-Aug-07 9:40
mentorNot Active1-Aug-07 9:40 
GeneralRe: how can i use LINQ to query in xml? Pin
kimo code1-Aug-07 9:47
kimo code1-Aug-07 9:47 
GeneralRe: how can i use LINQ to query in xml? Pin
Not Active1-Aug-07 9:49
mentorNot Active1-Aug-07 9:49 
GeneralRe: how can i use LINQ to query in xml? Pin
Pete O'Hanlon1-Aug-07 9:53
mvePete O'Hanlon1-Aug-07 9:53 
GeneralRe: how can i use LINQ to query in xml? Pin
kimo code1-Aug-07 9:53
kimo code1-Aug-07 9:53 
AnswerRe: how can i use LINQ to query in xml? Pin
eggie51-Aug-07 18:43
eggie51-Aug-07 18:43 
QuestionChange Password Issue Pin
Brendan Vogt1-Aug-07 8:36
Brendan Vogt1-Aug-07 8:36 
AnswerRe: Change Password Issue Pin
Pete O'Hanlon1-Aug-07 9:26
mvePete O'Hanlon1-Aug-07 9:26 
QuestionEmbedding swf file in ASP.Net page Pin
h@$@n1-Aug-07 8:17
h@$@n1-Aug-07 8:17 
AnswerRe: Embedding swf file in ASP.Net page Pin
Pete O'Hanlon1-Aug-07 9:25
mvePete O'Hanlon1-Aug-07 9:25 
QuestionFSO help required. Creating/Saving a File object Pin
iamguyster1-Aug-07 8:15
iamguyster1-Aug-07 8:15 
Questionhelp Pin
mazinalkthere1-Aug-07 8:05
mazinalkthere1-Aug-07 8:05 
AnswerRe: help Pin
leckey1-Aug-07 8:14
leckey1-Aug-07 8:14 
AnswerRe: help Pin
Not Active1-Aug-07 9:47
mentorNot Active1-Aug-07 9:47 
Questionis there a way to loop throught the webpages in my application ? Pin
kimo code1-Aug-07 7:55
kimo code1-Aug-07 7:55 
AnswerRe: is there a way to loop throught the webpages in my application ? Pin
N a v a n e e t h3-Aug-07 22:08
N a v a n e e t h3-Aug-07 22:08 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.