public static void Insert(Student_Grant grantToAdd) //used by that add student form to add a new record to the db
 {
     var db = new DataClassesDataContext();
     db.Student_Grants.InsertOnSubmit(grantToAdd);
     db.SubmitChanges();
 }
 partial void DeleteStudent_Grant(Student_Grant instance);
 partial void InsertStudent_Grant(Student_Grant instance);
 partial void UpdateStudent_Grant(Student_Grant instance);
    protected void AddGrant(object sender, EventArgs e)
    {
        string c;
        // Set data
        var grant = new Student_Grant
        {
            Student_ID = Convert.ToInt32(textBoxStudent.Text),
            Grant_Type = ddlVoucherType.SelectedValue,
            Grant_Value = Convert.ToInt32(textBoxVoucherValue.Text),
            Grant_Description = textBoxGrantDescription.Text,
            Date_Of_Issue = DateTime.Now,
            Kuha_Funds = Convert.ToInt32(textBoxKoha.Text),
            Student_Campus = _Campus,
            Student_Faculty = _Faculty
        };

        // Attempt to add voucher object into db
        try
        {
            Grants.Insert(grant);
        }
        catch (Exception ff)
        {
            ErrorMessage.Text = ff.ToString();
        }
    }