Extracting a row out a dataset and working with it

[Cdude]

1 public void AddItem(string itemCode)
2 {
3 DataRow[] itemRow = DBAdmin.Products.Select("Code =
'"+itemCode+"'");
4 addItemRow["Code"] = itemRow[0]["Code"].ToString();
5 addItemRow["Amount"] = itemRow[0]
["SellPriceIn"].ToString();
6 addItemRow["Vat"] = itemRow[0]["Vat"].ToString();
7 addItemRow["Qty"] = 1;
8 addItemRow["DocNo"] = 2;
DBAdmin.DLitem.Rows.Add(addItemRow);
}
This my code and this is the error i get on line 4

"Index was outside the bounds of the array"

Any suggestions ? on what i am doing wrong

[Chris Shepherd]

Cdude wrote:

1 public void AddItem(string itemCode)
2 {
3 DataRow[] itemRow = DBAdmin.Products.Select("Code =
'"+itemCode+"'");
4 addItemRow["Code"] = itemRow[0]["Code"].ToString();
5 addItemRow["Amount"] = itemRow[0]
["SellPriceIn"].ToString();
6 addItemRow["Vat"] = itemRow[0]["Vat"].ToString();
7 addItemRow["Qty"] = 1;
8 addItemRow["DocNo"] = 2;
DBAdmin.DLitem.Rows.Add(addItemRow);
}
This my code and this is the error i get on line 4

"Index was outside the bounds of the array"

Any suggestions ? on what i am doing wrong

Check itemRow.Count to see if there's even any records found by your select. The
error you're getting would seem to indicate there are no entries in the itemRow
array.

Chris.

[Ignacio Machin ( .NET/ C# MVP )]

On May 5, 7:36*am, Cdude <[e-mail]:

1 public void AddItem(string itemCode)
2 * * * *{
3 * * * * * *DataRow[] itemRow = DBAdmin.Products.Select("Code =
'"+itemCode+"'");
4 * * * * * addItemRow["Code"] = itemRow[0]["Code"].ToString();
5 * * * * * *addItemRow["Amount"] = itemRow[0]
["SellPriceIn"].ToString();
6 * * * * * *addItemRow["Vat"] = itemRow[0]["Vat"].ToString();
7 * * * * * *addItemRow["Qty"] = 1;
8 * * * * * *addItemRow["DocNo"] = 2;
* * * * * * DBAdmin.DLitem.Rows.Add(addItemRow);
* * * *}
This my code and this is the error i get on line 4

"Index was outside the bounds of the array"

Any suggestions ? on what i am doing wrong

Are you sure that you are getting at least one row?

[=?Utf-8?B?UGV0ZXIgQnJvbWJlcmcgW0MjIE1WUF0=?=]

I don't see where you have created "addItemRow", but you proceed to use it
anyway. example:

DataRow addItemRow = DBAdmin.Producst.NewRow();

-- Peter
To be a success, arm yourself with the tools you need and learn how to use
them.

Site: http://www.eggheadcafe.com
http://petesbloggerama.blogspot.com
http://ittyurl.net
"Cdude" wrote:

1 public void AddItem(string itemCode)
2 {
3 DataRow[] itemRow = DBAdmin.Products.Select("Code =
'"+itemCode+"'");
4 addItemRow["Code"] = itemRow[0]["Code"].ToString();
5 addItemRow["Amount"] = itemRow[0]
["SellPriceIn"].ToString();
6 addItemRow["Vat"] = itemRow[0]["Vat"].ToString();
7 addItemRow["Qty"] = 1;
8 addItemRow["DocNo"] = 2;
DBAdmin.DLitem.Rows.Add(addItemRow);
}
This my code and this is the error i get on line 4

"Index was outside the bounds of the array"

Any suggestions ? on what i am doing wrong