Click here to Skip to main content
15,895,084 members
Home / Discussions / C#
   

C#

 
QuestionHooking 456 port Pin
akshayswaroop11-Sep-05 1:30
akshayswaroop11-Sep-05 1:30 
AnswerRe: Hooking 456 port Pin
KaptinKrunch12-Sep-05 9:33
KaptinKrunch12-Sep-05 9:33 
GeneralRe: Hooking 456 port Pin
Anonymous12-Sep-05 18:53
Anonymous12-Sep-05 18:53 
QuestionDefault Printer Pin
teeka11-Sep-05 1:08
teeka11-Sep-05 1:08 
AnswerRe: Default Printer Pin
Mohamad Al Husseiny11-Sep-05 8:37
Mohamad Al Husseiny11-Sep-05 8:37 
QuestionDockable interface Pin
rmedo11-Sep-05 0:41
rmedo11-Sep-05 0:41 
AnswerRe: Dockable interface Pin
S. Senthil Kumar11-Sep-05 2:51
S. Senthil Kumar11-Sep-05 2:51 
Questiondata relationship Pin
steve_rm10-Sep-05 23:12
steve_rm10-Sep-05 23:12 
Hello

I am creating some relationships in code. I have 3 tables Position, Department, and Employee. The relationship is a one to many for these tables. See the details below.

PositionNames are manager, secretary etc
Position - PositionID (PK), PositionName

Department - DepartmentCode (PK), NameOfDepartment

Employee - EmployeeNo (PK), Name, Address, PositionID(FK), DepartmentCode(FK)

I have created a relation with the department and employee as follows:

<br />
DataColumn parentColumn = ds.Tables["Department"].Columns["DepartmentCode"]; <br />
                DataColumn childColumn = ds.Tables["Employee"].Columns["DepartmentCode"];             <br />
<br />
                ds.Relations.Clear(); <br />
                dRelEmployees = new DataRelation("EmployeeDetails",parentColumn,childColumn); <br />
                ds.Relations.Add(dRelEmployees); <br />


My problem is l want to add another parent column for the position, do l need to repeat all this code just for the position table. Or can l add another parentColumn and add them all to the dRelEmployees DataSet.

Not sure how to do this.

Thanks in advance,

Steve
AnswerRe: data relationship Pin
Guffa10-Sep-05 23:59
Guffa10-Sep-05 23:59 
QuestionWeb enable a Windows C# app Pin
StrayGrey10-Sep-05 20:06
StrayGrey10-Sep-05 20:06 
AnswerRe: Web enable a Windows C# app Pin
Guffa11-Sep-05 0:02
Guffa11-Sep-05 0:02 
QuestionDataTable PlaceHolder Pin
Expert Coming10-Sep-05 18:40
Expert Coming10-Sep-05 18:40 
AnswerRe: DataTable PlaceHolder Pin
rudy.net11-Sep-05 16:41
rudy.net11-Sep-05 16:41 
QuestionUsing GDI+ functions in a class library Pin
Steve Messer10-Sep-05 17:43
Steve Messer10-Sep-05 17:43 
AnswerRe: Using GDI+ functions in a class library Pin
Andrew Kirillov10-Sep-05 21:03
Andrew Kirillov10-Sep-05 21:03 
GeneralRe: Using GDI+ functions in a class library Pin
Steve Messer10-Sep-05 21:39
Steve Messer10-Sep-05 21:39 
QuestionMessageBox erases lines drawn???? Pin
Anonymous10-Sep-05 16:00
Anonymous10-Sep-05 16:00 
AnswerRe: MessageBox erases lines drawn???? Pin
Dave Kreskowiak10-Sep-05 16:17
mveDave Kreskowiak10-Sep-05 16:17 
QuestionAnyway to be notified of time changes Pin
monrobot1310-Sep-05 13:27
monrobot1310-Sep-05 13:27 
AnswerRe: Anyway to be notified of time changes Pin
Mohamad Al Husseiny10-Sep-05 14:33
Mohamad Al Husseiny10-Sep-05 14:33 
GeneralRe: Anyway to be notified of time changes Pin
Dave Kreskowiak10-Sep-05 16:08
mveDave Kreskowiak10-Sep-05 16:08 
GeneralRe: Anyway to be notified of time changes Pin
Mohamad Al Husseiny11-Sep-05 7:22
Mohamad Al Husseiny11-Sep-05 7:22 
GeneralRe: Anyway to be notified of time changes Pin
Dave Kreskowiak12-Sep-05 1:25
mveDave Kreskowiak12-Sep-05 1:25 
AnswerRe: Anyway to be notified of time changes Pin
Dave Kreskowiak10-Sep-05 16:09
mveDave Kreskowiak10-Sep-05 16:09 
AnswerRe: Anyway to be notified of time changes Pin
Andy Brummer10-Sep-05 17:11
sitebuilderAndy Brummer10-Sep-05 17:11 

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.