davef
Last Activity: Oct 25 '07, 07:12 PM
Joined: Sep 10 '07
Location:
-
Please post your ASP code snippet containing the functionality you're having problem with.... -
No probs Steve. BTW, on the weekend, I managed to consume Google and Amazon web services from within .NET, and all was perfectly fine (none of those I believe were written originally in MS languages, more likely in Java). The web service you're up to dealing with may simply not be fully interoperable....Leave a comment:
-
If you define a size, can it be applied to different products? If yes, then you move the price column to the mapping table such that the product price is defined by the combination of product id and size id. And it's fine to have a product with a single size - it just happens to be a one-to-one relationship inside the mapping table....Leave a comment:
-
Post the code snippet and the full exception trace....Leave a comment:
-
What you might need in your design is transform the product_size_pd s table into a mapping table and define the product sizes in a separate table named size:
table product
id_prd //Primary Key (Identity)
name_prd
price_prd
description_prd
table map_product2siz e
id_prd2size //Primary Key (Identity)
id_prd //Foreign Key from product_prd table
id_size //Foreign...Leave a comment:
-
Did the flow of control hit any print statements and what got printed?...Leave a comment:
-
Have you defined Soap and ns1 as namespaces in the header of yor XML file as in post #9? Basically, the XML looks something like this:
...Code:<?xml version="1.0" encoding="UTF-8" ?> <definitions name="UpdateWebService" targetNamespace="http://db/UpdateWebService.wsdl" xmlns="http://schemas.xmlsoap.org/wsdl/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/"
Leave a comment:
-
Does your first datatable contain the fields you're missing from the grid now?...Leave a comment:
-
A DataGridView is not hierarchical by design so you can present the contents of only one table of the dataset at a time. Try to set the DataMember property to the specific table and massage the data beforehand....Leave a comment:
-
- I would contact their tech support asking if their web service is intended to be consumed by .NET client AT ALL and if they know of ANYONE who did it before. However, this may yield little to zero results even if they say positively.
- Ask for alternative methods of communication with their datastore (e.g., they might have pre-webservice legacy protocols in place like FTP or even RPC).
- You can at last write your client in Java if you know
Leave a comment:
-
Are you in control of the Web service or at least have a say with their developers?...Leave a comment:
-
Yeah, the SOAP structure is so different I don't even know where to start. I myself haven't seen too many successful examples of web service interoperabilit y (aren't they supposed to be interoperable BTW??). As a workaround, our team and I at the time had to switch to servlets communicating with them via standard HTTP response-request pattern from .NET.Leave a comment:
-
You must have Nortwind SQL Server db installed for this sample to run. Place a DataGrid (not DataGridView) object on the form. Here's you Form_Load event handler implementation:
...Code:private void Form1_Load( object sender, EventArgs e ) { string szConn = "Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Northwind;Data Source=server-name"; string szSQL = "select * from dbo.Categories";Leave a comment:
-
Is it structurally different than that of let's say TerraService WSDL? I believe it is....Leave a comment:
-
I'd love to find the answer myself. Running wsdl.exe is what the VS studio does when you reference the webservice, you won't get a different result from the command line. I wonder what you see when you browse the WSDL page itself....Leave a comment:
-
This is a pretty common crap with non-Microsoft web services to be consumed by MS clients. I had a similar problem with Java-based web services some time ago (their datatype wouldn't be deserialized correctly in .NET). For instance, if you reference the TerraService by MS (WSDL http://terraservice.ne t/TerraService2.a smx), you won't have a trouble at all....Leave a comment:
-
First off, to be parsed, your query should look more like this:
Check if this runs OK....Code:UPDATE DB2.dbo.Names [B]SET[/B] DB2.dbo.Names.LastName = 'junk' WHERE DB2.dbo.Names.LastName is not null
Leave a comment:
-
Have you not gotten Reference.cs proxy file created under the Webservice reference folder?...Leave a comment:
-
I could post the code that builds a Master-Detail DataGrid if that would help your problem....Leave a comment:
-
Is your gridview supposed to have hierarchical Master-Detail structure?...Leave a comment:
No activity results to display
Leave a comment: