web service problem

Hello,
I have a web service with single method.That method calling another method of another class.this calss having a sql query,which is fetching data from database.

I made a change in sql query to get one more filed.Then im trying to run the web service .But old out put i am getting.The change is not taking place.I restarted the iis and every thing.I hope some thing i need to configure againe.Is anybody knows this.

Thanks in advance
SatishYou need to update the web reference in your asp.net project (or wherever you are referencing it from). Delete the web reference in your project, and add a reference to your web service again.