Having a rather odd issue with Insert Item....

Question

4.50/5 (2 votes)

See more:

hello... i'm having a rather odd issue and i'm having trouble pin pointing where and why it's happening.... could really use some assistance with this. so i'm new to c#, been doing things in vb mostly, but i wanted to expand my languages since i work off example a lot of the time and most of the examples that i have found are in c#....so.

anyways this is my window: AddRec

C#

public partial class AddRec : Window
    {
        private BxEntities db = new BxEntities();

        private RecCollection RecData;

        private CollectionViewSource RecViewSource;
        private CollectionViewSource InViewSource;
        private CollectionViewSource DirViewSource;
        private CollectionViewSource CorViewSource;
        private CollectionViewSource HoldsViewSource;
        private CollectionViewSource LifeViewSource;
        private CollectionViewSource SpecsViewSource;
        private CollectionViewSource ToDsViewSource;

        private ListCollectionView RecView;

        private BindingListCollectionView InView;
        private BindingListCollectionView DirView;
        private BindingListCollectionView CorView;
        private BindingListCollectionView HoldsView;
        private BindingListCollectionView LifeView;
        private BindingListCollectionView SpecsView;
        private BindingListCollectionView ToDsView;
        
        public AddRec()
        {
            InitializeComponent();
        }

        public void Window_Loaded(object sender, RoutedEventArgs e)
        {
            var recs = from r in db.RecTbls
                          select r;

            this.RecData = new RecCollection(recs, db);

            this.RecSource = (CollectionViewSource)this.TryFindResource("RecViewSource");
            this.InViewSource = (CollectionViewSource)this.TryFindResource("InViewSource");
            this.DirViewSource = (CollectionViewSource)this.TryFindResource("DirViewSource");
            this.CorViewSource = (CollectionViewSource)this.TryFindResource("CorViewSource");
            this.HoldsViewSource = (CollectionViewSource)this.TryFindResource("HoldsViewSoure");
            this.LifeViewSource = (CollectionViewSource)this.TryFindResource("LifeViewSource");
            this.SpecViewSource = (CollectionViewSource)this.TryFindResource("SpecViewSource");
            this.ToDsViewSource = (CollectionViewSource)this.TryFindResource("ToDsViewSource");

            this.RecViewSource.Source = this.RecData;

            this.RecView = (ListCollectionView)(RecViewSource.View);
            this.InView = (BindingListCollectionView)(InViewSource.View);
            this.DirView = (BindingListCollectionView)(DirViewSource.View);
            this.CorView = (BindingListCollectionView)(CorSource.View);
            this.HoldsView = (BindingListCollectionView)(HoldsViewSource.View);
            this.LifeView = (BindingListCollectionView)(LifeViewSource.View);
            this.SpecView = (BindingListCollectionView)(SpecViewSource.View);
            this.ToDsView = (BindingListCollectionView)(ToDsViewSource.View);

            this.RecView.CurrentChanged += new EventHandler(RecView_CurrentChanged);
        }
        void RecView_CurrentChanged(object sender, EventArgs e)
        {
            this.InView = (BindingListCollectionView)(InViewSource.View);
            this.DirView = (BindingListCollectionView)(DirViewSource.View);
            this.CorView = (BindingListCollectionView)(CorViewSource.View);
            this.HoldsView = (BindingListCollectionView)(HoldsViewSource.View);
            this.LifeView = (BindingListCollectionView)(LifeViewSource.View);
            this.SpecView = (BindingListCollectionView)(SpecViewSource.View);
            this.ToDsView = (BindingListCollectionView)(ToDsViewSource.View);
        }

        void btnAdd_Click(object sender, RoutedEventArgs e)
        {
            this.RecView.AddNew();
            this.RecView.CommitNew();
        
            this.InView.AddNew();
            this.InView.CommitNew();

            this.DirView.AddNew();
            this.DirView.CommitNew();

            this.CorView.AddNew();
            this.CorView.CommitNew();
            
            this.HoldsView.AddNew();
            this.HoldsView.CommitNew();
            
            this.LifeView.AddNew();
            this.LifeView.CommitNew();
            
            this.SpecView.AddNew();
            this.SpecView.CommitNew();
           
            this.ToDsView.AddNew();
            this.ToDsView.CommitNew();                                                           
        }

so this is my problem exactly..... the above code for my AddRec window works to a point.

it loads, maneuvers through the records properly without being out of sync,and deletes properly but they don't AddNew right.
this is what's throwing me for a loop..... when i click my btnAdd i get a: "Object reference not set to an instance of an object." use the "new" keyword.... ok i can live with that, i screwed up somewhere.... however if i put a breakpoint at this.cor.view.addnew() and run it it runs fine... i get a new rec view, i get a new inview, i get a new dirview. and i can add to and save them. however the other views throw that exception.... except the corview, it just doesn't load a new corview, it's blank and not editable...???? i don't get it... all my views are scripted the same way. the insertitem is the same for all of them.... the btnadd is the same for all of them.... why are only 3 of them working properly and 1 of them not working at all???
i even thought i screwed something up in my db, but i use this same db in another app and it works great....
thought it was the language style so i wrote the same page (used the same xaml and everything minus the namespace) in vb, and everything works right..... where did i screw up?

i'm lost, confused and baffled. any suggestions?

thanks in advance.

here's my insert statement if it helps:

C#

protected override void InsertItem(int index, MyDAL.RecTbl item)
        {
            item.InTbls.AssociationChanged += new System.ComponentModel.CollectionChangeEventHandler(InTbls_AssociationChanged);
            item.DirTbls.AssociationChanged += new System.ComponentModel.CollectionChangeEventHandler(DirTbls_AssociationChanged);
            item.CorTbls.AssociationChanged += new System.ComponentModel.CollectionChangeEventHandler(CorTbls_AssociationChanged);
            item.HoldsTbls.AssociationChanged += new System.ComponentModel.CollectionChangeEventHandler(HoldsTbls_AssociationChanged);
            item.LifeTbls.AssociationChanged += new System.ComponentModel.CollectionChangeEventHandler(LifeTbls_AssociationChanged);
            item.SpecTbls.AssociationChanged += new System.ComponentModel.CollectionChangeEventHandler(SpecTbls_AssociationChanged);
            item.ToDTbls.AssociationChanged += new System.ComponentModel.CollectionChangeEventHandler(ToDTbls_AssociationChanged);
           
            this.Context.AddToRecTbls(item);
            base.InsertItem(index, item);

        }

Oh and i'm using ado.netentity framework, entity data model. MyDAL contains the model BxEntities with the connection string etc in the app config file.

P.S. not shouting in the bold, just need to make sure these parts are reads properly.

Posted 13-Aug-12 3:47am

ajk825

Updated 13-Aug-12 4:08am

Kenneth Haugland

v3

Add a Solution

Comments

Kenneth Haugland 13-Aug-12 9:52am

Ehh... This is too much for me. Could you just focus on your code that is the issue?

ajk825 13-Aug-12 10:09am

sorry...was just trying to be as thorough as i could. just wanted ya to have all the info needed to answer this question....

Kenneth Haugland 13-Aug-12 10:10am

No harm done :)

