If I have a Course table and a Student table that are related by Student PK such as (Simplified):



Course1 table which has fields

PK

Course#

StudentPK

TestScore

QuizScore

DailyScore



and Student table has fields

PK

Name



I have a stored procedure that gets the following information using a parameter to get students in Algebra1:

course#,Name and TestScore



I want to put the the above info in a devexpress grid. I can get this far from the help I already got from the forum (I use a dummy table with the correct field names) put the info into a BO and then I use a BBS to attach it to the devgrid. But how does the test scores get back to the course table?



I have simplified the layout of the tables but if we can make this work then I can apply it too the project. TIA

Hi Terry,



You can create a BO from a view but not a stored procedure (as you seem to know) however SQL Server doesn't support updatable views.



I guess you could use a view and have an unbound grid and handle all the database updates manually as you move from row to row. That being said your database does need to be structured in the way I outlined.



Cheers, Peter

oh views are not updateable. ug........ so much for my idea..... The data structure is in place, we are being allowed to do a few more things with it, I hope.

I am going to have to think about this multiple grid idea. If you scroll down the course grid to enter scores how will I be able to keep it in sink with the Student Table so the names will be correct?

TIA