I got RowNotInTableException.

Question

0.00/5 (No votes)

See more:

Hi all,

I'm developing a Order Manage System. I designed the entities as strong typed dataset, in other words, a object in then system a business object (e.g. Order, Trade or Payment) is a datarow(a strong typed datarow).
For example, a Order class(inherit DataRow) have a property - BuyerInfo(inherit DataRow). When I init a Order object and it's property BuyerInfo successfully, and get then property values of the BuyerInfo object, a RowNotInTableException threw. show the following message.
"This row has been removed from a table and does not have any data. BeginEdit() will allow creation of new data in this row."
Anyone know why? Datarow could NOT be a property datatype of a class? thanks.

these another tips here, when I change then member of then Order what saved then BuyerInfo object to a Datatable from Datarow, then exception disappeared! see following code:

Begfore Changing.

C#

#region BuyerInfo of Trade
private BuyerInfoRow m_drBuyerInfo;
/// <summary>
/// BuyerInfo of Trade
/// </summary>
public BuyerInfoRow BuyerInfo
{
    get
    {
        return this.m_drBuyerInfo;
    }
    set
    {
        if (value != null)
        {
            this.m_drBuyerInfo = value;
            this.buyer_info_id = value.tbbi_gID;
        }
    }
}
#endregion

After Changing:

C#

#region BuyerInfo of Trade
// these is only one datarow in then datatable, what saved then Buyer Information of this Trade
private BuyerInfo_tbbiDataTable m_dtBuyerInfo;
/// <summary>
/// BuyerInfo of Trade
/// </summary>
public BuyerInfoRow BuyerInfo
{
    get
        {
            if ((this.m_dtBuyerInfo == null) || (this.m_dtBuyerInfo.Rows == null) || (this.m_dtBuyerInfo.Count <= 0))
            {
                return null;
                       
            }
            else
            {
                return this.m_dtBuyerInfo[0];
            }
        }
    set
        {
            if (value != null)
            {
                if ((this.m_dtBuyerInfo != null) && (this.m_dtBuyerInfo.Rows != null) && (this.m_dtBuyerInfo.Count > 0))
                {
                    this.m_dtBuyerInfo.Clear();
                }

                if (this.m_dtBuyerInfo == null)
                {
                    this.m_dtBuyerInfo = new BuyerInfo_tbbiDataTable();
                }

                this.m_dtBuyerInfo.ImportRow(value);
                this.buyer_info_id = value.tbbi_gID;
            }
        }
}
#endregion

Posted 13-Jan-15 6:22am

KentBill

Updated 13-Jan-15 7:49am

Tomas Takac

v2

Add a Solution

Comments

Tomas Takac 13-Jan-15 14:01pm

DataRow must always be part of a DataTable. How do you create it, in the former example?

KentBill 13-Jan-15 22:47pm

Thank you, Tomas, I created the strong typed DataRow class - BuyerInfoRow in following way.
I created the entity classes of the system as strong typed DataSet. In Visual Studio .NET, I created a Datset.cs file in project, and drop a table(e.g. Order table) from Server Explorer, it creates the classes of Order(OrderDatatable, OrderRow, OrderColumn, OrderTableAdapter....), include OrderDataTable, OrderRow, OrderColumn.... Create the classes of BuyerInfo by same way, and extend then OrderRow class, added a property BuyerInfo it's datatype is BuyerInfoRow, please see the following code.

public partial class DataSet1 {

///
/// Extend the OrderRow class
///
partial class OrderRow
{

#region BuyerInfo of Order

private BuyerInfoRow m_drBuyerInfo;

///
/// BuyerInfo of Order
///
public BuyerInfoRow BuyerInfo
{
get
{
return this.m_drBuyerInfo;
}
set
{
if (value != null)
{
this.m_drBuyerInfo = value;
}
}
}
#endregion
}

Tomas Takac 14-Jan-15 3:42am

What I meant is how do you create the instance of BuyerInfoRow. I presume you create it outside of the class and then assign it to the BuyerInfo property. There must be a table into which you load the data in the first place. So my guess is you the remove the row from the original table which causes the error.

KentBill 14-Jan-15 23:26pm

Yes, you are right, the BuyerInfo property of Order object will be init when Order object created, I query the buyer information row in the table by buyer ID from order object, and assign it to the BuyerInfo property.

Tomas Takac 14-Jan-15 3:49am

Another idea. I think you should not store the parent row (buyerinfo) in the child row (order) directly but rather use data relations[^] to retrieve it on the fly. I remember doing this long time ago.

KentBill 14-Jan-15 23:30pm

You mean I should design the "Master - Detail" relationship of the entities to be data relations, instead of class and it’s properties?

Tomas Takac 15-Jan-15 2:49am

No. If you have the relations in your dataset then your properties could wrap those. So in order class you have something like this:


public BuyerInfoRow BuyerInfo
{
    get
    {
        return (BuyerInfoRow)orderRow.GetParentRow("Order_BuyerInfo");
    }
}

KentBill 15-Jan-15 20:45pm

And then in the set operation of property BuyerInfo, I query the row(s) by relation and update them?

Tomas Takac 16-Jan-15 3:57am

Please note that we haven't found the cause of the error yet. This is just me trying to find a workaround. It's a while since I worked with datasets so bear with me. But to follow up on the idea: The rows are all part of one dataset, so after you edit them you need to save the changes to the database using a DataAdapter. Now it feels like I'm stating the obvious so I probably missed the point of your question. Anyway, is there a reason you cannot use EF or linq2sql? All strongly typed there and easier to work with.

KentBill 18-Jan-15 19:54pm

I think I found why then exception was thrown. The DataRow object BuyerInfoRow being a property of another class. It was inited in a method(named MethodA) with a DataTable method - NewRow(), and the DataTable object is a local variable of the MethodA, and then the BuyerInfoRow object access by another method(named MehtodB). When MethodA finished running, the DataTable object which the DataRow object belong to was over its life circle and released, in another word, DataRow object lost its DataTable property value and RowState property changed to Detached, after that, in MethodB, while DataRow object was accessed, RowNotInTableException Throw.

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)