.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
satyapriyanayak
Post New Web Links

Database Access Using SOAP and REST Web services

Posted By:      Posted Date: August 31, 2010    Points: 0   Category :WCF
 
Hi Guys, Can anyone post the links regarding DATABASE ACCESS USING BOTH WEB SERVICES. How to query the database using the web service. Suppose i have SQL statement like " Select empID,empName,CName from employee,company where empID=CID;".  How to  send this sql query to database server using REST and SOAP web Services?  Thank You


View Complete Post


More Related Resource Links

Access Database through WCF REST

  
 


hi,

i created a service like this

  [OperationContract (Name = "GetAllCustomer")]
        [WebInvoke(ResponseFormat = WebMessageFormat.Json,
            BodyStyle = WebMessageBodyStyle.Wrapped,
            UriTemplate="/View/Data?format={fr}",
            Method="GET"
            )]
        Customer[] GetAllCustomer();


 public class Customer
    {
        [DataMember]
        public int CNo { get; set; }
        [DataMember]
        public string CName { get; set; }
      }


  and access my db in service.svc.cs

 List<Customer> lstEmp = new List<Customer>();

            

 String connString = ConfigurationManager.ConnectionStrings["connWebOrdering"].ConnectionString;
            SqlConnection sqlConn = new SqlConnection(connString);
            sqlConn.Open();

           SqlDataAdapter da = new SqlDataAdapter("Select [cid], [cname] from [CustomerDB].[dbo].[contact] ", sqlConn);
            DataSet ds = new DataSet();
       &

Granting access to a database (Analysis Services)

  

Hello,

I need to grant access to the database (under Analysis Services).  I have a few questions.  Can I use an account that I created under the database engine (sql account) to have access to a database under the Analysis services?

 

I did some reading on MS below.  It seems to show only a domain account access under membership in Role.

http://technet.microsoft.com/en-us/library/ms175421%28SQL.100%29.aspx

 

Please advice.

Tntrac



Using the Excel Services REST API to Access Excel Data in SharePoint Server 2010 (Visual How To)

  
Learn how to use the REST API to retrieve resources such as ranges, charts, tables, and PivotTables from workbooks stored on SharePoint Server 2010.

Video: Using the Excel Services REST API to Access Excel Data in SharePoint Server 2010 (Visual How

  
Watch a short video that shows how to programatically retrieve data from an Excel workbook.

Store and Display Images from MS Access Database Using C#

  
There is only the difference of coding syntax to stream the binary data of image content type to upload it into MS Access Database using C#/VB in ASP.Net 2.0

Namespaces required:-
using System.Data.OleDb;

OleDb is used to connect the web site forms with MS Access Database using Microsoft.Jet.OLEDB.4.0

ASP.Net Upload Image to MS Access Database

  
As you learnt from the previous articles to upload image to the SQL Database in ASP.Net 2.0 and stream that image into the memory to retrieve it from the database and display it on the web page. In this article you will learn how to upload images to the MS Access database in ASP.Net 2.0

First of all create an Access Database and place it in the App_Data folder of ASP.Net web site project. Then create a table "tblImg" with the following fields:

How to access a new database ( which i created ) in isqlplus ?

  

Hi.,

I created a new database with the help of Database Configuration Assistant !

I created with the scott account

Now i'm not able to connect to the database with the connect identifier with the scott account

The error i get is.,

ERROR - ORA-12154: TNS:could not resolve the connect identifier specified.

Plz help !



SQL Data Services: The Relational Database of the Azure Services Platform

  

This article shows you the new face of SQL Data Services, explores its architecture, and shows how it is truly an extension of SQL Server in the cloud.

David Robinson

MSDN Magazine August 2009


Under the Table: How Data Access Code Affects Database Performance

  

In this article, the author delves into some commonly used ways of writing data access code and looks at the effect they can have on performance.

Bob Beauchemin

MSDN Magazine August 2009


Data Services: Access Your Data On Premise Or In The Cloud With ADO.NET Data Services

  

In this article the author looks at two versions of the same application--one consuming an on-premise Data Service, and one consuming an Azure Table Data Service to illustrate data access in the cloud.

Elisa Flasko

MSDN Magazine May 2009


Metadata: Create a Database Schema Repository with Meta Data Services in SQL Server 2000

  

SQL Server 2000 Meta Data Services is a repository technology that stores and manages metadata for SQL Server. Instead of building database schemas over and over, Meta Data Services allows you to freeze an entire schema for use in other projects. You can also use these schemas for training, testing, or debugging. In this article, the authors will review the various components of Meta Data Services and show how it can be programmed using a Visual Basic client, XML, and XSLT. They will also show you how to manage and manipulate your metadata by generating a simple database schema using a SQL Server repository.

Alok Mehta and Ricardo Rodriguez

MSDN Magazine May 2003


House of Web Services: Accessing Raw SOAP Messages in ASP.NET Web Services

  

Web Services exchange XML messages. Most of today's Web Service toolkits do their best to hide this fact from developers, by exposing a Web Service's behavior as method invocations against objects instead.

Tim Ewald

MSDN Magazine March 2003


Provisioning: Use Web Services Provisioning to Control Access, Usage, and Billing on Your Site

  

Building Web Services to provide enterprise-level solutions is only the first step. You need to take care of the infrastructure aspects of your solution as well, including provisioning, billing, security, and reporting. In this article, the author uses the .NET Framework and SQL Server 2000 to design a provisioning system that will take care of all these housekeeping tasks. He discusses the general requirements of a Web Service provisioning system, walks through the implementation, and then outlines various scenarios for putting this system to work.

Chandu Thota

MSDN Magazine December 2002


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend