SqlService1
按一下這裡以取得完整的作業清單。
GetBaseQueryDataTable
Return a BaseQueryDataTable From SQLDataBase
測試
測試表單只適用於來自本機電腦的要求。SOAP 1.1
下列是 SOAP 1.1 要求與回應的範例。預留位置顯示之處必須代入實際的值。
POST /WebService1/SqlService1.asmx HTTP/1.1 Host: 601845.iygvfni6t.asia Content-Type: text/xml; charset=utf-8 Content-Length: length SOAPAction: "http://tempuri.org/GetBaseQueryDataTable" <?xml version="1.0" encoding="utf-8"?> <soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"> <soap:Body> <GetBaseQueryDataTable xmlns="http://tempuri.org/"> <strBaseQuery>string</strBaseQuery> <strConnectString>string</strConnectString> <strI_Company>string</strI_Company> </GetBaseQueryDataTable> </soap:Body> </soap:Envelope>
HTTP/1.1 200 OK Content-Type: text/xml; charset=utf-8 Content-Length: length <?xml version="1.0" encoding="utf-8"?> <soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"> <soap:Body> <GetBaseQueryDataTableResponse xmlns="http://tempuri.org/"> <GetBaseQueryDataTableResult>xmlxml</GetBaseQueryDataTableResult> </GetBaseQueryDataTableResponse> </soap:Body> </soap:Envelope>
SOAP 1.2
下列是 SOAP 1.2 要求與回應的範例。預留位置顯示之處必須代入實際的值。
POST /WebService1/SqlService1.asmx HTTP/1.1 Host: 601845.iygvfni6t.asia Content-Type: application/soap+xml; charset=utf-8 Content-Length: length <?xml version="1.0" encoding="utf-8"?> <soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope"> <soap12:Body> <GetBaseQueryDataTable xmlns="http://tempuri.org/"> <strBaseQuery>string</strBaseQuery> <strConnectString>string</strConnectString> <strI_Company>string</strI_Company> </GetBaseQueryDataTable> </soap12:Body> </soap12:Envelope>
HTTP/1.1 200 OK Content-Type: application/soap+xml; charset=utf-8 Content-Length: length <?xml version="1.0" encoding="utf-8"?> <soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope"> <soap12:Body> <GetBaseQueryDataTableResponse xmlns="http://tempuri.org/"> <GetBaseQueryDataTableResult>xmlxml</GetBaseQueryDataTableResult> </GetBaseQueryDataTableResponse> </soap12:Body> </soap12:Envelope>