Click here to Skip to main content
15,887,485 members
Home / Discussions / C#
   

C#

 
GeneralRe: Open An HTML File Using Web Broswer Pin
Mazdak17-Nov-02 23:12
Mazdak17-Nov-02 23:12 
GeneralRe: Open An HTML File Using Web Broswer Pin
Vasudevan Deepak Kumar17-Nov-02 23:13
Vasudevan Deepak Kumar17-Nov-02 23:13 
GeneralAnother DataEntry Pin
Mazdak17-Nov-02 19:35
Mazdak17-Nov-02 19:35 
GeneralDetermine Type of OS That User Used Pin
yccheok17-Nov-02 16:08
yccheok17-Nov-02 16:08 
GeneralRe: Determine Type of OS That User Used Pin
Nick Parker17-Nov-02 16:17
protectorNick Parker17-Nov-02 16:17 
GeneralRe: Determine Type of OS That User Used Pin
Vasudevan Deepak Kumar17-Nov-02 23:39
Vasudevan Deepak Kumar17-Nov-02 23:39 
GeneralComplex relational database Pin
laphijia17-Nov-02 11:19
laphijia17-Nov-02 11:19 
GeneralRe: Complex relational database Pin
Marc Clifton17-Nov-02 13:50
mvaMarc Clifton17-Nov-02 13:50 
I don't think there is a quick answer to your question, but I'd be willing to dialog with you about it for a while and share with you my techniques dealing with normalized databases. Beware though, I don't use a lot of what ADO.NET provides--instead, I tend to code client or server side SQL directly, depending on the requirements.

That said, it seems that ADO.NET can handle relationships between tables, as long as you tell it what those relationships are, and it should handle updating records correctly (I think. I've never tried this). [personal comment--I've never used this feature because I think it is really stupid to duplicate the database model in the code: what if you want to change the DB model?]

Also, have you set up foreign keys so that deletes and updates are cascaded? This can save you a lot of programming time.

Also, if you can provide some specific examples of what you are trying to do, it might be easier to consider what the different solutions are and their benefits/drawbacks.

Finally, hierarchical architectures are a PITA. Since you seem to only have a three level hierarchy, I think the best thing to do is to deal with the individual insert/update/delete/select statements. I had to create a model for a satellite company once that allowed basically infinite drill down in a hierarchy. Argh.

Marc


Help! I'm an AI running around in someone's f*cked up universe simulator.
GeneralBinary Registry Entry Pin
Jassim Rahma17-Nov-02 10:30
Jassim Rahma17-Nov-02 10:30 
GeneralRe: Binary Registry Entry Pin
Mazdak17-Nov-02 19:52
Mazdak17-Nov-02 19:52 
GeneralMy Own Database File Pin
Jassim Rahma17-Nov-02 9:28
Jassim Rahma17-Nov-02 9:28 
GeneralRe: My Own Database File Pin
Vasudevan Deepak Kumar17-Nov-02 23:21
Vasudevan Deepak Kumar17-Nov-02 23:21 
GeneralAudio Files in DLL Pin
Jassim Rahma17-Nov-02 9:24
Jassim Rahma17-Nov-02 9:24 
GeneralRe: Audio Files in DLL Pin
Jassim Rahma21-Nov-02 14:27
Jassim Rahma21-Nov-02 14:27 
GeneralKeyboard Language Pin
Jassim Rahma17-Nov-02 9:09
Jassim Rahma17-Nov-02 9:09 
GeneralRe: Keyboard Language Pin
Mazdak17-Nov-02 18:44
Mazdak17-Nov-02 18:44 
GeneralInvoice Printing Pin
Jassim Rahma17-Nov-02 9:06
Jassim Rahma17-Nov-02 9:06 
GeneralRegex question Pin
leppie17-Nov-02 8:05
leppie17-Nov-02 8:05 
GeneralRe: Regex question Pin
Bog18-Nov-02 14:52
Bog18-Nov-02 14:52 
GeneralCodeProject reformatted me Pin
Bog18-Nov-02 14:53
Bog18-Nov-02 14:53 
GeneralAAAAARRGH Pin
Bog18-Nov-02 14:55
Bog18-Nov-02 14:55 
GeneralRe: AAAAARRGH Pin
leppie19-Nov-02 11:19
leppie19-Nov-02 11:19 
GeneralAccessing menu items from UserControl Pin
Paul Silvernail17-Nov-02 4:46
Paul Silvernail17-Nov-02 4:46 
GeneralRe: Accessing menu items from UserControl Pin
djkno317-Nov-02 5:14
djkno317-Nov-02 5:14 
GeneralDirectoryEntry Pin
Mazdak17-Nov-02 3:15
Mazdak17-Nov-02 3:15 

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.