Display relationship in a devexpress grid

There are 2 Objects with a relationship between them.
Student and Class.
Each student has one or more classes. I want to show student in a grid control (devexpress winform) and I prefer not to use master detail. I want to show classes in a single column, like : class A-class B (in a single row) or split the row like merging.

asked Nov 20 '18 at 6:38

mtf

138

You could do this in your sql statement also, sql server has the stuff statement you can use to concatinate all classes per student into one column. Other databases wlll have other commands, you did not say where your data comes from

– GuidoG
Nov 20 '18 at 10:26

add a comment |

asked Nov 20 '18 at 6:38

mtf

138

You could do this in your sql statement also, sql server has the stuff statement you can use to concatinate all classes per student into one column. Other databases wlll have other commands, you did not say where your data comes from

– GuidoG
Nov 20 '18 at 10:26

add a comment |

asked Nov 20 '18 at 6:38

mtf

138

c# winforms grid devexpress xpo

asked Nov 20 '18 at 6:38

mtf

138

asked Nov 20 '18 at 6:38

mtf

138

asked Nov 20 '18 at 6:38

mtf

138

asked Nov 20 '18 at 6:38

mtf

138

asked Nov 20 '18 at 6:38

mtf

138

You could do this in your sql statement also, sql server has the stuff statement you can use to concatinate all classes per student into one column. Other databases wlll have other commands, you did not say where your data comes from

– GuidoG
Nov 20 '18 at 10:26

add a comment |

You could do this in your sql statement also, sql server has the stuff statement you can use to concatinate all classes per student into one column. Other databases wlll have other commands, you did not say where your data comes from

– GuidoG
Nov 20 '18 at 10:26

You could do this in your sql statement also, sql server has the stuff statement you can use to concatinate all classes per student into one column. Other databases wlll have other commands, you did not say where your data comes from

– GuidoG
Nov 20 '18 at 10:26

add a comment |

2 Answers
2

active

oldest

votes

It is possible to create an unbound column to populate it with your detail data. See the How to access a detail view's data within the CustomUnboundColumnData event handler example to learn how to do this.

answered Nov 20 '18 at 6:51

Svetlana

33613

Can you write an example in c# for this purpose, please? - @svetlana

– mtf
Nov 20 '18 at 12:56

You can download the mentioned example by using the provided link above. Once you go to there, you will see the Download button. Alternatively, you can download this project directly from GitHub (github.com/DevExpress-Examples/…)

– Svetlana
Nov 20 '18 at 19:33

add a comment |

From what database is this info coming ?

If you are using Sql Server you can merge the data in your query like this

declare @student table (studentid int, name varchar(20))

declare @class table (classid int, name varchar(20))

declare @studentclass table (studentid int, classid int)



insert into @student values (1, 'john'), (2, 'mary')

insert into @class values (1, 'english'), (2, 'mathematics')

insert into @studentclass values (1, 1), (1, 2), (2, 1)



select s.studentid,

       s.name,

       stuff(( replace (( select ' - ' + c.name

                          from   @class c

                            inner join @studentclass sc on c.classid = sc.classid

                          where  sc.studentid = s.studentid

                          order by c.name

                          For XML PATH ('')), '', '')

             ), 1, 3, '') as classes

from   @student s

This will return this result :

studentid   name    classes 

---------   ----    ------- 

1           john    english - mathematics   

2           mary    english

Other databases can do this also, the syntax will be different off course

answered Nov 20 '18 at 10:43

GuidoG

5,28431744

I'm using XPO objects and I don't use sql syntax in my code

– mtf
Nov 20 '18 at 11:38

Well no ORM tool will do this for you, thats why you have to do sql sometimes

– GuidoG
Nov 20 '18 at 12:38

what about linq in .net?

– mtf
Nov 20 '18 at 12:51

Maybe, I havent got this working in linq yet but im no expert in that

– GuidoG
Nov 20 '18 at 13:19

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53387534%2fdisplay-relationship-in-a-devexpress-grid%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

2 Answers
2

active

oldest

votes

2 Answers
2

active

oldest

votes

answered Nov 20 '18 at 6:51

Svetlana

33613

Can you write an example in c# for this purpose, please? - @svetlana

