Need Help To Create API To Get Sale Data

Question

User-807418713 posted

Hello

I Have One Table In SQL Server 2008 Table Name : Sale_Record

ID	Sale Date	Item Name	Product Value	Tax Amount	Net Sale Amount
1	8-Jan-19	T-shirt	500	100	600
2	8-Jan-19	Wallet	800	50	850
3	8-Jan-19	Pen	150	5	155
4	9-Jan-19	Shirt	900	100	1000
5	9-Jan-19	Bag	1000	100	1100

I'm uisng asp.net 2.0 C# i want to creare web api and share this api to my other customer so that he can see our sale record

how to do so please help me im very new to API concept

Thanks

Answer 1

User1120430333 posted

https://code.msdn.microsoft.com/CRUD-Operations-in-ASPNet-7937b816

One of the few times I will say use the generic repository pattern.

Answer 2

User-807418713 posted

Hello

I'm using asp.net 2.0 C# if any one give me example

It would be help full

Thanks

Answer 3

User-2146987983 posted

Let google help you. I found some useful links...

https://www.c-sharpcorner.com/UploadFile/8a67c0/getting-started-with-web-api-step-by-step-with-sample-applic/

https://dzone.com/articles/backend-web-api-with-c-step-by-step-tutorial

Answer 4

User-807418713 posted

Hello

Can I Able To Create API using asp.net 2.0 C# using VS 2005

Answer 5

User-2146987983 posted

Follow the discussion: https://stackoverflow.com/questions/691111/rest-from-asp-net-2-0

Answer 6

User-2054057000 posted

Hello Gopi,

You want to create Web API in ASP.NET to expose your SQL Database data to other users. You can easily create your own API, follow these 2 tutorials:

1. Tutorial – Implementing your own ASP NET Web API from Start [with Code]

2. Tutorial – Consuming ASP NET Web API from Start [with Code]

Thanks & Regards

Answer 7

User-807418713 posted

Hello

I'm using old asp.net  C# can it be posible to make API using asp.net  C# 

Can Any One Give Me Live Example Tutioral On API Using ASP.net 2.0 C# Old Version 

Web Services Enhancements (WSE) 2.0 SP2 for Microsoft .NET

IS Webservice OR API is same or different..?

Waiting For Your Reply

Thanks

Answer 8

User475983607 posted

I'm using old asp.net  C# can it be posible to make API using asp.net  C# 

Web API is a REST service.  .NET 2.0 does not include Web API.  It's possible to roll your own but that might be beyond your capability. 

IS Webservice OR API is same or different.

WSE 2.0 is a SOAP service and the predecessor to WCF.  WSE 2.0 is not REST.  ASMX will be much easier to work with and can be used to make a REST service.  A basic Google search will show tons of examples.

I recommend using the latest Visual Studio and .NET framework to build a new web application.  IMHO, It does not make sense to stick with ASP.NET 2.0. 

Answer 9

User-807418713 posted

 Hello

Which Visual Studio have Web AI 2 Controller - Empty 

To Create API

Thanks

Answer 10

User-2054057000 posted

 Hello

Which Visual Studio have Web AI 2 Controller - Empty 

To Create API

Thanks

You can find them in vs 2015 and vs 2017. You can download them from Microsoft site.

Answer 11

User-807418713 posted

Hello

Thanks YogYogi

Can We Create Web Api Using VS 2010?

Answer 12

User753101303 posted

Hi,

According to https://robertbigec.wordpress.com/2012/10/11/developing-mvc-4-web-api-with-visual-studio-2010/ it could be done but what matter much is which .NET version you'll target.

You'll likely need to use .NET Framework 4 at worst. .NET 4.5.2 is the lowest supported version. Make sure you have no other choice than still working woth outdated stuff...