Closed

asp.net and c#

I need this added to my website project...

[url removed, login to view] and consume a web service

Directions

Create the Table

1. Your web site provides a membership service that allows customers to get coupons for products. You don’t want to use Facebook to manage these accounts because your company wants to sell this information. You need to ‘show’ your manager that can provide access to your membership data, to multiple partner companies using web services.

2. Members table – Contains information about members.

3. Member details as firstname, lastname, birthdate, datajoined, membershipid, email, cellnumber

Create the Web Service

4. Create a web service named MemberList.asmx.

5. Above the WebMethod, create a private string variable named MemberCS and store the connection string from the web configuration in this variable.

6. Create a new WebMethod called GetMemberList() that will return a DataSet object.

7. Write the code to create the SQL select query that returns the email addresses of all of the members in the Members table

8. Create the connection object using the MemberCS connection string

9. Create the command object using the connection object and the SQL statement

10. Create the adapter object using the command object

11. Create the new DataSet object called dsMembers.

12. Use the Fill method with the data adapter, and send it the dataset parameter with the table name “Members”.

13. Use they keyword return and return the dataset object, dsMembers.

2. Create and consume a web service

Directions

Consume the Web Service

1. Create a new web page named GetMembersWS.aspx.

2. You will have to add a reference to your project to the [url removed, login to view] web service.

3. Then you can import the web service into your project with the keyword using, then pass the name of the solution/project in Visual Studio, a period, and then the name of the WebMethod.

4. After, you can create a variable (getMembers) to represent the new instance of a webservice

5. Then you can ‘call’ the WebMethod using the [url removed, login to view]() name such as [url removed, login to view]().

6.

2. Integrate a Web API or Web Service into your web application

Skills: ASP, ASP.NET, C# Programming, Database Development, Website Management

See more: t sql programming, sell programming code, programming statement, net configuration manager, named query, get string c, c string programming, c sharp service, c sharp object, c sharp api, c programming reference, configuration manager.net, configuration manager .net, c get string, asp net command, access programming services

About the Employer:
( 359 reviews ) Mutrah, Oman

Project ID: #10395720

22 freelancers are bidding on average $31 for this job

agilepksolutions

Hi, I’ve had a good look at your project description and I’m very interested in providing a solution. I have 4+ hands on experience on developing quality web solutions as well as desktop standalone solutions. I u More

$24 USD in 1 day
(80 Reviews)
7.7
dekinghtg

hi, i can do this for you. i have visual studio 2015 installed. any db schema for this task?

$30 USD in 2 days
(14 Reviews)
4.0
bienatwork

Dear, Kindly let me help you creating the web services. You will only need to pay for me after watching final result of the work. Best regards

$30 USD in 1 day
(7 Reviews)
3.7
$35 USD in 1 day
(5 Reviews)
3.9
indeosolutions

We are an IT company with lots of experience. We provide professional graphical design, software design, development services and applications (web / desktop / mobile). We have several years of experience designing, de More

$35 USD in 10 days
(4 Reviews)
3.6
joy151280

Hi! Thanks for posting this requirement. I am experts with design and development works. I have developed several websites in ASP.net vb. I have done research in .net I have also made several research tool in vb.net. I More

$25 USD in 2 days
(3 Reviews)
3.4
handsum

Only Pay me If you 100% Satisfy with my work As per you requirement we have a team that will definitely provide best solution to you. We do fair code with reasonable price and client satisfaction is our Responsibil More

$50 USD in 5 days
(4 Reviews)
3.6
VeteranLK

I have done projects with c# based web services for visual studio aspx projects. If you select me I can build this today itself. I know parameter validation as well. I will constantly keep contacting you if i have prob More

$30 USD in 0 days
(5 Reviews)
2.9
RightClickInfo

Hi, Thanks for sharing the requirements. We are 40+ people team and skilled in Asp.Net, and C#. We have separate team for --Development (Asp.net,C#, VB, SQL, MYSQL,Jquery,PHP) --Design (Photoshop) --Testing More

$25 USD in 1 day
(6 Reviews)
3.0
sarikaanand02

4 years experienced .Net developer, proficient in: , C#, , , SQL Server, MVC (4&5), Web API, WCF, Entity Framework, Ajax, Jquery, JavaScript, AngularJS, HTML, CSS, IIS. Over the last 4 years have been working on .N More

$35 USD in 1 day
(2 Reviews)
2.0
webdezires

Hello, This is Sachin, I have gone thru your requirements, and would be the right fit for this job, as I have expertise working on ASP.net MVC with AngularJS, NodeJS, & Bootstrap. I have been working in a similar m More

$25 USD in 1 day
(5 Reviews)
2.9
lalbertora

Hello, My name is Luis Alberto Rodríguez Angeles. I am a software developer with 8 years experience in .NET platform , I have knowledge of enterprise application development . • Programming languages ​​C # and Vb.N More

$35 USD in 3 days
(1 Review)
1.4
coelhofernandes

A proposal has not yet been provided

$35 USD in 3 days
(0 Reviews)
0.0
SAFLATECHNOLOGY

Hello Employer, Greeting from safla technology Pvt. Ltd!! We are experienced in ASP.NET 2.0-4.5, MVC 3.0- 4.5, C#, VB.NET, AJAX, [url removed, login to view], DNN 6.01- 7.01, SQL server 2005-2012, WCF, CSS3, HTML, HTML5, JavaScript, J- More

$35 USD in 2 days
(0 Reviews)
0.0
$41 USD in 3 days
(0 Reviews)
0.0
enanotech

Hello We are team of 15 developers in multiple techs ASP .NET, Web and Mobile We are interested in having the job done for you thanks

$25 USD in 10 days
(0 Reviews)
0.0
nileshmonde

A proposal has not yet been provided

$35 USD in 5 days
(0 Reviews)
0.0
essillor1

Dear Project Owner, I read through the job details extremely carefully and I am absolutely sure that I can do the project very well, I would love to work on your project. Firstly would like to share about my exper More

$20 USD in 1 day
(0 Reviews)
0.0
vivekrane1986

10 years of IT experience in development, business analysis, customer satisfaction. Strong technical skills in creating REST and eeb services using Web API and service stack framework. Cosuming services from MVC or HTM More

$30 USD in 20 days
(0 Reviews)
0.0
kamrulhasanasp

I am professional programmer on C#, ASP.NET, ASP.NET MVC, JavaScript, HTML, CSS and MS SQL server. I like to work in visual studio 2013 and Microsoft SQL server 2008. Please, Call for interview and test my skill. I More

$25 USD in 1 day
(0 Reviews)
0.0