I am trying to using webservices to update the sql database table.
CustomerName.cs code
namespace SqlWebService
{
public class CustomerName
{
[Code]....
when I run it, the result is true but I cannot see the changes in the database!!
I want to know can php client consume asp.net web services with
1: returning basic types int, string etc.
2: returning DataSets
Am new bee to Webservices.I have declared complete BLL in the class library.
Can call those methods defined in Class library class files(.cs file) in .asmx file.
from where to start learning WebServices. I do not know anything about it, i searched internet but no useful sites were found. I am unable to understand almost all the codes written in App_Code/WebService.vb file that is generated in VS.I know some basics of ASP.NET ,VB.NET and C#.NET.
View 4 RepliesWe are making use of webservices in asp.net console application.we could able to debug the console application but we would like to debug the webmethod calling in our console app. so, how can we debug the code present in the webserices?
View 2 RepliesI have the URL of webservice of some companies in database as
Company-A http://companya.com/myservice/calculate.asmx
Company-B http://companyb.com/someservice/post.asmx
Company-C http://companyc.com/theservice/help.asmx
Company-D http://companyd.com/services/count.asmx
I want to dynamically consume these webservices. As sometime I need only CompanyA webservice, some time Company-B webservice. How I can do these.I thing I have to use WebService class (Imports System.Web.Services)
I am using ASP.NET (.asmx) web services with Silverlight. Since there is no way to find the client IP address in Silverlight, I had to log this on the service end.
These are some methods I have tried:
Request.ServerVariables("REMOTE_HOST")
HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"]
HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
Request.UserHostAddress()
Request.UserHostName()
string strHostName = Dns.GetHostName();
string clientIPAddress = Dns.GetHostAddresses(strHostName).GetValue(0).ToString();
All the above methods work fine on my local system, but when I publish my service on a production server, it starts giving errors, Error: Object reference not set to an instance of an object. StackTrace:
at System.Web.Hosting.ISAPIWorkerRequestInProc.GetAdditionalServerVar(Int32 index)
at System.Web.Hosting.ISAPIWorkerRequestInProc.GetServerVariable(String name)
at System.Web.Hosting.ISAPIWorkerRequest.GetRemoteAddress()
at System.Web.HttpRequest.get_UserHostAddress()
i m making an API in .net , that will communicate with its client with xml data. client software can be in any language php,asp.net etc. what is the best way to develop such API, i was trying to use the .net webservices', but [webmethods] does not allow non static data, and in my API there are lots of things that will work only with the non static data. any way to develpop it without using .net webservies?
View 1 RepliesI wrote some webservices in my solution and it works fine when i consume it in my local machine... BUT when i deploy it in the public IP and using https. I'm not able to consume the webservices i got a "The provided URI scheme 'https' is invalid; expected 'http'. Parameter name: via" Error...
I tried to change my configuration in my web app from security mode="None" into security mode = "transport" and I got an error... (forgot to log the error)
Note* I'm using virtual IIS (this is where i test my project)
I have following class in webservices, I am not able to override the constructer of webservice. Asp.net always call first method not the one with parameter.
[Code]....
How can i call the second constructer in asp.net? Pls provide vb.net code.
We developed webservices and provided services to Clients.As per my requirement i have to change the webmethod signature datatype.Can i handle without inform to client.
View 1 RepliesHow to solve the Cross domain issue using webservices?
View 4 RepliesI worked on an online store based . In this store i have a category for which there are almost 2000 products. So every time when there is some change in the price, it is very difficult to update the products with new price, descriptions, features etc.The manufacturer of this product is providing web services which can be linked with store owner's website who is selling their products.o is it possible to integrate e-commerce website with webservices API that are being provided by manufacturer ?
View 1 Repliesi am new to WebServices, i have a ClassDataLibrary.dll which include classes like Users,Products,Articles...
i want to create a structure like this in my webService. as i saw the examples of creating web services the web methods written on the same page. but i got over 50 methods in dll and i want to share these methods with flash so flash user get data using my webService but it will be difficult to find the method he wants so i want to give my webService in a structure like:
Service1.Users // he will finds the methods about users
Service1.Products // he will finds the product methods
how could i do it ? is there any example or something to share with me?
when I access the webservices URL through browser ,I am able to access the URL ,If i use the webmethod in c# code the error message is diplaying like "The Requested Failed with HTTP Status 404:Not found".
View 5 RepliesI have a webservice on my local pc and I am adding a refernce to it on a cleint application. It picks up the reference but when I change something on the web service and then update the reference on the client it doesn't reflect thae change.
To explain it further, I have an svc file on the server which points to a class with methods in it. I add a web efernce to this svc file on the clieint (I select "add reference-and enter the localhost address in the box for the url (http://localhost/MyService/Service/MY_SERVICE.svc).
It displays it and when I click on http://localhost/MyService/Service/MY_SERVICE.svc?wsdl it shows me the methods within the class. That is fine but if I add or remove data members in one of those methods, it doesn't reflect the cahnges when I update the reference on the client.
I can tell because if I look at the Reference.cs file that is automatically generated client-side, it shows the method but not the new data members. Instead it just shows an int and a bool passed in as parameters
If I add a new method to the class the web service is referencing, these changes are reflected client-side but if I change properties of the method they are not.
I have a webservice - called MyCompany.WebService1
I reference this using a web reference in my ASP.net web application.
Theres a method called "GetDeal" in this web service, that returns a "Deal" Object.
The deal object currently looks (for example) like this:
[code]....
This class is in a different assembly: MyCompany.Model
The web service references this assembly.
In my web app, I can call the GetDeal method. This returns Service1.Deal (service1 is just the name of the web reference)
I can access both properties above. I have now changed the Deal class, and added a couple more properties.
However, I can't see these new properties in my web application. I've updated the web service in the web application. I rebuilt the web service several times, tried removing the MyCompany.Model reference and re-addding it etc...
I can't figure out what has changed... This was working - I have changed the model before, and it's updated the reference correctly...
I am new with the subsonic, and I have a problem when trying to update the database from the sql server. I have created a gridview by still is not returning the updates results. can you please help me? its getting an error code on dc.AddMostaHse();
(Cannot implicity convert type 'void to 'object')
Here is the code being done of DataAccess.cs page
public void AddMostaHse()
{
Mosta.MostaHSE1 xx = new MostaHSE1();
[code]..
I am trying to update the table records by intering a new values in a textbox
and am facing problems in the code of dataset
how could I perform that
[code]....
You should post any code that you are having problems with in the thread (because apparently some people can't open the files attached).
Anyways, you need a TextBox on the page. Then you need to access the Text in the TextBox (using the TextBox.Text property). Once you've got that you should use it to update your database.
The best way to supply this value (that has been provided by the end user) is to use the SqlCommand.Parameters property (if you're using the SqlCommand object).
This topic is covered nicely in:
How to use database in your program Part 1
How to use database in your program Part 2
Depending upon some condition I want to send the mail to the xyz user which will have two links "Accept" and "Reject" in the message body. When the recepient clicks either of the link an update/insert should be performed in the database against a particular record. For this , when I will be sending the mail, I will be requiring to send some unique Id along with the mail depending upon which I will be able to decide which record to update in the database. I am using SQl Server 2008 and C#.net. Does any one know how to implement it in VS 2008.
View 2 RepliesDoes anyone know how i can take a row data in a datagrid and insert it into a table on my database?
I have the following code, but it doesnt seem to be working.
[Code]....
I get some data from the database that I want to use to update another Database row.I know how to do that if I put the first value on a label and then use that.//First I get the Name I want
DataTable table = GetName();
NameList.DataSource = table;
NameList.DataBind();
[code]...
I have a number of manually written scripts (.sql) for tables, views and stored procedures that are used from an ASP.NET application. These scripts drop the object and recreates them. I need a way to update the database when the scripts change without deleting the object. For example, when a column is added to an existing table that has rows in it, I would need to update this table with this extra column without losing the rows.
I need a way to "update" the database on a single click (I can hook up the changes using a batch file). Does Visual Studio support this kind of functionality?
I have a grid view and have five dropdownlist on it. I have edit update and cancel edit buttons on each row.
Drop down list is updating the database, but only first value in the dropdownlist even when user select second, third or any other value from the dropdownlist.
What could possible be the reason for this. Here is my row Edit/ CancelEdit and Updating Events.
[code]....
I have fields for a contact. 3 of those fields are drop downs to values from another table in the database. For example, Contacts has the foreign key for departmentid which pulls from the department table to get the description. But when i click the Edit and update, this does not update my database. It acts like nothing happened.
EDIT: Just noticed this, but when i change the name and click update. I get an error telling me that EmployerCode cannot be set to null. I know that the database is set to not nullable. But i do not understand why the original value is not being pulled. When i load the contact, all three of the drop downs have values from the database loaded. Although i am seeing that all three are displaying the first item in the table and not the item the contact has in it's values. But when editing the contact, it acts like those values are not loaded and are just null.
<asp:DetailsView ID="detailsViewContact" runat="server" Height="90px" Width="293px"
DataSourceID="ContactDataSource" AutoGenerateRows="False"
BackColor="#FFCC66" BorderStyle="None" BorderWidth="0px" CellPadding="3"
DataKeyNames="ContactID" Font-Bold="True" HorizontalAlign="Center">
<CommandRowStyle BackColor="White" BorderColor="White" Font-Bold="True"
Font-Size="Large" HorizontalAlign="Center" />
<Fields>
<asp:BoundField DataField="SSOID" HeaderText="SSOID"
SortExpression="SSOID" />
<asp:BoundField DataField="FirstName" HeaderText="FirstName"
SortExpression="FirstName" />
<asp:BoundField DataField="Lastname" HeaderText="Lastname"
SortExpression="Lastname" />
<asp:BoundField DataField="Address" HeaderText="Address"
SortExpression="Address" />
<asp:BoundField DataField="City" HeaderText="City"
SortExpression="City" />
<asp:BoundField DataField="State" HeaderText="State"
SortExpression="State" />
<asp:BoundField DataField="ZipCode" HeaderText="ZipCode"
SortExpression="ZipCode" />
<asp:BoundField DataField="EmailAddress" HeaderText="EmailAddress"
SortExpression="EmailAddress" />
<asp:TemplateField HeaderText="AccessRightID" SortExpression="AccessRightID">
<EditItemTemplate>
<asp:DropDownList ID="DropDownList2" runat="server"
DataSourceID="AccessRightDataSource" DataTextField="AccessRightDescription"
DataValueField="AccessRightID">
</asp:DropDownList>
</EditItemTemplate>
<InsertItemTemplate>
<asp:DropDownList ID="DropDownList3" runat="server"
DataSourceID="AccessRightDataSource" DataTextField="AccessRightDescription"
DataValueField="AccessRightID">
</asp:DropDownList>
</InsertItemTemplate>
<ItemTemplate>
<asp:DropDownList ID="DropDownList10" Enabled="false" runat="server"
DataSourceID="AccessRightDataSource" DataTextField="AccessRightDescription"
DataValueField="AccessRightID">
</asp:DropDownList>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="EmployerCode" SortExpression="EmployerCode">
<EditItemTemplate>
<asp:DropDownList ID="DropDownList5" runat="server"
DataSourceID="EmployerDataSource" DataTextField="EmployerName"
DataValueField="EmployerCode">
</asp:DropDownList>
</EditItemTemplate>
<InsertItemTemplate>
<asp:DropDownList ID="DropDownList6" runat="server"
DataSourceID="EmployerDataSource" DataTextField="EmployerName"
DataValueField="EmployerCode">
</asp:DropDownList>
</InsertItemTemplate>
<ItemTemplate>
<asp:DropDownList ID="DropDownList4" Enabled="false" runat="server"
DataSourceID="EmployerDataSource" DataTextField="EmployerName"
DataValueField="EmployerCode">
</asp:DropDownList>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="DepartmentID" SortExpression="DepartmentID">
<EditItemTemplate>
<asp:DropDownList ID="DropDownList8" runat="server"
DataSourceID="DepartmentDataSource" DataTextField="Description"
DataValueField="DepartmentID">
</asp:DropDownList>
</EditItemTemplate>
<InsertItemTemplate>
<asp:DropDownList ID="DropDownList9" runat="server"
DataSourceID="DepartmentDataSource" DataTextField="Description"
DataValueField="DepartmentID">
</asp:DropDownList>
</InsertItemTemplate>
<ItemTemplate>
<asp:DropDownList ID="DropDownList7" Enabled="false" runat="server"
DataSourceID="DepartmentDataSource" DataTextField="Description"
DataValueField="DepartmentID">
</asp:DropDownList>
</ItemTemplate>
</asp:TemplateField>
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True"
ShowInsertButton="True" />
</Fields>
here are my datasources
<asp:EntityDataSource ID="EmployerDataSource" runat="server"
ConnectionString="name=WorkStudyEntities"
DefaultContainerName="WorkStudyEntities" EnableFlattening="False"
EntitySetName="Employers" EnableUpdate="True">