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

C#

 
AnswerRe: Control Listner Pin
Pete O'Hanlon10-Aug-09 1:42
mvePete O'Hanlon10-Aug-09 1:42 
QuestionLogic I use.......?? Pin
Hum Dum9-Aug-09 20:35
Hum Dum9-Aug-09 20:35 
AnswerRe: Logic I use.......?? Pin
PIEBALDconsult9-Aug-09 20:42
mvePIEBALDconsult9-Aug-09 20:42 
GeneralRe: Logic I use.......?? Pin
Hum Dum9-Aug-09 21:01
Hum Dum9-Aug-09 21:01 
GeneralRe: Logic I use.......?? Pin
PIEBALDconsult9-Aug-09 21:19
mvePIEBALDconsult9-Aug-09 21:19 
GeneralRe: Logic I use.......?? Pin
Hum Dum9-Aug-09 21:59
Hum Dum9-Aug-09 21:59 
GeneralRe: Logic I use.......?? Pin
Pete O'Hanlon9-Aug-09 22:24
mvePete O'Hanlon9-Aug-09 22:24 
GeneralRe: Logic I use.......?? Pin
PIEBALDconsult10-Aug-09 5:59
mvePIEBALDconsult10-Aug-09 5:59 
Hum Dum wrote:
But all fields are same also data, except AgentID ?


No, and so what if it is? I suspect you're too new to database work to balk at such concepts.

User ( ID , Name , ... [ password , etc. ] )
1 , Alice , ...
2 , Bob , ...
3 , Carol , ...
4 , Ted , ...


Let's say Alice creates issue 1 and assigns it to Bob, you get:

(I'll use {} to indicate a datetime.)

Issue ( ID , CreatedByID , CreatedWhen , Description , ... )
1 , 1 , {} , "Normalize the database" , ...
2 , 1 , {} , "Document the code" , ...
3 , 1 , {} , "Peer review Ted's code" , ...


Then she assigns them to Bob:

Assignment ( IssueID , AssignedToID , AssignedByID , AssignedWhen , ... )
1 , 2 , 1 , {} , ...
2 , 2 , 1 , {} , ...
3 , 2 , 1 , {} , ...


Later, Carol may assign issues 1 and 2 to Ted:

Assignment ( IssueID , AssignedToID , AssignedByID , AssignedWhen , ... )
1 , 2 , 1 , {} , ...
2 , 2 , 1 , {} , ...
3 , 2 , 1 , {} , ...
1 , 4 , 3 , {} , ...
2 , 4 , 3 , {} , ...


So, you can see that no two rows are the same and can be quite different, especially as time goes on.

You'll need to learn about table JOINs.


Hum Dum wrote:
yes. is this incorrect?


Yes, at least store a hash of the password instead of the actual password:
0) When someone sets a password, store the hash. (I use SHA-1[^])
1) When someone logs in; take the provided password, hash it, and compare the new hash to the stored hash.
GeneralRe: Logic I use.......?? Pin
Hum Dum11-Aug-09 20:35
Hum Dum11-Aug-09 20:35 
GeneralRe: Logic I use.......?? Pin
PIEBALDconsult12-Aug-09 4:09
mvePIEBALDconsult12-Aug-09 4:09 
QuestionComboboxes in DataGrid Pin
AmbitiousBeginner9-Aug-09 20:31
AmbitiousBeginner9-Aug-09 20:31 
AnswerRe: Comboboxes in DataGrid Pin
PIEBALDconsult9-Aug-09 20:46
mvePIEBALDconsult9-Aug-09 20:46 
GeneralRe: Comboboxes in DataGrid Pin
AmbitiousBeginner9-Aug-09 20:52
AmbitiousBeginner9-Aug-09 20:52 
GeneralRe: Comboboxes in DataGrid Pin
PIEBALDconsult9-Aug-09 21:23
mvePIEBALDconsult9-Aug-09 21:23 
AnswerRe: Comboboxes in DataGrid Pin
stancrm9-Aug-09 20:48
stancrm9-Aug-09 20:48 
GeneralRe: Comboboxes in DataGrid Pin
AmbitiousBeginner9-Aug-09 21:18
AmbitiousBeginner9-Aug-09 21:18 
GeneralRe: Comboboxes in DataGrid Pin
stancrm9-Aug-09 21:22
stancrm9-Aug-09 21:22 
QuestionHow to update MS Access database in the installed application? Pin
Sifar - 09-Aug-09 17:38
Sifar - 09-Aug-09 17:38 
AnswerRe: How to update MS Access database in the installed application? Pin
Ennis Ray Lynch, Jr.9-Aug-09 18:27
Ennis Ray Lynch, Jr.9-Aug-09 18:27 
QuestionRegular Expressions [modified] Pin
Mikey_H9-Aug-09 17:29
Mikey_H9-Aug-09 17:29 
AnswerRe: Regular Expressions Pin
PIEBALDconsult9-Aug-09 21:33
mvePIEBALDconsult9-Aug-09 21:33 
GeneralRe: Regular Expressions Pin
Mikey_H10-Aug-09 9:30
Mikey_H10-Aug-09 9:30 
GeneralRe: Regular Expressions Pin
PIEBALDconsult10-Aug-09 9:53
mvePIEBALDconsult10-Aug-09 9:53 
QuestionUnable to send image on UDP larger than 10K Pin
atifmuzaffar9-Aug-09 15:55
atifmuzaffar9-Aug-09 15:55 
AnswerThis may sound silly but Pin
Ennis Ray Lynch, Jr.9-Aug-09 18:23
Ennis Ray Lynch, Jr.9-Aug-09 18:23 

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.