[no name] 13-Aug-12 9:57am

Yes... you really need to chop this down to something that is readable and relevant to your question.

Kenneth Haugland 13-Aug-12 10:13am

I think AddNew method requires a empthy class or object simular to the other rows...

ajk825 13-Aug-12 10:27am

but it still doesn't explain why 3 of them work(recview, inview, dirview will insert and save properly). 3 don't work at all(lifeview, holdsview, and ToDsview I get the error message with these 3, but if i delete them from the code block alls good), 1 doesn't work (corview) but i don't get that error message if it's in...... their all written the same way. so why am i getting the error message with the last 3 views and nothing with the corview... see what i'm asking?

Kenneth Haugland 13-Aug-12 10:40am

I have a different question, why do you use a ListCollectionView and a BindingList? Shouldnt you use an observable collection? CollectionViewSource is normally an overlay between the UI and the Code behind to allow soring of items etc.

Kenneth Haugland 13-Aug-12 10:41am

BTW. Does it work when you do that?

ajk825 13-Aug-12 11:41am

let me check.... i was following along with an example from beth massi on master/detail using entity framework...k. let me try that and see what happens.

ajk825 13-Aug-12 11:51am

ok i tried... no go. but....for my
private reccollection recdata;

reccollection is an observablecollection. I have it as a seperate class.
even then... recview, inview, and dirview work as it is. i can insert records into the database as it is written now. i checked, they are inserting. but the other ones are not....
and i looked at that post you suggested. i thought that since i was using an entity datamodel based on an existing database that all the info as far a properties and stuff were already included in the database schema?
so do i really need to rewrite all my classes and their properties?

