Insert Data Into SQL Server Database Using WCF Service

Sign in to leave a comment.

• MH

  mohamed hashik5y agoPosted Dec 8, 2020, 8:54 AM

  Could you please sent me the web config file to [email protected]
• 

  Dinesh Gabhane6y agoPosted Nov 13, 2019, 12:14 AM

  Thanks Great effort. Really Good
• 

  Govind Mishra7y agoPosted Jul 5, 2019, 4:40 AM

  Thanks Great effort
• RS

  Rajeshwari sakharkar7y agoPosted May 10, 2019, 1:47 AM

  Could you please send web config file..
• JA

  jaime aviles8y agoPosted Nov 23, 2017, 6:32 PM

  Hello Manuel could you please send me the web.configof the wcf service to my email [email protected], thanks in advance.
• 

  chenna gadicherla9y agoPosted May 3, 2017, 7:01 AM

  This is below code is after adding WSDL file Reference page code, public FormpakAddon.ServiceReference1.ProjectResponseInfo[] executeAddProject(FormpakAddon.ServiceReference1.ProjectDto[] listProject) { FormpakAddon.ServiceReference1.executeAddProject inValue = new FormpakAddon.ServiceReference1.executeAddProject(); inValue.listProject = listProject; FormpakAddon.ServiceReference1.executeAddProjectResponse1 retVal = ((FormpakAddon.ServiceReference1.ProjectWebServicesSEI)(this)).executeAddProject(inValue); return retVal.@return; } FormpakAddon.ServiceReference1.ProjectWebServicesSEIClient objServiceClientobjService = new FormpakAddon.ServiceReference1.ProjectWebServicesSEIClient(); List<ProjectDto> ListPrjDetails = new List<ProjectDto>(); ProjectDto objPrjDetails = new ProjectDto(); objPrjDetails.projectTemplateName = "Chenna"; objPrjDetails.status = "Active"; objPrjDetails.statusComment = "Thisistest"; ListPrjDetails.Add(objPrjDetails); objServiceClientobjService.executeAddProject( ) .Now how can i insert this above details into server database. Any one have idea please help me.
• H

  hnieef9y agoPosted Apr 21, 2017, 12:37 AM

  Hi. how bout insert master and child table like supplier and product detail. thank you
• KR

  kalu singh rao10y agoPosted Jul 4, 2016, 2:08 AM

  Nice...
• SM

  sahar movahed11y agoPosted Sep 21, 2015, 3:58 AM

  i have an e-shop with mysql (php) and a warehouse website with SQL server 2012(asp), i want write a service with WCF that when customer bye a good from my e-shop,insert a record into both database.how can i do this? or is there another secure solution for insert into different database?
• YD

  Yamini Dwivedi11y agoPosted Aug 31, 2015, 5:45 AM

  No connection could be made because the target machine actively refused it
  • 

    Rashmi Ransingh10y agoPosted Feb 6, 2016, 1:57 PM

    the service needs to be running at the time of program execution
• KC

  Ken Cini11y agoPosted Jul 30, 2015, 3:16 AM

  Thanks this article helped.
• GM

  Gabriel Mandefu12y agoPosted Aug 7, 2014, 9:05 AM

  i have follow up the instruction in this document. unfortunately it doesn't work for me. Got an internal error stating the server was unable to process the request due to an internatl error.
• 

  Jitendra Kumar12y agoPosted Jun 16, 2014, 2:35 AM

  Thanks Sir ji..
• IH

  ibrahim haruna12y agoPosted Jun 13, 2014, 4:54 AM

  Hi Thanks for your article. Please how about if the values that i need to insert is coming from another table from another database. How am i going to do about this? thanks.
• 

  Prerana Tiwari12y agoPosted Jun 10, 2014, 6:46 AM

  Good article sir
• DR

  dwi rio12y agoPosted Mar 12, 2014, 3:47 AM

  This article helped me, Thanks a lot
• H

  Hima12y agoPosted Mar 10, 2014, 1:15 AM

  Nice Article, Thanks a lot...
• AB

  anil babu13y agoPosted Jun 17, 2013, 5:35 AM

  Hi, This is my table CustId(PK) ID Email PhoneNO 1 101 [email protected] 22222222 2 201 [email protected] 33333333 3 301 [email protected] 44444444 I want Create wcf service to take tag ID email/phone number and send back CustId How can i do this? Pls give the code for sample for this
• TV

  teja vishwa13y agoPosted Apr 8, 2013, 9:09 AM

  how to insert image into database with help of wcf
• SK

  sudeep kushwaha13y agoPosted Mar 18, 2013, 5:28 AM

  Inserting into database will create problem when multiple clients e.g 200-250 will access the service at a time? Is there any other way to do so.?
• 

  Santosh Yadav13y agoeditedPosted Jan 6, 2013, 11:52 AMEdited Jan 6, 2013, 11:54 AM

  very helpful article to begin with wcf. Thank you. But i want to ask you one thing while inserting data using wcf why we declare variables when we have properties for the same.....
• JP

  joaquim passinhas13y agoPosted Dec 12, 2012, 7:03 AM

  Hi sir. In IService1.cs file i was following your code, but in [OperationContract] string InsertUserDetails(UserDetails userInfo); UserDetails not appear. Please tell me which references use
• 

  Rohatash Kumar14y agoPosted Sep 19, 2012, 11:28 PM

  Thanks. Sushil
• RS

  Ravin Singh14y agoPosted Sep 7, 2012, 2:50 AM

  hi sir! we need access the web service from html web page using javascript how we do? for example access the data from the sql server using webservice and display the data's in html page that is our requirement please help me
  • HN

    Harish Nani12y agoPosted Nov 19, 2013, 11:44 PM

    Hi Ravin singh did u get your requirement. If so plz let me know. My requirement is also some what same as yours.
• 

  sushil kumar14y agoPosted Aug 19, 2012, 12:52 AM

  Thank U for giving a knowledge of wcf.
• BT

  balaji thirunavukarasu14y agoPosted Aug 4, 2012, 4:10 AM

  how to add wcf test client service.please give me idea
• 

  Rohatash Kumar14y agoPosted Jul 24, 2012, 4:28 AM

  Thank you sir. I will do it in my next article.
• 

  Mahesh Chand14y agoPosted Jul 21, 2012, 1:43 AM

  This is good Rohtash. What you should do is, build an application that will display data in a GridView and do add, update, and delete operations.