Add rows and column at runtime and update values to database

Hi there, I have created Entity models. I would like to design a xaml in wfp to insert and update records like spreadsheet. i have attached sample entities and screenshot. Here Column represents : Subject and total Marks Rows represents : class Section and students Cell is to update marks objects in that particular subject by students

How can I add Subject(column) at run time and save it to database?

How can I Standard, ClassSection and student and their mark (Rows) in grid and save it to database?

Can anyone suggest the approach?

Below are the Models:
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Data.Entity;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace School.Model
{
public class SchoolContext : DbContext
{
public DbSet Standards { get; set; }
public DbSet Subjects { get; set; }
public DbSet ClassSections { get; set; }
public DbSet Students { get; set; }
public DbSet Results { get; set; }
}
public class Standard
{
[Key]
public int Id { get; set; }
public string Name { get; set; }
public ICollection Subjects { get; set; }
public ICollection ClassSections { get; set; }
}
public class Subject
{
[Key]
public int Id { get; set; }
public string Name { get; set; }
public int TotalMarks { get; set; }
public int? StandardId { get; set; }
public virtual Standard Standard { get; set; }
public ICollection Results { get; set; }
}
public class ClassSection
{
[Key]
public int Id { get; set; }
public string Name { get; set; }
public int? StandardId { get; set; }
public virtual Standard Standard { get; set; }
public ICollection Students { get; set; }
}
public class Student
{
[Key]
public int Id { get; set; }
public string Name { get; set; }
public int? ClassSectionId { get; set; }
public virtual ClassSection ClassSection { get; set; }
public ICollection Results { get; set; }
}
public class Result
{
[Key]
public int Id { get; set; }
public int SubjectId { get; set; }
public int StudentId { get; set; }
public int ObtainedMarks { get; set; }
public virtual Subject Subject { get; set; }
public virtual Student Student { get; set; }
}
}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Piyush Pansuriya9y ago
Hello,
Please refere below link, you will get solution of insert update delete operation ..

http://www.nullskull.com/a/1441/wpf-gridview-sample-to-insert-update-and-delete-records.aspx
dhiraj sakariya9y ago
Thanks Piyush.

I am looking solution at designing form in WPF and insert/update record and save it to database using MVVM pattern.
Piyush Pansuriya9y ago
Hello,
your save method is missing in this code.
you have to make sqlconnection using connection string
than you can add column by using sqlcommand,
"ALTER TABLE table_name
ADD COLUMN column_name DATATYPE"