Click here to Skip to main content
12,354,716 members (62,035 online)
Rate this:
Please Sign up or sign in to vote.
See more: REST
I want to insert data in SQL database using REST services (JSON response)and I have implemented them.But I couldn't understand how to  insert data without adding any client .Can I insert data directly from service-url without using client app.Because my client application is android and I want to invoke that rest service from android and insert in database..How can I insert data without using client application?
My code is :
    public interface IService1
        [WebInvoke(UriTemplate = "Appointments", Method = "POST", RequestFormat = WebMessageFormat.Json, ResponseFormat = WebMessageFormat.Json, BodyStyle = WebMessageBodyStyle.Wrapped)]
        void CreateAppointment(Appointment appointment);
    public class Appointment
        public string UserName { get; set; }
        public string AppointmentBookedForCompany { get; set; }
        public string Date { get; set; }
        public string TimeStart { get; set; }
        public string TimeEnd { get; set; }
        public string PhoneNo { get; set; }
  public void CreateAppointment(Appointment appointment)
             string str = "Data Source = . Initial Catalog = Appointment; User ID = sa; Password = 123";
             SqlConnection cn = new SqlConnection(str);
             SqlCommand cm = new SqlCommand();
             string username = appointment.UserName;
             string appointmentbookedForcompany = appointment.AppointmentBookedForCompany;
             string date = appointment.Date;
             string timestart = appointment.TimeStart;
             string timeend = appointment.TimeEnd;
             string phoneno = appointment.PhoneNo;
            cm.CommandText = "insert into BookAppointment values(@username,@appointmentbookedForcompany,@date,@timestart,@timeend,@phoneno)";
             cm.Parameters.Add(new SqlParameter("@username", SqlDbType.VarChar,50)).Value = username;
             cm.Parameters.Add(new SqlParameter("@appointmentbookedForcompany", SqlDbType.VarChar,50)).Value = appointmentbookedForcompany;
             cm.Parameters.Add(new SqlParameter("@date", SqlDbType.VarChar,50)).Value = date;
             cm.Parameters.Add(new SqlParameter("@timestart", SqlDbType.VarChar,50)).Value = timestart;
             cm.Parameters.Add(new SqlParameter("@timeend", SqlDbType.VarChar,50)).Value = timeend;
             cm.Parameters.Add(new SqlParameter("@phoneno", SqlDbType.VarChar,50)).Value = phoneno;
           cm.Connection = cn;
 My config file: <system.serviceModel>
      <service name="RESTAppointments.Service1" behaviorConfiguration="">
            <add baseAddress="http://localhost:8732/Design_Time_Addresses/RESTAppointments/Service1/"/>
        <endpoint address="http://localhost:8732/Design_Time_Addresses/RESTAppointments/Service1/ed" binding="webHttpBinding" contract="RESTAppointments.IService1" behaviorConfiguration="WebHttpBehavior"/>
            <dns value="localhost"/>
        <endpoint address="mex" binding="mexHttpBinding" contract="IMetadataExchange"/>
        <behavior name="">
          <serviceMetadata httpGetEnabled="True"/>
          <serviceDebug includeExceptionDetailInFaults="true"/>
        <behavior name="WebHttpBehavior">
    <serviceHostingEnvironment aspNetCompatibilityEnabled="true"/>
 How can I proceed further ?
Posted 30-Aug-12 19:47pm

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

You can browse the WCF service and the pass in an xml to save it without a client.

You can also use the WCF test client tool -[^].
cutie1 31-Aug-12 3:11am
Hii,,Can u please explain me briefly how to pass in an xml to save it without a client for REST services ..For SOAP services I knew how to do it(invoke procedure).But when I run the services ,I couldn't see the method getting added to the service.When I use basichttpbinding I can see the method.But I dont want to use basichttpbinding since it is a REST service

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.160621.1 | Last Updated 31 Aug 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100