data retrieval with C#

[awmb]

I'm very new to .NET and C# and I'm having trouble retrieving information from a database. I'm trying to return the value of a field ("Name") from a DataTable using the code below, but I get the error message "not all code paths return a value" when I try to build.

Where am I going wrong?

public string GetVenueByID(int id)
{
DataSet1.tblVenueDataTable venue_top = new DataSet1.tblVenueDataTable();
DataSet1TableAdapters.tblVenueTableAdapter venue_top_info = new DataSet1TableAdapters.tblVenueTableAdapter();
venue_top = venue_top_info.GetDataByID(id);

if (venue_top.Count == 0)
{
return "xyz";
}
else
{
foreach (DataSet1.tblVenueRow row in venue_top)
{
return row.Name;
}

}

}

[Elena]

if (venue_top.Count == 0)
{
return "xyz";
}
else
{
if(venue_top.Rows.Count > 0 ){
foreach (DataSet1.tblVenueRow row in venue_top)
{
return row.Name;
}
}

}

}