Why repositoryitemlookupedit return zero value

Question

0.00/5 (No votes)

See more:

hi,
h have gridview1 that contain RepositoryItemLookUpEdit columnto make user choose items :
column Field name : stitems_ID (int(11))
RepositoryItemLookUpEdit Display Member : Name (varchar(255))
RepositoryItemLookUpEdit Value Member : stitems_ID (int(11))

st_itemsBindingSource.DataSource = Context.st_items.Local.ToBindingList();

gridview1 filled with data as : succeed

C#

purchases_itemBindingSource1.DataSource = Context.purchases_item.Where(u => u.pmain_ID == PurchasesID).ToList();

i used Entity framework to insert / update / select ..

insert operation: succeed

for (int ItemImdex = 0; ItemImdex < gridView1.DataRowCount; ++ItemImdex)
               {

                   purchases_item purchasesItem = new purchases_item();
                   purchasesItem.pmain_ID = lastid;
                   purchasesItem.stitems_ID = Convert.ToInt32(gridView1.GetRowCellValue(ItemImdex, "stitems_ID"));
                    .........

                   Context.purchases_item.Add(purchasesItem);
                   Context.SaveChanges();
               }

Update operation: failed
data loaded from mysql database to gridview successfully and right value appear in repositoryitemlookupedit , but during the update operation

C#

Convert.ToInt32(gridView1.GetRowCellValue(ItemImdex, "stitems_ID"))

return zero value not the selected value.

What I have tried:

gridview1 filled with data as : succeed
purchases_itemBindingSource1.DataSource = Context.purchases_item.Where(u => u.pmain_ID == PurchasesID).ToList();

Posted 6-Feb-18 1:34am

Golden Basim

Updated 6-Feb-18 8:28am

v2

Add a Solution

Comments

johannesnestler 6-Feb-18 13:32pm

so what was the exception? btw. you can call SaveChanges outside the Loop - so you don't talk x-times to the database during Looping...

Golden Basim 6-Feb-18 14:26pm

data loaded from mysql database to gridview successfully and right value appear in repositoryitemlookupedit , but during the update operation Convert.ToInt32(gridView1.GetRowCellValue(ItemImdex, "stitems_ID")) return zero value not the selected value.

Richard MacCutchan 6-Feb-18 15:14pm

Use your debugger to step into that line of code to find out why. Most likely some object reference, or index, is invalid.

Golden Basim 6-Feb-18 17:04pm

by using this steps i found the value of "a" in the first line = 1500 (correct value)
but the last is empty. ( i use the this code to remove old items data)
a = "";
for (int i = 0; i < gridView1.DataRowCount; ++i)
{
a = Convert.ToString(gridView1.GetRowCellValue(i, "stitems_ID")) + " / ";
}
// remove Old Items
Context.purchases_item.RemoveRange(Context.purchases_item.Where(u => u.pmain_ID == PurchasesID));
Context.SaveChanges();
//// remove Old Serials
Context.purchases_item_seriels.RemoveRange(Context.purchases_item_seriels.Where(u => u.pmain_ID == PurchasesID));
Context.SaveChanges();
a = "";
for (int i = 0; i < gridView1.DataRowCount; ++i)
{
a = Convert.ToString(gridView1.GetRowCellValue(i, "stitems_ID")) + " / ";
}

Golden Basim 6-Feb-18 17:16pm

it seam that the error here
//Context.purchases_item.RemoveRange(Context.purchases_item.Where(u => u.pmain_ID == PurchasesID));
//Context.SaveChanges();
but i don't know what is ?

Richard MacCutchan 6-Feb-18 17:51pm

Sorry, but you are going to have to do a lot more debugging. We cannot guess what the values of all your variables will be at any point.

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)