Looping through Database?

Hello,

You have not said what Database you're using so I'll just give you the
looping code, you'll need to populate a DataSet object for this to
work: -

foreach(DataRow DR in DS.Tables[0])
{
myMenuId = DR["menuid"].ToString();
}

Does this help?
Phil Winstanley
Microsoft ASP.NET MVP
http://www.myservicescentral.comHi Phil,

Thanks for the reply! I'm using SQL 2000 Server!

I presume I can just use the tools in VS to create my OLE connection and then create a dataset! How do I then link this into the loop?

Thanks

for each(DataRow DR in DS.Tables[0])
{
myMenuId = DR["menuid"].ToString();
}