PDA

View Full Version : DataSet and DataTable problem



Opie
2009-06-01, 12:05 PM
I've got this bit of code (below) that I have inherited in an ASP.NET project. Apparently, I can no longer use the line in red as I get this error. Can anyone rewrite that to current standards? All help is appreciated.

The lines in blue will probably have the same problem.

'System.Data.DataSet.Tables.get': cannot explicitly call operator or accessor


public ArrayList GetAlItems()
{
ArrayList objArray = new ArrayList();
DataSet objDataSet = FillControls.FillDataSet("ALL_ITEMS", ConnString);
int iDataSet = objDataSet.get_Tables().get_Item(0).get_Rows().get_Count() - 1;
if (iDataSet != -1)
{
do
{
try
{
ListItem objListItem = new ListItem();
objListItem.Text = objDataSet.get_Tables().get_Item(0).get_Rows().get_Item(iDataSet).get_Item(1).ToString();
objListItem.Value = objDataSet.get_Tables().get_Item(0).get_Rows().get_Item(iDataSet).get_Item(2).ToString();
objArray.Add(objListItem);
}
catch (Exception e)
{
string message = e.Message;
}
iDataSet--;
}
while (-1 < iDataSet);
}
return objArray;
}

Kerry Brown
2009-06-03, 07:11 AM
I haven't tested this, but how about something like ..
int iDataSet = objDataSet.Tables.Item(0).Rows.Count - 1;

or should that be Tables.Item[0]. ...

/// kdub

Opie
2009-06-03, 01:20 PM
I'll check. Thanks for the help.