Click here to Skip to main content
15,867,488 members
Home / Discussions / C#
   

C#

 
GeneralRe: C# Class Documentation on MSDN Pin
Winnie D14-Mar-17 10:40
Winnie D14-Mar-17 10:40 
GeneralRe: C# Class Documentation on MSDN Pin
CHill6014-Mar-17 12:54
mveCHill6014-Mar-17 12:54 
GeneralRe: C# Class Documentation on MSDN Pin
Mycroft Holmes14-Mar-17 14:28
professionalMycroft Holmes14-Mar-17 14:28 
GeneralRe: C# Class Documentation on MSDN Pin
Kevin McFarlane15-Mar-17 2:15
Kevin McFarlane15-Mar-17 2:15 
AnswerRe: C# Class Documentation on MSDN Pin
Afzaal Ahmad Zeeshan14-Mar-17 10:03
professionalAfzaal Ahmad Zeeshan14-Mar-17 10:03 
GeneralRe: C# Class Documentation on MSDN Pin
Winnie D14-Mar-17 11:37
Winnie D14-Mar-17 11:37 
SuggestionRe: C# Class Documentation on MSDN Pin
Richard Deeming14-Mar-17 11:15
mveRichard Deeming14-Mar-17 11:15 
QuestionDataGridView NOT adding with Entities models Pin
nabilg14-Mar-17 4:14
nabilg14-Mar-17 4:14 
Hello,
I'm using a datagridview in windowsform application and would like to make changes and adding new records into my Datagridview.
After calling the BD.SavChanges() and using the BD.ChangeTracker.Entries(), only the modified rows are updated into the SQL table and no added rows.
Can you help me for this?
The DataGridView1.DataSource is the gammeBindingSource on the Form.

This is the code form my Form:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.Entity.Infrastructure;

namespace PRODATA
{
    public partial class Gammes : Form
    {
        PRODATAEntities BD;
        public Gammes()
        {
            InitializeComponent();
        }

        private void Gammes_Load(object sender, EventArgs e)
        {
            BD = new PRODATAEntities();
            BD.Configuration.ProxyCreationEnabled = false;
            BD.Configuration.LazyLoadingEnabled = false;

            gammeBindingSource.DataSource = BD.Gammes.ToList();

        }

        private void button1_Click(object sender, EventArgs e)
        {
           
            try
            {
                foreach (DbEntityEntry entry in BD.ChangeTracker.Entries())
                {
                    switch (entry.State)
                    {
                        case EntityState.Added:
                            entry.CurrentValues["Utilisateur"] = ((PRODATAparent)(this.MdiParent)).mUtilisateur;
                            entry.CurrentValues["Dateheure"] = DateTime.Now;
                            break;
                        case EntityState.Modified:
                            entry.CurrentValues["Utilisateur"] = ((PRODATAparent)(this.MdiParent)).mUtilisateur;
                            entry.CurrentValues["Dateheure"] = DateTime.Now;
                            break;
                        case EntityState.Deleted:
                            break;
                    }
                }
                dataGridView1.EndEdit();
                gammeBindingSource.EndEdit();
                BD.SaveChanges();
                MessageBox.Show("Enregistrement effectué...", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
                gammeBindingSource.ResetBindings(false);
            }
        }
    }
}

Best regards.


modified 14-Mar-17 10:27am.

QuestionManage a timeout on a ldap connection Pin
MarcSchmidtmayer13-Mar-17 1:04
MarcSchmidtmayer13-Mar-17 1:04 
AnswerRe: Manage a timeout on a ldap connection Pin
Garth J Lancaster13-Mar-17 1:34
professionalGarth J Lancaster13-Mar-17 1:34 
GeneralRe: Manage a timeout on a ldap connection Pin
MarcSchmidtmayer13-Mar-17 2:27
MarcSchmidtmayer13-Mar-17 2:27 
GeneralRe: Manage a timeout on a ldap connection Pin
Garth J Lancaster13-Mar-17 3:02
professionalGarth J Lancaster13-Mar-17 3:02 
GeneralRe: Manage a timeout on a ldap connection Pin
MarcSchmidtmayer13-Mar-17 3:53
MarcSchmidtmayer13-Mar-17 3:53 
GeneralRe: Manage a timeout on a ldap connection Pin
Garth J Lancaster13-Mar-17 18:04
professionalGarth J Lancaster13-Mar-17 18:04 
GeneralRe: Manage a timeout on a ldap connection Pin
MarcSchmidtmayer13-Mar-17 20:19
MarcSchmidtmayer13-Mar-17 20:19 
AnswerRe: Manage a timeout on a ldap connection Pin
KamranShahid25-Nov-21 21:33
KamranShahid25-Nov-21 21:33 
GeneralRe: Manage a timeout on a ldap connection Pin
Richard Deeming25-Nov-21 21:54
mveRichard Deeming25-Nov-21 21:54 
GeneralRe: Manage a timeout on a ldap connection Pin
Richard MacCutchan25-Nov-21 23:57
mveRichard MacCutchan25-Nov-21 23:57 
GeneralRe: Manage a timeout on a ldap connection Pin
KamranShahid6-Dec-22 4:08
KamranShahid6-Dec-22 4:08 
QuestionHow to set up QuickSharp to run program in separate window? Pin
Member 1297423512-Mar-17 0:59
Member 1297423512-Mar-17 0:59 
GeneralRe: How to set up QuickSharp to run program in separate window? Pin
Richard MacCutchan12-Mar-17 21:45
mveRichard MacCutchan12-Mar-17 21:45 
AnswerRe: How to set up QuickSharp to run program in separate window? Pin
Pete O'Hanlon12-Mar-17 21:50
subeditorPete O'Hanlon12-Mar-17 21:50 
Questionmicrosoft report viewer simple invoice format code c# Pin
Member 1295109111-Mar-17 18:54
Member 1295109111-Mar-17 18:54 
AnswerRe: microsoft report viewer simple invoice format code c# Pin
Richard MacCutchan11-Mar-17 22:05
mveRichard MacCutchan11-Mar-17 22:05 
AnswerRe: microsoft report viewer simple invoice format code c# Pin
OriginalGriff11-Mar-17 22:29
mveOriginalGriff11-Mar-17 22:29 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.