– mtf
Nov 20 '18 at 12:56

You can download the mentioned example by using the provided link above. Once you go to there, you will see the Download button. Alternatively, you can download this project directly from GitHub (github.com/DevExpress-Examples/…)

– Svetlana
Nov 20 '18 at 19:33

add a comment |

answered Nov 20 '18 at 6:51

Svetlana

33613

Can you write an example in c# for this purpose, please? - @svetlana

– mtf
Nov 20 '18 at 12:56

You can download the mentioned example by using the provided link above. Once you go to there, you will see the Download button. Alternatively, you can download this project directly from GitHub (github.com/DevExpress-Examples/…)

– Svetlana
Nov 20 '18 at 19:33

add a comment |

answered Nov 20 '18 at 6:51

Svetlana

33613

answered Nov 20 '18 at 6:51

Svetlana

33613

answered Nov 20 '18 at 6:51

Svetlana

33613

answered Nov 20 '18 at 6:51

Svetlana

33613

answered Nov 20 '18 at 6:51

Svetlana

33613

Can you write an example in c# for this purpose, please? - @svetlana

– mtf
Nov 20 '18 at 12:56

You can download the mentioned example by using the provided link above. Once you go to there, you will see the Download button. Alternatively, you can download this project directly from GitHub (github.com/DevExpress-Examples/…)

– Svetlana
Nov 20 '18 at 19:33

add a comment |

Can you write an example in c# for this purpose, please? - @svetlana

– mtf
Nov 20 '18 at 12:56

You can download the mentioned example by using the provided link above. Once you go to there, you will see the Download button. Alternatively, you can download this project directly from GitHub (github.com/DevExpress-Examples/…)

– Svetlana
Nov 20 '18 at 19:33

Can you write an example in c# for this purpose, please? - @svetlana

– mtf
Nov 20 '18 at 12:56

You can download the mentioned example by using the provided link above. Once you go to there, you will see the Download button. Alternatively, you can download this project directly from GitHub (github.com/DevExpress-Examples/…)

– Svetlana
Nov 20 '18 at 19:33

add a comment |

From what database is this info coming ?

If you are using Sql Server you can merge the data in your query like this

declare @student table (studentid int, name varchar(20))

declare @class table (classid int, name varchar(20))

declare @studentclass table (studentid int, classid int)



insert into @student values (1, 'john'), (2, 'mary')

insert into @class values (1, 'english'), (2, 'mathematics')

insert into @studentclass values (1, 1), (1, 2), (2, 1)



select s.studentid,

       s.name,

       stuff(( replace (( select ' - ' + c.name

                          from   @class c

                            inner join @studentclass sc on c.classid = sc.classid

                          where  sc.studentid = s.studentid

                          order by c.name

                          For XML PATH ('')), '', '')

             ), 1, 3, '') as classes

from   @student s

This will return this result :

studentid   name    classes 

---------   ----    ------- 

1           john    english - mathematics   

2           mary    english

Other databases can do this also, the syntax will be different off course

answered Nov 20 '18 at 10:43

GuidoG

5,28431744

I'm using XPO objects and I don't use sql syntax in my code

– mtf
Nov 20 '18 at 11:38

Well no ORM tool will do this for you, thats why you have to do sql sometimes

– GuidoG
Nov 20 '18 at 12:38

what about linq in .net?

– mtf
Nov 20 '18 at 12:51

Maybe, I havent got this working in linq yet but im no expert in that

– GuidoG
Nov 20 '18 at 13:19

add a comment |

From what database is this info coming ?

If you are using Sql Server you can merge the data in your query like this

declare @student table (studentid int, name varchar(20))

declare @class table (classid int, name varchar(20))

declare @studentclass table (studentid int, classid int)



insert into @student values (1, 'john'), (2, 'mary')

insert into @class values (1, 'english'), (2, 'mathematics')

insert into @studentclass values (1, 1), (1, 2), (2, 1)



select s.studentid,

       s.name,

       stuff(( replace (( select ' - ' + c.name

                          from   @class c

                            inner join @studentclass sc on c.classid = sc.classid

                          where  sc.studentid = s.studentid

                          order by c.name

                          For XML PATH ('')), '', '')

             ), 1, 3, '') as classes

