Create web service in visual studio 2010 to retrieve data from SQL Server.

Super bro

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

Thanks, very useful... great

I'm a novice and small details like that completely throw off the tutorial because we are trying to see where you got the code for your method. Took me a couple minutes to figure out it didn't magically appear and that you had the code for these methods already typed for copy and paste. I just went to your source code and downloaded the methods.

After you add the Active x library you don't explain how the data connection just appeared under the new web method. Did you just copy and paste or was it supposed to just appear after you added the reference. Not clear what you did.

Tanks for the video, great explanation

Hello Subhroneel , In lvisual Studio 2015 Communuty , after choosing new project --> Web --> Asp.Net Web Application we have options before creating project in a small screen like Empty , Web Forms Webb Appi . Whit which we suppost to continue in this sittuation ?