This is obviously a glaring problem in your database design. It is not a normalized design. I think you need to tell us more about the tables in the database and how they map to entities in your system. Storing 12 different subject columns and another 12 marks columns is definitely a big redundancy.
For example, if I had the following entities, I could construct relationships in my database: Tables: 1. Class 2. Subjects 3. Students 4. Marks Relationships: 1. Class — Subjects (1 — N) 2. Class — Student (1 — N) 3. Student — StudentSubjects — Marks (1 — N — 1) On Mar 28, 3:48 pm, Jeena Ajiesh <[email protected]> wrote: > Hi all, > Please suggest a way to bind the datagrid in such a way that only the marks > entered should be binded. > > I will explain a little more clear.. > > I have in database about 12 subject name and 12 mark columns. > But in some classes I'm are not using all the 12 subject and its marks. Some > may have 7 or some may have 10 subjects and its relative marks. > For eg: in Class II there is only 8 subjects. > In this case we are entering marks for only 8 subjects, in this situation > the 4 subjects and its marks remain 'zero'. > Wen i bind the datagrid with the table in the database, i should only get > that 8 subjects and its mark and not the whole 12 subjects. > How can i get that 8 subjects and marks( in this eg:) > > NB: Each time wen binding the database, based upon the class the subject > number will also increase or sometimes decrease. > > Can anyone give some idea for this situation??? > > Thanks In Advance.... > > -- > **************** > Regards, > ♪♥♫♥Ĵєєήǎ ♫♥♪♥ > Email: [email protected] > [email protected] > [email protected]