Kenneth Haugland 13-Aug-12 14:39pm

I dont know. Do you have the link for this tutorial? It seems that you have missed something minor that is causing your problem :)

ajk825 13-Aug-12 14:56pm

yeah...sorry. http://msdn.microsoft.com/en-us/vstudio/ee364701
she does the tutorial in vb but if you scroll down to the bottom you can download the source code in c# this is what i used for an example....
you have to hook up the OMS database if you don't already have it. i put mine on my local connection and updated the database with the wizard and copy and pasted it into my app.config file and it works like it should ( i have a data access layer that's referenced by the main program so that's why i had to copy/paste ). only difference between what she did and what i did is that she used a button for her master add and 1 for her detail add. and 1 button to save both master and detail together. i just used 1 button to add master and detail. But my master is first. and i did the same thing ( 1 button for both adds ) in vb and it works...

ajk825 13-Aug-12 15:29pm

one more thing i just noticed, and i don't think this affects my problem, but i just re-ran that example i mentioned above... if i erase all the orders and customers from the example and try to start new ones, i get the same error message that i'm getting. but that's with all her info erased. i'm getting it with records existing in it. ??? just thought that was odd too..... so what's the best coarse of action here? just re-write all my classes and property values again in my program?

Christian Graus 13-Aug-12 15:39pm

Why does your insert method add event handlers ? Doesn't that mean that you end up with xxx items inserted, one more every time it;s called ?

ajk825 13-Aug-12 16:25pm

Hi Christian,
the event handler is adding a new index to my child tables...
the: item.InTbls.AssociationChanged += new System.ComponentModel.CollectionChangeEventHandler(InTbls_AssociationChanged)
is saying "hey i'm gonna add a new table,this is my recid" to the child tables... i think, at least that's what i'm gathering from all these posts and examples i'm reading.

Christian Graus 13-Aug-12 16:39pm

But once you added it, it will be called EVERY TIME the last two lines are called ( assuming they cause these events to fire ). I think you need to set up your events ONCE, and that this method should only contain the last two lines. If you add it again, it gets called twice when that event occurs.

ajk825 13-Aug-12 17:03pm

it is only being called once... there are 7 different tbls. each with it's own _AssociationChanged event handler. and they are only called when i click my add new button. which is when i want them to be called.

here is a link to the entire question.... i was told my original post was way too long so i shortened it for them...

http://social.msdn.microsoft.com/Forums/en-US/wpf/thread/b54771e5-c84f-40b8-8550-0e49f9d448e5

Christian Graus 13-Aug-12 17:29pm

Only once, ever ? It still seems to me like it's poorly written, to only work based on that assumption

ajk825 13-Aug-12 17:44pm

maybe so.. i was just following the example from beth massi (http://msdn.microsoft.com/en-us/vstudio/ee364701 link for c# example at bottom if ya wanna look at it) and she's a senior programmer at microsoft. so...???

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)