when i see my list after adding product it show error

Question

1.00/5 (1 vote)

See more:

protected DataTable tblGridRow()
{
int counta = Convert.ToInt32(Session["AddToListCount"]);
DataRow dr = dt.NewRow();
for (int i = 0; i < counta; i++)
{

dr["LG_ITEM_DSC"] = oDS.Tables[0].Rows[0]["LG_ITEM_DSC"].ToString();
dr["MFR_SKU_NUM"] = oDS.Tables[0].Rows[0]["MFR_SKU_NUM"].ToString();
string Price = oDS.Tables[0].Rows[0]["LIST_AMT"].ToString();
int length = Price.Length;
dr["LIST_AMT"] = Price.Remove(length - 2, 2);
dr["BRND_LOGO"] = oDS.Tables[0].Rows[0]["BRND_LOGO"].ToString();
dr["INV_UN_CDE"] = oDS.Tables[0].Rows[0]["INV_UN_CDE"].ToString();
dt.Rows.Add(dr);
}
return dt;
}

Posted 2-Aug-13 0:43am

Member 10184990

Add a Solution

Comments

Member 10184990 2-Aug-13 6:44am

error is (This row already belongs to this table.)in dt.Rows.Add(dr);

i have define all var

Jean A Brandelero 2-Aug-13 7:19am

Just put "DataRow dr = dt.NewRow();" inside the loop.

3 solutions

Add a Solution

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)

Pheonyx · Answer 1 · 2013-08-02T01:06:00

This question was previously posted, solutions were given and then it was deleted, why I do not know.

But this is the solution I provided:

Your issue relates to when the new datarow is created. I would change your code to this:

protected DataTable tblGridRow()
{
   int counta = Convert.ToInt32(Session["AddToListCount"]);
   
   for (int i = 0; i < counta; i++)
   {
      DataRow dr = dt.NewRow();
      dr["LG_ITEM_DSC"] = oDS.Tables[0].Rows[0]["LG_ITEM_DSC"].ToString();
      dr["MFR_SKU_NUM"] = oDS.Tables[0].Rows[0]["MFR_SKU_NUM"].ToString();
      string Price = oDS.Tables[0].Rows[0]["LIST_AMT"].ToString();
      int length = Price.Length;
      dr["LIST_AMT"] = Price.Remove(length - 2, 2);
      dr["BRND_LOGO"] = oDS.Tables[0].Rows[0]["BRND_LOGO"].ToString();
      dr["INV_UN_CDE"] = oDS.Tables[0].Rows[0]["INV_UN_CDE"].ToString();
      dt.Rows.Add(dr);
   }
   return dt;
}

I would also consider changing your for loop because at the moment it will just input the same line X number of times (where X = counta).

I would suggest changing the for loop declaration to this:

int countLimit = counta <= oDS.Tables[0].Rows.Count ? counta :  oDS.Tables[0].Rows.Count;
for (int i = 0; i &lt; countLimit ; i++)

I would also replace all instances of

Rows[0]

with

Rows[i]

If that solves your issue please accept the answer.

**Jean A Brandelero** · Answer 2 · 2013-08-02T01:20:00

Solution 3

Just move

DataRow dr = dt.NewRow();

inside the loop.

Posted 2-Aug-13 1:20am

Jean A Brandelero

Comments

Adarsh chauhan 2-Aug-13 8:18am

I agree.. +5

Adarsh chauhan · Answer 3 · 2013-08-02T01:06:00

Try this,

protected DataTable tblGridRow()
{
int counta = Convert.ToInt32(Session["AddToListCount"]);
for (int i = 0; i < counta; i++)
{
DataRow dr = dt.NewRow();

dr["LG_ITEM_DSC"] = oDS.Tables[0].Rows[i]["LG_ITEM_DSC"].ToString();
dr["MFR_SKU_NUM"] = oDS.Tables[0].Rows[i]["MFR_SKU_NUM"].ToString();
string Price = oDS.Tables[0].Rows[i]["LIST_AMT"].ToString();
int length = Price.Length;
dr["LIST_AMT"] = Price.Remove(length - 2, 2);
dr["BRND_LOGO"] = oDS.Tables[0].Rows[i]["BRND_LOGO"].ToString();
dr["INV_UN_CDE"] = oDS.Tables[0].Rows[i]["INV_UN_CDE"].ToString();
dt.Rows.Add(dr);
}
return dt;
}

I hope this will help you..

when i see my list after adding product it show error

3 solutions

Solution 2

Solution 3

Solution 1

Add your solution here

Preview 0