partial void DeleteStudyPrograms(StudyPrograms instance);
 partial void InsertStudyPrograms(StudyPrograms instance);
 partial void UpdateStudyPrograms(StudyPrograms instance);
        protected void LinkButton3_Click(object sender, EventArgs e)
        {
            TextBox tb_NewName = (TextBox)GridView1.FooterRow.FindControl("tb_NewName");
            TextBox tb_NewAbout = (TextBox)GridView1.FooterRow.FindControl("tb_NewAbout");
            TextBox tb_NewStudyForm = (TextBox)GridView1.FooterRow.FindControl("tb_NewStudyForm");
            DropDownList ddl_NewCompetence = (DropDownList)GridView1.FooterRow.FindControl("ddl_NewCompetence");

            var sp = new StudyPrograms();

            sp.Name = tb_NewName.Text;
            sp.About = tb_NewAbout.Text;
            sp.StudyForm = tb_NewStudyForm.Text;
            sp.Competence = ddl_NewCompetence.SelectedValue;

            _eJDataContext.StudyPrograms.InsertOnSubmit(sp);
            try
            {
                _eJDataContext.SubmitChanges();
            }
            catch
            {
                _eJDataContext.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges);
                {
                    try
                    {
                        _eJDataContext.SubmitChanges();
                    }
                    catch (Exception exept)
                    {
                        Console.WriteLine("Error:  " + exept);
                    }
                }
            }

            FillCustomerInGrid();
        }