WCF / ASMX :: Create A Web Service Which Consists Of CRUD Operations Create?
Jan 20, 2011
i want to create a web service which consists of CRUD operations Create, Retrieve, Update and Delete. creating web methods on insert and update operations.
if i have the web application with many pages like add order page, edit order page, and delete order page actually they also interact with the Sql Server 2008 and i also create web service page call Sales_Service.asmx. i know just i need to put something like query into Web Method in Sales_Service.asmx but i have a lot of queries, i don't know which query i should put into it and how the web page call the Sales_Services.asmx
How to create an instance of web service without adding web service reference? How to identify the server address/name where the web service is hosted from C# code?
I am new to WCF, I got a requirement like I need to expose a WCF service which will be consuming by clients. The data sent by clients must be passed by the service throughTCP IP port communication (these IP address and Port will be dynamic) to the other end.
I've created a Webservice and consumed it in a website application & i hosted the both in IIS, they are working fine. Now i've to create the WCF Service & consume the service in the web application and hosting the both in IIS. I've gone through the basicsof WCF; i found there are some contracts like Service Contract, Operation Contract, etc & also Found Interface1.cs & Service1.svc files, So don't know How to deal with these files.I'l post my webservice code and web app code, Please tell me Where should i do the modifications to convert it to a WCF Service,
I want to build a reusable control which will enable e to perform add/edit/delete operations easily. All I want to do is give the control a datasource and it will handle the rest.
What controls should I use? I want it to be as user friendly as possible.
I'm developing an asp.net web applcition that works with sql server. i'm using Entity model as DAL.I user repository pattern for my business layer, now, i'm going to design UI.this is my business layer code:
[Code]....
I have some questions: becase all of entites need to have CRUD operations, so i want to have a master page with Insert, Edit, Deleter Button and a place holder for entity form, so for each entity i create a form with this master and create textboxes and label in asp:content tag.for this to be done i konw master must have a Interface to do operations. so i wanted to define ISchoolSystemRepository<??> as a property in master page, but i must pass it T which will determined in runtime. so
I am developing web service for my windows mobile application..! But the new requirement is the web service must be an secure..! for example : My web service name is [URL] Instead of that , client wants to [URL] How I create https web service..! I am using visual studio 2008. windows 7
Is there any way i can create and host a WCF service, and my client apps just send username and passwords to the service to suthenticate them selves, without using Certificates, on client and Server side???
IF NOT:
Then is there any way i can do the above, but just using certificates on server side, i dont want all of my client apps' machines installing the certificate?
I am trying to learn to create a WCf service. My Wcf service is to return result from a Stored Proc.
The WCf Project compiled succesfully. Now I added a website to the same solution to create a web client for my WCF. When I right click my website and try to add web refrence->Web services in this solution, I see Service1, Project MyWCF, URL Service1.svc. When I select Service1, I get this error msg.
Error: The type 'MyWCF.Service1', provided as the Service attribute value in the ServiceHost directive could not be found.
I only need one textbox inside gridview and other operational buttons like add , edit , delete in gridview. I just need that these buttons can save the data in datatable like we do :
DataTable dt = new Datatable();
I don't want to save it in database at this stage. CRUD Operations using datatable inside gridview is my aim.
I have seen a sample from the Author of this BlogĀ URL....this works fine but how to apply CRUDE operations & Is it possible to set CommandName/ Command Argument using JQuery in asp.net using C#?
we need to expose a web service to the 3rd party vendor which can only call using POST protocol, NOT SOAP.So my question, is it better to build a web service or just simply .aspx page?Also is there any best practice documentation on this.
I want to create a WCF Service to transfer data to our clients application(WPF). The Data I am trying to send is as follows.
ID Code Description unit Rate 1 104200000 LIVE GOAT NOS 25 2 104200000 LIVE GOAT2 NOS 25 3 104200030 LIVE GOAT3 KGS 10 4 104202030 Water LTR 5
and so on till ~ 11000 records.
What I have done so far is. Created a service which return a list of data.
public List<Classes.TariffData> GetTariffData() { var currentTariffData = new List<Classes.TariffData>(); using (var myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString)) { const string query = "select a.ID,a.Code,a.Description,a.unit,a.rate,a.rate3 from tariff.dbo.tariffdata a, tariff.dbo.code_history b where a.id = b.id and b.endofvalidity is null"; using (var myCommand = new SqlCommand(query, myConnection)) { using (var ad = new SqlDataAdapter(myCommand)) { var dt = new DataTable("tariff"); ad.Fill(dt); currentTariffData.AddRange(from DataRow row in dt.Rows select new Classes.TariffData { Id = int.Parse(row["Id"].ToString()), Code = row["Code"].ToString(), Description = row["Description"].ToString(), Unit = row["unit"].ToString(), Rate = row["rate"].ToString(), Rate3 = row["rate3"].ToString() }); return currentTariffData; } } } } Class is as follows public class TariffData { public int Id { get; set; } public string Code { get; set; } public string Description { get; set; } public string Unit { get; set; } public string Rate { get; set; } public string Rate3 { get; set; } }
If i Limit the number of data by using const string query = "select top 300 a.ID,a.Code,a.Description. The Service works fine. But if I remove the top 300 part I get an error. What is your advice if I want a service to allow our client applications to update their data by using WCF. (11000 records.) I am using visual Studio 2010. C# .Net 4.0
I followed an example on how to create a simple web service that converts celsius to fahrenheit. It seems to work alright. After the conversion it outputs the new value in xml. What do you do with the value that's in xml? Do you use an Xmlreader to read it from the xml, or what is usually done after the value is generated in xml?
I have a WSDL, and I need to write this web service. (I am not the client, I am the provider of this service) Is there any tool and/or best approch to create this Web Service?
when i want insert a record i see an error like this
Can't perform Create, Update, or Delete operations on 'Table(MainMenuLink)' because it has no primary key.
with this codes:
MyLinqDataClassesDataContext db = new MyLinqDataClassesDataContext(); MainMenuLink li = new MainMenuLink { Link ="../error/error.aspx", LinkSubject = "subject" }; db.MainMenuLinks.InsertOnSubmit(li); db.SubmitChanges(); ShowLinks();
what is the problem?
my table have a primary key but i dont know why give an error!!!
when i want insert a record i see an error like this Can't perform Create, Update, or Delete operations on 'Table(MainMenuLink)' because it has no primary key. with this codes:
MyLinqDataClassesDataContext db = new MyLinqDataClassesDataContext(); MainMenuLink li = new MainMenuLink { Link = "www.tprogrammer.com", LinkSubject = "subject" }; db.MainMenuLinks.InsertOnSubmit(li); [code]....