I have a dataset with a table adapter that has several queries. I want to execute on of the queries and fill a data table but am having trouble with this operation. Am I invoking my table adapter incorrectly? See line 56. Thanks.
//check to see if there are any nearby properties
//using the "GetNearbyProperties" method in the membersTableAdapter
//create a new DataTable to hold the results
DataTable NearbyProperties = new DataTable();
//declare a new instance of the membersTableAdapter
maineinnsDataset = new App_Code.DataAccessLayer.MaineInnsDataset();
MembersTableAdapter = new App_Code.DataAccessLayer.MaineInnsDatasetTableAdapters.membersTableAdapter();
//run the query and fill the NearbyProperties DataTable
//pass a parameter to the SQL select query (City = @City), use PreviousTown for the value
//any records returned by GetNearbyProperties?
int rows = NearbyProperties.Rows.Count;
if (rows != 0)
View Complete Post