# Accessing rows in dataset

**URL:** <https://www.epiusers.help/t/accessing-rows-in-dataset/74642>\
**Category:** Epicor ERP 10\
**Tags:** e10\
**Created:** [January 19, 2021, 3:34pm UTC](https://www.epiusers.help/t/accessing-rows-in-dataset/74642 "2021-01-19T15:34:58Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Joel\_Bailie](https://www.epiusers.help/letter_avatar_proxy/v4/letter/j/c37758/32.png) [@Joel\_Bailie](https://www.epiusers.help/u/Joel_Bailie)\
**Post date:** [January 19, 2021, 3:34pm UTC](https://www.epiusers.help/t/accessing-rows-in-dataset/74642/1 "2021-01-19T15:34:59Z")

</div>

I am getting a PartWhereUsedDataSet through the Part adapter. The number of rows in the resulting dataset is correct so I think I am on the right track. I am trying to read certain columns in each row but am not sure on the correct C# syntax in order to get the data. Below is my code. Does anyone see what I need to do in order to get certain columns into string variables so I can do comparisons?

PartAdapter myPartAdapter = new PartAdapter(oTrans);  
myPartAdapter.BOConnect();

Erp.BO.PartWhereUsedDataSet dsWhereUsed = myPartAdapter.GetPartWhereUsed(strPartNumber, 0, 1, out bMorePages);

Erp.BO.PartWhereUsedDataSet dsWhereUsedData = myPartAdapter.WhereUsedData;

int nCount = dsWhereUsedData.PartWhereUsed.Rows.Count;  
MessageBox.Show("This is PartWhereUsed table " + nCount.ToString());

for (int nWhereUsedRow = 0; nWhereUsedRow \< nCount; nWhereUsedRow++)  
{  
string strJobNum = dsWhereUsedData.PartWhereUsed[0].ToString();  
MessageBox.Show(strJobNum);  
}

myPartAdapter.Dispose();

---

<div class="post-metadata">

**Author:** ![Jason\_Woods](https://www.epiusers.help/user_avatar/www.epiusers.help/jason_woods/32/80101_2.png) [@Jason\_Woods](https://www.epiusers.help/u/Jason_Woods)\
**Post date:** [January 19, 2021, 7:10pm UTC](https://www.epiusers.help/t/accessing-rows-in-dataset/74642/2 "2021-01-19T19:10:35Z")

</div>

I didn’t test it, but this should help:

```cs
PartAdapter myPartAdapter = new PartAdapter(oTrans);
bool bMorePages;
myPartAdapter.BOConnect();

Erp.BO.PartWhereUsedDataSet dsWhereUsed = myPartAdapter.GetPartWhereUsed(strPartNumber, 0, 1, out bMorePages);
foreach (var row in myPartAdapter.WhereUsedData.PartWhereUsed)
{
	MessageBox.Show(row.PartNum);
}
myPartAdapter.Dispose();

```

---

<div class="post-metadata">

**Author:** ![Joel\_Bailie](https://www.epiusers.help/letter_avatar_proxy/v4/letter/j/c37758/32.png) [@Joel\_Bailie](https://www.epiusers.help/u/Joel_Bailie)\
**Post date:** [January 20, 2021, 10:20am UTC](https://www.epiusers.help/t/accessing-rows-in-dataset/74642/3 "2021-01-20T10:20:07Z")

</div>

That works!!! Thank you so much!!!