from   @student s

This will return this result :

studentid   name    classes 

---------   ----    ------- 

1           john    english - mathematics   

2           mary    english

Other databases can do this also, the syntax will be different off course

answered Nov 20 '18 at 10:43

GuidoG

5,28431744

I'm using XPO objects and I don't use sql syntax in my code

– mtf
Nov 20 '18 at 11:38

Well no ORM tool will do this for you, thats why you have to do sql sometimes

– GuidoG
Nov 20 '18 at 12:38

what about linq in .net?

– mtf
Nov 20 '18 at 12:51

Maybe, I havent got this working in linq yet but im no expert in that

– GuidoG
Nov 20 '18 at 13:19

add a comment |

From what database is this info coming ?

If you are using Sql Server you can merge the data in your query like this

declare @student table (studentid int, name varchar(20))

declare @class table (classid int, name varchar(20))

declare @studentclass table (studentid int, classid int)



insert into @student values (1, 'john'), (2, 'mary')

insert into @class values (1, 'english'), (2, 'mathematics')

insert into @studentclass values (1, 1), (1, 2), (2, 1)



select s.studentid,

       s.name,

       stuff(( replace (( select ' - ' + c.name

                          from   @class c

                            inner join @studentclass sc on c.classid = sc.classid

                          where  sc.studentid = s.studentid

                          order by c.name

                          For XML PATH ('')), '', '')

             ), 1, 3, '') as classes

from   @student s

This will return this result :

studentid   name    classes 

---------   ----    ------- 

1           john    english - mathematics   

2           mary    english

Other databases can do this also, the syntax will be different off course

answered Nov 20 '18 at 10:43

GuidoG

5,28431744

From what database is this info coming ?

If you are using Sql Server you can merge the data in your query like this

declare @student table (studentid int, name varchar(20))

declare @class table (classid int, name varchar(20))

declare @studentclass table (studentid int, classid int)



insert into @student values (1, 'john'), (2, 'mary')

insert into @class values (1, 'english'), (2, 'mathematics')

insert into @studentclass values (1, 1), (1, 2), (2, 1)



select s.studentid,

       s.name,

       stuff(( replace (( select ' - ' + c.name

                          from   @class c

                            inner join @studentclass sc on c.classid = sc.classid

                          where  sc.studentid = s.studentid

                          order by c.name

                          For XML PATH ('')), '', '')

             ), 1, 3, '') as classes

from   @student s

This will return this result :

studentid   name    classes 

---------   ----    ------- 

1           john    english - mathematics   

2           mary    english

Other databases can do this also, the syntax will be different off course

answered Nov 20 '18 at 10:43

GuidoG

5,28431744

answered Nov 20 '18 at 10:43

GuidoG

5,28431744

answered Nov 20 '18 at 10:43

GuidoG

5,28431744

answered Nov 20 '18 at 10:43

GuidoG

5,28431744

I'm using XPO objects and I don't use sql syntax in my code

– mtf
Nov 20 '18 at 11:38

Well no ORM tool will do this for you, thats why you have to do sql sometimes

– GuidoG
Nov 20 '18 at 12:38

what about linq in .net?

– mtf
Nov 20 '18 at 12:51

Maybe, I havent got this working in linq yet but im no expert in that

– GuidoG
Nov 20 '18 at 13:19

add a comment |

I'm using XPO objects and I don't use sql syntax in my code

– mtf
Nov 20 '18 at 11:38

Well no ORM tool will do this for you, thats why you have to do sql sometimes

– GuidoG
Nov 20 '18 at 12:38

what about linq in .net?

– mtf
Nov 20 '18 at 12:51

Maybe, I havent got this working in linq yet but im no expert in that

– GuidoG
Nov 20 '18 at 13:19

I'm using XPO objects and I don't use sql syntax in my code

– mtf
Nov 20 '18 at 11:38

Well no ORM tool will do this for you, thats why you have to do sql sometimes

– GuidoG
Nov 20 '18 at 12:38

what about linq in .net?

– mtf
Nov 20 '18 at 12:51

Maybe, I havent got this working in linq yet but im no expert in that

– GuidoG
Nov 20 '18 at 13:19

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

Search This Blog

Ufyukyu