when to use webmethods to fetch datafrom datbase

Question

0.00/5 (No votes)

See more:

, +

Hi,
its a general discussion question, when we should use web methods to fetch data from database and whether there is any performance issue , which one is faster ADO.net or Webmethod Using Ado.net through java script or Jqyery.

Posted 21-May-14 20:09pm

kumar9avinash

Add a Solution

Comments

KaushalJB 22-May-14 5:26am

To stop postbacks we use clientside jquery or javascript...and obviously calling a webmethod is faster as we call it from clientside without performing a postback...
Performance may vary according to your size of data that you fetch or update.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RajeshvPatel · Answer 1 · 2014-05-25T04:49:00

1. If there is desktop application which is installed on multiple pc and that application interact with single database at that time you have to use web service concept.

2. Web Application => you have to give access some outside the resources at time web service is very useful. For example Now a day most of application are common for web and mobile device so at this point you use web service.

Using Jquery call is faster then post back call like using c#.net page to get response.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 2 · 2014-05-25T06:42:00

Kaushal is correct. It would depend upon the amount of data you are fetching.
Normally, WebMethod is faster than the Code Behind method of accessing the data from database. It also gives you the advantage of not Post Backing the form.

So, upto you. Decide whether you want user to experience a quicker and not Post Back interface or not.

when to use webmethods to fetch datafrom datbase

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0